use in/join into lambda expression in Entity FrameWork

Question

Hi there i have one sql query as below.

select * 
from Customers as C 
where
c.CompanyID in (
  select CompanyID 
  from Projects 
  where Projects.ID in (
    select ProjectAssignment.ProjectID 
    from ProjectAssignment 
    where ProjectAssignment.EmployeeID = 7 
  ) or Projects.ID in (
    select T.ProjectID
    from Tasks as T 
    where t.AssignedUserID = 7
  )
)

How can i write it with lambda expression?

Naor · Accepted Answer · 2011-07-26 00:10:43Z

1

Try that (not sure it working):

var projectIds1=ProjectAssignment.Where(pa=>pa.EmployeeID ==7).Select(ps=>pa.ProjectID);

var projectIds2=Tasks.Where(t=>t.AssignedUserID ==7).Select(t=>t.ProjectID);

var companyIds=Projects.Where(p=>projectIds1.Contains(p.ID) || projectIds2.Contains(p.ID)).
    Select(p=>p.CompanyID);

var result=Customers.Where(c=>companyIds.Contains(c.CompanyID));

answered Jul 26, 2011 at 0:10

Naor

24.3k50 gold badges158 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

use in/join into lambda expression in Entity FrameWork

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related