Relationship on same table with Entity Framework

Question

How can I specify a realtionship on the same table using Entity Framework?

My table 'Items' has the following fields: - Id (uniqueidentifier) - ThreadId (uniqueidentifier) - Created (datetime) - Text (nvarchar(max))

My model 'Item': - Id (Guid) - ThreadId (Guid) - Created (DateTime) - Text (string) - ChildItems (Icollection)

How can I create the relationship so that ChildItems holds the items with Id = ThreadId?

Do you mean using Code First approach or other? – Juraj Suchár May 23 '12 at 10:20 — Juraj Suchár, May 23 '12 at 10:20

score 5 · Accepted Answer · answered May 23 '12 at 10:24

5

I think the following shall do it:

modelBuilder.Entity<Item>()
                    .HasOptional(c => c.ChildItems)
                    .WithMany()
                    .HasForeignKey(c => c.ThreadId);

answered May 23 '12 at 10:24

daryal

14,643
4
38
54

Juraj Suchár · Answer 2 · 2012-05-23T11:21:59.040

2

The Item entity

public class Item
{
    public Guid Id { get; set; }
    public Guid ThreadId { get; set; }
    public ICollection<Item> ChildItems { get; set; }

    /* Other properties */
}

And the fluent configuration

modelBuilder.Entity<Item>()
                .HasMany(i => i.ChildItems)
                .WithOptional()
                .HasForeignKey(i => i.ThreadId);

edited May 23 '12 at 11:21

answered May 23 '12 at 10:58

Juraj Suchár

1,107
6
25

Relationship on same table with Entity Framework

2 Answers2