I have 2 tables Projects and Employees, they need a many to many relation so I created another table Projects_Employees with an id, a project_id and an employee_id
Does anyone know the correct way to use this in MVC3 or have existing code or a tutorial for this?
Basicly i want to be able to create a new project (it has a name, date and employees) select the employees with tick boxes and save it.
When I delete an employee i'm not gonna delete it from the DB but simply set the bit field visible to false so it doesn't show up in the tickboxes again if a new project has to be created.
What is the best way to setup the models controllers and view?
BorrieRulez
Member
18 Points
60 Posts
MVC3 and Many to Many Relations SQL
Apr 06, 2012 04:32 PM|LINK
Hey everyone,
I have 2 tables Projects and Employees, they need a many to many relation so I created another table Projects_Employees with an id, a project_id and an employee_id
Does anyone know the correct way to use this in MVC3 or have existing code or a tutorial for this?
Basicly i want to be able to create a new project (it has a name, date and employees) select the employees with tick boxes and save it.
When I delete an employee i'm not gonna delete it from the DB but simply set the bit field visible to false so it doesn't show up in the tickboxes again if a new project has to be created.
What is the best way to setup the models controllers and view?
Tx,
Borrie