Question

I have an MSSQL database with LINQ to SQL.
I have three tables.
Requests -> id, string name
Results -> id, requestID, int jumps
Places -> id, resultID, int location

Then, using an input string, I need to get an ICollectable or array or something of Place which meets the following:
Each Request that has name=input, take its ID.[you can assume only one has]
Each Result that has requestID=ID[from above] - take its id.
Each Place that has resultID= id[from above] - append to array for further processing.

我通过在所有<代码>Results上登出,然后执行另一个<代码>LINQ说明,但该说明的极端缓慢[仅请求约500万立方米!]。 ∗∗∗∗

谢谢!

Edit:名人,我也需要按结果分类。 aka a 职位清单,而每个内部名单则包含一个栏目:<代码>Result。

Answer 1

您可在林克2Sql通过加入关键词来做桌子:

var places = from request in Requests 
             join result in Results on request.Id equals result.requestID
             join place in Places on result.Id equals place.ResultId
             where request.name = input
             select place;

Answer 2

类似

Requests.Where(r => r.name == input).Results.Places.Select();

如果这种速度太慢,我就期望你们需要一些指数。

如果你在模式上没有关系,那么你就必须在表格上确定一些外国关键制约因素,以重建你的模式。

友情链接