sql left join 对应的linq 左连接表达式

Question

Select * from temp1 leftjoin temp2 on temp1."基站名"=temp2."基站名"

            怎样转换成linq?

Answer 1

from x in temp1
join y in temp2 on x.基站名 equals y.基站名 into g
from z in g.DefaultIfEmpty()
select new { x, z }