Ich habe diese Produktklasse, der eine Liste von Produkten zugeordnet ist.

z.B

Product = StarWar

AssociatedProducts = Episode V: Das Imperium schlägt zurück, Episode VI: Rückkehr der Jedi, Episode VII: Das Erwachen der Macht

Aber EF generiert die Datenbank mit einigen zusätzlichen Spalten.

Dies ist meine Produktklasse:

public class Product 
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string ShortDescription { get; set; }
    public string FullDescription { get; set; }
    public decimal UnitPrice { get; set; }
    ......
    public virtual ICollection<AssociatedProducts> AssociatedProducts { get; set; }
    ......
}

Dies ist meine AssociatedProduct-Klasse:

public class AssociatedProducts
{
    public int Id { get; set; }

    public int ProductId { get; set; }
    public int AssociatedProductId { get; set; }

    public int DisplayOrder { get; set; }
    public DateTime CreatedOn { get; set; }

    public virtual Product Products { get; set; }
    public virtual Product AssociatedProductsId { get; set; }
}

Dies ist meine Zuordnung für die AssocietedProduct-Klasse:

public AssociatedProductsMap()
    {
        // Primary Key
        HasKey(a => a.Id);

        // Properties
        Property(a => a.CreatedOn).IsRequired();
        Property(a => a.ProductId).IsRequired();
        Property(a => a.AssociatedProductId).IsRequired();
        Property(a => a.DisplayOrder).IsRequired();

        //Relationship
        HasRequired(a => a.Products)
            .WithMany(p => p.Products)
            .HasForeignKey(a => a.ProductId)
            .WillCascadeOnDelete(false);

        HasRequired(a => a.AssociatedProductsId)
            .WithMany(p => p.AssociatedProducts)
            .HasForeignKey(a => a.AssociatedProductId)
            .WillCascadeOnDelete(false);

        //Table  
        ToTable("AssociatedProducts");
    }

Und so säte ich:

var associetedProducts = new List<AssociatedProducts>
        {
            new AssociatedProducts {ProductId= 1, AssociatedProductId = 3, DisplayOrder = 1, CreatedOn = DateTime.Now},
            new AssociatedProducts {ProductId= 1, AssociatedProductId = 4, DisplayOrder = 2, CreatedOn = DateTime.Now},
            new AssociatedProducts {ProductId= 1, AssociatedProductId = 5, DisplayOrder = 3, CreatedOn = DateTime.Now}
        }

new List<Product>
        {
          new Product {Name = "StarWar", ShortDescription = "...", FullDescription = "P.......", UnitPrice = 15m, AssociatedProducts = associetedProducts},
          new Product {Name = "StarWar Episode V", ShortDescription = "...", FullDescription = "P.......", UnitPrice = 15m},
          new Product {Name = "StarWar Episode VI", ShortDescription = "...", FullDescription = "P.......", UnitPrice = 15m},
          new Product {Name = "StarWar Episode VII", ShortDescription = "...", FullDescription = "P.......", UnitPrice = 15m},
    }.ForEach(a => context.Products.AddOrUpdate(a));

context.SaveChanges();

Das erwarte ich von der AssociatedProductsId-Tabelle: ID + ProductId (FK) + AssociatedProductsId (FK) + Datum + ......

Aber das bekomme ich:

Was ist mein Fehler? Ist dies eine gute Möglichkeit, ein Produkt zuzuordnen?