sql转Linq问题

[h1542565399]

select * from dbo.Employees_Infor left join dbo.Position_Promotion_Form
on Employees_Infor.Emp_Code=Position_Promotion_Form.EmpCode where Emp_Code='Z120583'
转成linq怎么查啊

[threenewbee]

var query = from x in db.Employees_Infor
            join y in Position_Promotion_Form on x.Emp_Code equals y.EmpCode
            where x.Emp_Code == "Z120583"
            select new { x, y };

[q107770540]

var query= from ei in dbo.Employees_Infor
join pp in dbo.Position_Promotion_Form.Where(p=>p.EmpCode =="Z120583")
on ei.Emp_Code equals pp.EmpCode into t
from pp in t.DefaultIfEmpty()
select new{ei,EmpCode=pp==null?"":pp.EmpCode};

[csdn_风中雪狼]

[Quote=引用 1 楼 的回复:]
C# code
var query = from x in db.Employees_Infor
join y in Position_Promotion_Form on x.Emp_Code equals y.EmpCode
where x.Emp_Code == "Z120583"
select new { x, ……
[/Quote]
++1

[风一样的大叔]

var query= from ei in dbo.Employees_Infor  
  join pp in dbo.Position_Promotion_Form.Where(p=>p.EmpCode =="Z120583")
  on ei.Emp_Code equals pp.EmpCode into t
  from pp in t.DefaultIfEmpty()
  select new{ei,EmpCode=pp==null?"":pp.EmpCode};

++