Insert foreign key reference in entity frameowrk 3.5

Question

Hello All:

I have 3 tables a. Employee (EmpID (pk), EmpName) b. Department (DepID (pk), DepName) c. EmployeeDepartmentMapping (ID (pk), EmpID(fk), DepID(fk))

When I am inserting new employee, I want to insert correspoding Emp-Dep mappings in the EmployeeDepartmentMapping table using entity framework 3.5. Can any body help/tell me how to insert many-many relationships using entity framework in database?

Thanks, Ashwani

Answer 1

Employee emp = new Employee();

EmployeeDepartmentMapping edm = new EmployeeDepartmentMapping();
edm.Emp = emp;

if u know the dept id. then

edm.Dept = _ent.Department.where(i => i.deptId == dept_id).first();

_ent.AddToEmplyee(emp);
_ent.AddToEmployeeDepartmentMapping(edm);

Answer 2

emp.<RolesEmpMapTable>Refernce.Load();
emp.<RolesEmpMapTable>.Role = _ent.Roles.where(i=>i.roleId == role_id).first();