EF Core - Many to many relationship on same class

Question

EF Core - Many to many relationship on same class

c# entity-framework entity-framework-core

Question

What is best way to implement many to many from same class in Entity Framework Core?

In my case Every connection is bidirectional. If Item 'A' has Item 'B' in its "RelatedItems" list, then Item 'B' has Item 'A' in its "RelatedItems" list.

class Item
{
    int Data {get;set}
    List<Item> RelatedItems {get;set;}
}

topolm

View more on Stack Overflow

Bassam Alugili · Accepted Answer · 7/12/2016 11:13:27 AM

You have to add the self Referencing Foreign-Key-Relationship as following:

public class Item
{

    public Item()
    {
        RelatedItems = new List<Item>();
    }

    public int ItemId { get; set; }
    public int? ParentItemId { get; set; }
    public Item ParentItem{ get; set; }
    public List<Item> RelatedItems { get; set; }
}

The fluent API:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{ 
 ...
    modelBuilder.Entity<Item> =>
    {
        entity
            .HasMany(e => e.RelatedItems )
            .WithOne(e => e.ParentItem) 
            .HasForeignKey(e => e.ParentItemId );
    });
  ...

}

EF Core - Many to many relationship on same class

Question

Fastest Entity Framework Extensions

Popular Answer

Performance

Expression Evaluator

Related