Entity Framework Self Join & Child Objects

0
votes

Using Entity Framework in .net 4.0, how do you set up an entity for the object below?

I have an item that people can comment on and then people can comment on comments and so on

Ex:

Item -Comment --Comment --Comment ---Comment -Comment -Comment --Comment

My current table structure in sql:

Comments

ID (int) ParentCommentID (int) ProductID (string) Title Text

Thanks

1
entity-framework-4

1 Answers

0
votes

A good idea would be to check out the Stack Overflow Creative Commons Data Dump.

They have a similar setup for post/comments, so you can see how they setup their schema. Hanselman also has a blog post on a OData service for it here, so you can check out his EDMX.

Your on the right track though:

  • Item 1..* Comments
  • Comment 1..* Comments

You'll need to setup ParentCommentID as self-referencing FK, then when you import that into your EDMX Entity Framework should model it correctly. You might need to rename the nabigational property to something more meaninful.

Good luck!