Entity Framework - How do create an association to/from the same entity?

Question

Hi,

In Entity Framework (VS2010) how do I create an association to/from the same table? (a many-to-many is what I want)

Background - I was expecting under the bonnet a NODE and RELATIONSHIP table, where the latter has a parent_node_id and a child_node_id (i.e. pointing back to the NODE id column). I can't seem to get the designer to add it...

Answer 1

Model first: create entity, right click: add association, select same Entity, mark it Many to many on both ends.

Database first: create two tables: Node and Edge, Edge contains two Node references. (Using appropriate PK, FK's).