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