Left Outer Join using Entity Framework and Lambda Expressions

c# entity-framework lambda linq-to-entities

Question

Employee
id, name, datejoin, deptID

another table, which is

Marketing 
id, name, deptID

I want to add the name and deptID from the Employee table into the Marketing table if it doesn't already exist by searching for the deptID from the Employee table in Marketing. In essence, I think it is the left outside connect.

Using EF and lambda expressions, I am attempting to Since I'm new to this, I was unsure of how to go about doing that. I need to determine the lambda expression after creating the entities successfully.

tTlEntities sde = new tTlEntities();
sde.t_Marketing.Where(x=>x.deptID == t_Employee.deptID).

I just went as far as that. I am aware that some outer joining is required. Help I need it

1
4
5/23/2013 6:24:34 AM

Popular Answer

ZZZ_tmp
7
5/23/2013 11:43:39 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow