当涉及两个以上的表时，如何将类似字段上的单个表的两个左连接转换为LINQ ?

Question

这是查询:

SELECT colA, colB, colC
FROM TableA 
LEFT JOIN TableB 
ON TableA.colA = tablea.colA
LEFT JOIN TableC 
ON TableA.colA = TableC.colA

这是我的LINQ代码:

from a in TableA
join b in TableB on a.colA equals b.colA 
join c in TableC on a.colA equals c.colA 
select new { values here}

但它似乎不工作。

下面是我们将要使用的模式

Answer 1

try this

data= (from a in TableA
join b in TableB on a.colA equals b.colA into bj
from b in bj.DefaultIfEmpty()
join c in TableC on a.colA equals c.colA  into cj
from c in cj.DefaultIfEmpty()
select new { a.Cola,b.Colb, c.Colc}).ToList();