CODEWITHSUNDEEP
entity-frameworkentity-framework-4
Omu
Omu

Reputation: 71288

specify a different name for table|column name in EF4

I'm using EF4 with CodeFirst

public class People : DbContext
{
    public DbSet<Human> Humans { get; set; }
    public DbSet<Child> Children { get; set; }
}

At the moment, EF looks in the database for the Human table. How can I specify for it to look for Humans instead?

Upvotes: 47

Views: 20786

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364409

You can change table name on Human class:

[Table("Humans")]
public class Human
{
    ...
}

Other way is to use Fluent API:

modelBuilder.Entity<Human>()
    .ToTable("Humans");

Similary you can use ColumnAttribute or HasColumnName method to change the name of column.

Upvotes: 71

Related Questions