asp.net-mvc - Linq Select语句-不在何处

Question

我正在尝试写等效于以下内容的LINQ语句:

select e.EmployeeID, EmployeeName = e.FirstName + ' ' + e.LastName
from Employees e
where e.EmployeeID not in
(
    select EmployeeID from Managers
)

我认为我与以下内容非常接近:

from e in Employees
where e.EmployeeID !=    // This is where I'm lost
(
    from m in Managers select m.EmployeeID
)
select new
{
    e.EmployeeID,
    EmployeeName = e.FirstName + ' ' + e.LastName
}

我正在尝试将其放入Html.DropDownList。

Answer 1

我不确定这是什么正确的查询符号，但是下面的扩展语法会完成这项工作

var result = Employees
  .Where( e => !Managers.Where(m => m.EmployeeId == e.EmployeeId).Any())
  .Select( e => new { EmployeeId = e.EmployeeId, EmployeeName = e.FirstName + ' ' + e.LastName);