实体框架 - 流利的API - 与2 FK创建表 [英] Entity Framework - Fluent APi - Create table with 2 FK

问题描述

我有一个产品列表该产品类关联。

I have this product class which has a list of products associated.

例如：

产品= StarWar

Product = StarWar

AssociatedProducts =情节v：帝国反击，情节VI：Jedi的回归，情节七：原力Awakens中

AssociatedProducts = Episode V: The Empire Strikes Back, Episode VI: Return of the Jedi, Episode VII: The Force Awakens

但EF产生一些额外的列的数据库。

But EF generates the database with some extra columns.

这是我的产品类别：

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; }
    ......
}

这是我AssociatedProduct类：

This is my AssociatedProduct Class:

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; }
}

这是我的映射AssocietedProduct类：

This is my mapping for AssocietedProduct class:

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");
    }

这是我如何播种：

And this is how I am seeding:

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();

这是我从AssociatedProductsId表期望： ID +的ProductId（FK）+ AssociatedProductsId（FK）+日期+ ......

This is what I expect from AssociatedProductsId Table: ID + ProductId (FK) + AssociatedProductsId(FK) + date + ......

但是，这就是我得到：

But this is what I get:

什么是我的错？ 这是一个产品关联的好方法？

What is my mistake ? Is this a good way to associate a product ?

推荐答案

我觉得你的类是不正确的。

I think your classes are not right.

1问题：为什么EF生成表额外的列

1 Problem: Why EF generates the table with extra columns?

在这种情况下，EF使用TPH策略。看看这个链接的http://blogs.msdn.com/b/alexj/archive/2009/04/15/tip-12-choosing-an-inheritance-strategy.aspx

In that case EF is using TPH strategy. Take a look at this link http://blogs.msdn.com/b/alexj/archive/2009/04/15/tip-12-choosing-an-inheritance-strategy.aspx

2问题：什么是我的错？这是一个产品关联的好方法？

2 Problem: What is my mistake ? Is this a good way to associate a product ?

您映射应该是这样的：

public class Product
{
    public int ProductId { get; set; }

    public string Name { get; set; }

    public virtual ICollection<ProductAssociation> AssociatedProducts { get; set; }

    public virtual ICollection<ProductAssociation> ProductsAssociatedThisProduct { get; set; }
}

public class ProductAssociation
{
    public int ProductId { get; set; }

    public int ProductAssociatedId { get; set; }

    public DateTime CreationDate { get; set; }

    public virtual Product Product { get; set; }

    public virtual Product ProductAssociated { get; set; }
}

public class Context : DbContext
{
    public Context() : base("Model2")
    {

    }

    public DbSet<Product> Products { get; set; }
    public DbSet<ProductAssociation> ProductsAssociations { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Product>()
            .HasKey(i => i.ProductId);

        modelBuilder.Entity<ProductAssociation>()
            .HasKey(i => new {i.ProductId, i.ProductAssociatedId });

        modelBuilder.Entity<Product>()
            .HasMany(i => i.AssociatedProducts)
            .WithRequired(i => i.ProductAssociated)
            .HasForeignKey(i => i.ProductAssociatedId)
            .WillCascadeOnDelete(false);

        modelBuilder.Entity<Product>()
            .HasMany(i => i.ProductsAssociatedThisProduct)
            .WithRequired(i => i.Product)
            .HasForeignKey(i => i.ProductId)
            .WillCascadeOnDelete(false);


        base.OnModelCreating(modelBuilder);
    }


}

种子

var product1 = new Product() { Name = "StarWars", ProductId = 1 };

var product2 = new Product() { Name = "StarWars II", ProductId = 2 };

context.ProductsAssociations.AddOrUpdate(new ProductAssociation { Product = product1, CreationDate = DateTime.Now, ProductAssociated = product2 });
context.Products.AddOrUpdate(product1);
context.Products.AddOrUpdate(product2);
context.SaveChanges();

这篇关于实体框架 - 流利的API - 与2 FK创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！