views:

17

answers:

1

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.

+1  A: 

Unfortunately I believe the answer is no. But If you find a clever way to handle this, asside from creating a new Entity Set. Let me know.

John Hartsock
Funny, I was going to qualify my question by saying I didn't want to create a new entity set either. Thanks anyways!