tags:

views:

26

answers:

0
+1  Q: 

EF 4.0 Self Referencing Many-To-Many relationship with Additional attribute

I'm using EF 4.0 and was able to create self referencing many to many relationship. Person and family members. What I also want is to add additional attribute like 'mother', 'brother', 'sister' for each relationship. At the database level, this model generates two tables. Person and PersonRelationship. PersonRelationship table has person_id, and relative_id as PK. I like to have another column relationshiptype in PersonRelationship table and reference in EF 4.0. Please let me know how to do it if you don't mind?

related questions

Best method of profiling Entity Framework 4 dynamic queries?
Unique Keys not recognized by Entity Framework
caching problem in entity framework 4
Inserting an entity related to another using POCOs with EF
one-to-one relationships in Entity Framework 4 v2 with POCO
'Generic' ViewModel
named connection not found (Entity framework problem)
Using ADO.net Entity Framework 4 with Enumerations? How do I do it ?
Entity Framework 4.0: Why Would One Use the Code Generated EntityObjects Over POCO Objects?
Retrieve only base class from Entity Framework
EF4 POCO - Updating a navigation property
Using an Interface with a navigation property
EF4 POCO one to many Navigation property is null
Silverlight 4.0 + MVC 2.0 + WCF RIA Services + EF 4.0 = Load Error
How can I add constraints to an ADO.NET Entity?
Entity Splitting with Code Only
Using sql date data type and EF4
Table per hierarchy inheritance with POCO entities in Entity Framework 4
Is there any way to install EF4 on VS2008 SP1?
RIA services, EF and stored procs
Mocking Entity Context in EF4
Entity Framework 4 Multiple Object Delete(RemoveAll)
Exclude a field/property from the database with Entity Framework 4 & Code Only
.NET 4.0 CTP and EF CTP - is it good enough for production code?
Selecting particlar fields with EF4.0