Entity Framework Core 1.1 OnModelCreating method not getting called

Question

I have created a DBContext class in a .Net Standard 1.4 and have some code for entity configuration, in the OnModelCreating method, but it looks like this method is not getting called and I am getting an error complaining about a column name.

Here is my class:

public partial class TestContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer(@"Data Source=blah");
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<TestTable>().HasKey(t => t.Id).HasName("TestTableId");
        modelBuilder.Entity<TestTable>().ToTable("TestTable");
    }

    public virtual DbSet<TestTable> TestTable { get; set; }
}

public class TestTable
{
    public Guid Id { get; set; }
    public string Name { get; set; }
}

When I try to query this TestTable, I get an error saying invalid column name "Id"

And I don't have Id in the table, and I have TestTableId, and I was hoping the OnModelCreating code I got will take care of that mapping.

Any Ideas?

Smit · Accepted Answer · 2017-06-16 09:28:35Z

2

The problem you have is that you are naming the key and not the column here:

modelBuilder.Entity<TestTable>()
    .HasKey(t => t.Id)
        .HasName("TestTableId");

This creates a primary key and then names that key TestTableId. What you should be doing is this:

modelBuilder.Entity<TestTable>()
    .Property(t => t.Id)
        .HasColumnName("TestTableId");

edited Jun 16, 2017 at 9:28

Smit

2,4991 gold badge17 silver badges23 bronze badges

answered Jun 16, 2017 at 0:12

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Core 1.1 OnModelCreating method not getting called

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related