Change a database table name using Entity Framework code first migrations

Question

How would you change the names of your tables using Entity Frameworks code first migrations.

The below code, creates my tables as :

RoleBindingModel, DivisionBindingModel etc. and that's not ideal.

How would you change the name to a custom table name? (Without changing your models name)

IdentityModels.cs

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
    {
        public ApplicationDbContext()
            : base("DefaultConnection", throwIfV1Schema: false)
        {
        }

        public DbSet<RoleBindingModel> Role { get; set; }
        public DbSet<DivisionBindingModel> Division { get; set; }
        public DbSet<CategoryBindingModel> Category { get; set; }
        public DbSet<ProductBindingModel> Product { get; set; }


        public static ApplicationDbContext Create()
        {
            return new ApplicationDbContext();
        }
    }

you mean in runtime?

Ali
– Ali

2017-07-20 09:00:08 +00:00
Commented Jul 20, 2017 at 9:00 — Ali
– Ali, Commented Jul 20, 2017 at 9:00

Kostis · Accepted Answer · 2017-07-20 09:04:41Z

3

One way is by using DataAnnotations and the Table attribute.

using System.ComponentModel.DataAnnotations.Schema;    

[Table("Role")]
public class RoleBindingModel
{

}

answered Jul 20, 2017 at 9:04

Kostis

9639 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Change a database table name using Entity Framework code first migrations

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