c# - 如何将此查询更改为 linq to sql？

Question

查询:

select emp.empname as Name, dep.depname as Department 
from Employee as emp 
inner join Department as dep on emp.depid=dep.depid 
where emp.id='2'

如何将其更改为 linq to sql？

Answer 1

var id = 2;
var qry = from e in db.Employees
          where e.Id == id
          select new {
              Name = e.EmpName,
              Department = e.Department.DepName
          };

(假设员工和部门之间的父关联在 DBML 中定义)

如果您恰好期望这样一个:

var record = qry.Single();
Console.WriteLine(record.Name);
Console.WriteLine(record.Department);