Same table relationship in Entity Framework

Question

Is it possible to have an association mapping a table to itself?

e.g.

Table:  
ConditionId  
ConditionName 
... 
...  
ParentConditionId

where we can have many ParentConditionIds each mapping to the same ConditionId.

I've tried a one to many mapping but I'm getting an error when there is no children.

Answer 1

Yes it is possible. Put the FK in your database and the wizard will map it correctly. Make sure ParentConditionId is nullable.

Answer 2

Take a look tutorial which can be download here . It explains in detail how to model self-reference table.