CODEWITHSUNDEEP
c#.netentity-framework
Tums
Tums

Reputation: 505

Entity Framework Code First - Changing a Table Name

I want to change the name of one of my tables generated using Entity Framework code first.

I have already created the database, but now I want to change the name. I've updated all references to the "Metadatas" table to "Metadata" in my project. But the table that is being generated in the database is still "Metadatas". I've dropped and re-created the database, but that doesn't seem to work either. Neither does using a TableAttribute. What I'm I supposed to do?

Thanks.

[Table("Metadata")]
public class Metadata 
{
    [Required, Key]
    public int MetadataId { get; set; }

    [Required, ScaffoldColumn(false)]
    public int DocumentId { get; set; }

    [Required, StringLength(250), DataType(DataType.Text)]
    public string Title { get; set; }

...

Upvotes: 41

Views: 48129

Answers (2)

Dave Cousineau
Dave Cousineau

Reputation: 13148

If you have a DbSet<T> property on your DbContext, that is one place that EF can get the table name from. Rename that property and run a new migration to rename the table.

Upvotes: 0

Stu1986C
Stu1986C

Reputation: 1510

You have two options here:

Data Annotations:

//Changing database table name to Metadata
[Table("Metadata")]
public class Metadata 
{
  [Required, Key]
  public int MetadataId { get; set; }

  [Required, ScaffoldColumn(false)]
  public int DocumentId { get; set; }

  [Required, StringLength(250), DataType(DataType.Text)]
  public string Title { get; set; 
}

or we have Fluent API:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
  //Changing Database table name to Metadata
  modelBuilder.Entity<Metadata>()
      .ToTable("Metadata");
}

Using the Fluent API is the preferred option if you want to ensure your Domain Model stays uncluttered.

Just adding to this, if you solely want to remove the pluralisation of your table names, you can override EFs ability to do so with the following line of code:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

Upvotes: 80

Related Questions