title: Linq Select Statements - Where Not In
body: <p>I'm trying to write up the LINQ statement that is equivalent to: </p>
  
  <pre><code>select e.EmployeeID, EmployeeName = e.FirstName + ' ' + e.LastName
  from Employees e
  where e.EmployeeID not in
  (
      select EmployeeID from Managers
  )
  </code></pre>
  
  <p>I think I'm pretty close with the following:</p>
  
  <pre><code>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
  }
  </code></pre>
  
  <p>I'm trying to put this into a Html.DropDownList.</p>