例如有三张表,A,B,C
A和B先inner join,然后结果集在和C做left join
linq应该如何实现。
var q = from a in A
join b in B
on a.a1 equals b.b1
join c in C
on b.b2 equals c.c1 into g
from p in g.DefaultIfEmpty()
select new
{
a1 = a.a1
b1 = b.b1,
c1 = c.c1
};
检查了一下 id 写错了。。