0

I have employee table, which looks as below

enter image description here

I have employeedetails table, which looks as below

enter image description here

I have performed left join using SQL query, it works well.

SELECT E.* FROM Employee E
LEFT JOIN EmployeeDetails ED ON ED.EmpId = E.EmpId
WHERE ED.EmpDetailsId IS NULL

enter image description here

I need same result as above using LINQ to Entities and also lambda expression. How to do these using both ways (LINQ and LAMBDA)

user1030181
  • 1,995
  • 5
  • 26
  • 56
  • Where will you be calling the LINQ/Lambda expression from? C#? If so, what are the corresponding classes? – vsnyc Nov 15 '15 at 03:01
  • I will be using it in webforms using entity framework, and i have employees and employeedetails entities – user1030181 Nov 15 '15 at 03:02
  • Try [this answer](http://stackoverflow.com/questions/584820/how-do-you-perform-a-left-outer-join-using-linq-extension-methods) or [this](http://stackoverflow.com/questions/30525830/linq-lambda-left-join-with-an-inner-join) – vsnyc Nov 15 '15 at 03:25

0 Answers0