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

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

            怎样转换成linq?

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

var query = from x in temp1.AsEnumerable()
join y in temp2.AsEnumerable()
on x.Field("eNodeBID") equals y.Field("eNodeBID") into ttt
from z in ttt.DefaultIfEmpty()
select new { x, z };
foreach (var obj in query)
{
DataRow dr = dtall.NewRow();
dr.ItemArray = obj.;
dtall.Rows.Add(dr);
}

                            有问题啊