Convert SQL to LINQ to Entities WHERE IN clause

Question

How can I convert this sql statetment to LINQ to Entities?

SQL Statement:

Select * from Departments where DepartmentID  in (Select DepartmentID from Employees where FirstName like '%FirstName%' or LastName like '%LastName%')

All I have is WHERE =(equals) , I can't do the WHERE IN clause

LINQ to Entities:

from t in db.Departments
where
  t.DepartmentID == -->Should be IN not EQUALS
    ((from t0 in db.Employees
    where
      t0.FirstName.Contains("FirstName") ||
      t0.LastName.Contains("LastName")
    select new {
      t0.DepartmentID
    }).FirstOrDefault().DepartmentID)
select t

Take a look http://stackoverflow.com/q/857973/1920232 – peterm May 15 '13 at 02:28 — peterm, May 15 '13 at 02:28

score 0 · Accepted Answer · answered May 15 '13 at 02:37

0

(from d in db.Departments
 join e in db.Employees
     on d.DepartmentID equals e.DepartmentID
 where e.FirstName.Contains("FirstName") ||
       e.LastName.Contains("LastName")
 select t).Distinct()

answered May 15 '13 at 02:37

jdl

1,104
8
12

score 0 · Answer 2 · answered May 15 '13 at 02:52

u could use this

var x = 
    (from t0 in db.Employees
    where
      t0.FirstName.Contains("FirstName") ||
      t0.LastName.Contains("LastName")
    select new {
      t0.DepartmentID
    }).FirstOrDefault().DepartmentID;

from t in db.Departments
where
  t.DepartmentID.contains(x.DepartmentID)
select t

Convert SQL to LINQ to Entities WHERE IN clause

2 Answers2

Linked