左连接: var leftJoin = from p in entities.People join w
in entities.works on p.id equals w.peopleID into
xing from x in
xing.DefaultIfEmpty() select p;
如果想实现右连接,就把两个表换一下位置。
var rightJoin = from w in entities.works
join p in entities.People on w.peopleID equals
p.id into xing from x in
xing.DefaultIfEmpty() select x;
|