Prevent Entity Framework from adding duplicated keys in migration with table per type inheritance

Question

I have a simple model using table per type inheritance for some entities. The problem is that when I generate the migration using Add-Migration, It creates a duplicated index on the child class' primary key.

Class definitions:

class Product
{
    [Key]
    public int ProductId { get; set; }
    public int Value { get; set; }
}
class Service : Product
{
    public int OtherValue { get; set; }
}

And in my context, I specify the table names for both classes

class ProductContext : DbContext
{
    virtual public DbSet<Product> ProductSet { get; set; }
    virtual public DbSet<Service> ServiceSet { get; set; }
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Product>().ToTable("Product");
        modelBuilder.Entity<Service>().ToTable("Service");
    }
}

Running Add-Migration results in the following:

public override void Up()
{
    CreateTable(
        "dbo.Product",
        c => new
            {
                ProductId = c.Int(nullable: false, identity: true),
                Value = c.Int(nullable: false),
            })
        .PrimaryKey(t => t.ProductId);

    CreateTable(
        "dbo.Service",
        c => new
            {
                ProductId = c.Int(nullable: false),
                OtherValue = c.Int(nullable: false),
            })
        .PrimaryKey(t => t.ProductId)
        .ForeignKey("dbo.Product", t => t.ProductId)
        .Index(t => t.ProductId);

}

It creates an additional index on Service.ProductId when it's already the primary key. Is there some annotation I am missing in order to prevent the index from being added?

Tested with both EF5 and EF6 with the same results.

No particular reason. I'm not the sole owner of that code, so I don't mess about with anything existing unless I have to. — ESG
– ESG, Commented Aug 17, 2013 at 15:14

jr from Yaoundé · Accepted Answer · 2014-09-14 00:40:12Z

1

Just for whom (still) facing this problem, as I understand it's a bug fixed in version 6.1.1 of EF (https://entityframework.codeplex.com/workitem/1035).

So just updating to the latest version of EF should fix it. But if you couldn't or wouldn't update, the workaround is just as simple as deleting duplicate Index in generated migration file and save (don't also forget to disable AutomaticMigrationsEnabled if enabled).

answered Sep 14, 2014 at 0:40

jr from Yaoundé

6566 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Slime recipe Over a year ago

6.1.3 still has the problem.

Colin · Accepted Answer · 2013-08-30 10:32:07Z

1

I suspect that the Entity Framework adds an index to foreign keys - even when the foreign key is already indexed because it is also the primary key. Maybe it's an oversight or maybe it's a low priority for the framework developers. Either way, you can adjust the Up() method yourself. See item 7 on this useful blog Tips for Entity Framework Migrations

edited Aug 30, 2013 at 10:32

answered Aug 28, 2013 at 7:51

Colin

22.7k17 gold badges111 silver badges211 bronze badges

1 Comment

ESG Over a year ago

Yeah, I've ended up digging through the EF code and I saw that every time a FK is added, an index is also created. I can certainly modify the migrations (and I have), but at the time I want to know if it was possible to control this through configurations. Anyway, this is closest thing I've got to an answer

Kirsten · Accepted Answer · 2013-08-17 21:30:56Z

0

Try making both tables inherit from an abstract class as described here

public abstract class ProductBase
{
  [Key]
  public int ProductId { get; set; }
}

public class Product: ProductBase
{
  public int Value { get; set; }
}

public class Service : ProductBase
{
    public int OtherValue { get; set; }
}

answered Aug 17, 2013 at 21:30

Kirsten

18.9k52 gold badges213 silver badges368 bronze badges

Collectives™ on Stack Overflow

Prevent Entity Framework from adding duplicated keys in migration with table per type inheritance

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related