I would like to be able to model a many-to-many relationship that has extra details about the relationship. For example:
Person: int id, String name
Project: int id, String name
ProjectPerson: Person.id, Project.id, String role
Whenever I create the ProjectPerson
association in the EF, I am unable to add the role attribute to the association. If I create the tables in my DB and then import it into the model, I lose the extra properties.