左連接：

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;

如果想實(shí)現(xiàn)右連接，就把兩個(gè)表?yè)Q一下位置。

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;