使用文本值的LINQ连接

如果只需要RightResultId为3的项,则使用Where子句筛选其他项。我不认为这真的属于连接子句。可能有用,但我觉得很乱。

var query = from left in LeftPeople
            where left.RightResultId = 3
            join right in RightPeople.Where(r => r.LeftResultId = 7)
            on left.RecordId equals right.RecordId
            select new { LeftPerson = left, RightPerson = right };

那是假设 RecordId

LeftPeople.ResultId和RightPeople.ResultId的筛选器属于LINQ语句中的Where子句:

var query = from l in LefPeople
            join r in RightPeople on l.RecordId equals r.ResultId
            where r.ResultId == 3 && l.ResultId == 7
            select new { LeftPerson = l, RightPerson = r };

也就是说,我可能认为SQL查询的WHERE子句中也应该包含这些过滤器。

如果你建立了联系,你可以写:

from left in leftPeople
where left.ResultId == 7
from right in left.RightPeople
where right.ResultId == 3
select new {left, right};