Reputation: 4325

How can I change default ASP.NET Identity table names in .NET CORE?

I've started with .NET Core, in MVC 5 I changed default table names for example: AspNETUsers to Users in this way and it worked perfectly: In IdentityModels Class I dded:

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<IdentityUser>().ToTable("Users").Property(p => p.Id).HasColumnName("UserId");
        modelBuilder.Entity<ApplicationUser>().ToTable("Users").Property(p => p.Id).HasColumnName("UserId");
        modelBuilder.Entity<IdentityUserRole>().ToTable("UserRoles");
        modelBuilder.Entity<IdentityUserLogin>().ToTable("UserLogins");
        modelBuilder.Entity<IdentityUserClaim>().ToTable("UserClaims");
        modelBuilder.Entity<IdentityRole>().ToTable("Roles");
    }

But it does not work in ASP.NET CORE (MVC 6). Can Anyone help me? Thanks a lot.

Upvotes: 48

Answers (11)

Jhonnatan Panoch

Reputation: 314

In Entity Framework Core Version 6 this works fine:

protected override void OnModelCreating(ModelBuilder builder)
{
    base.OnModelCreating(builder);

    foreach (var entity in builder.Model.GetEntityTypes())
    {
        // Replace table names
        entity.SetTableName(entity.GetTableName().ToSnakeCase());
    }
}

Upvotes: 1

Bharat Kumar

Reputation: 97

To update default table names IdentityModels Class MVC

    protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<IdentityUser>().ToTable("Users").HasKey(x => x.Id);
        modelBuilder.Entity<ApplicationUser>().ToTable("Users").HasKey(x => x.Id);
        modelBuilder.Entity<IdentityUserRole>().ToTable("UserRoles").HasKey(x => x.RoleId);;
        modelBuilder.Entity<IdentityUserLogin>().ToTable("UserLogins").HasKey(x => x.UserID);;
        modelBuilder.Entity<IdentityUserClaim>().ToTable("UserClaims").HasKey(x => x.Id);;
        modelBuilder.Entity<IdentityRole>().ToTable("Roles").HasKey(x => x.Id);;
    }

Upvotes: 1

Ivaylo

Reputation: 476

I am adding a second answer, because many people will hit this when trying to change table names in .NET core 1, 2, 3 and .NET 5

The process is pretty straightforward and well explained in the docs.

For those needing quick fix:

Inherit all your models which you want to change( default Microsoft authorization comes with 7 models ). For example changing AspNetUsers to User and AspNetRoles to Role you can do the following in your existing models:
```
 public partial class User : IdentityUser<int>
 {
     // code
 }

 public partial class Role : IdentityRole<int>
 {
     // code
 }
```

In this example I am changing the primary key type also because the default is nvarchar.

In your context inherit from IdentityDbContext and use the same type as argument:

 public class AppDbContext : IdentityDbContext<User, Role, int>
 {
     // code
 }

Next we have to update ConfigureServices in StartUp to use the new User class:

  services.AddDefaultIdentity<User, Role>()
  .AddEntityFrameworkStores<AppDbContext>();

Then if want need you migrate to update/create database. Depends if this is a new or old project.

Note: If you are currently using authentication in your project like UserManager or SignInManager you have to change their generic arguments to the new ones like so:

SignInManager<User>
UserManager<User>

Hope that helps :)

Upvotes: 2

Amirhossein Yari

Reputation: 2326

There is one extra note : I customized all of my identity tables name but it didn't apply. base on Microsoft reference you have to use base.OnModelCreating(builder); before your customization

To change the names of tables and columns, call base.OnModelCreating. Then, add configuration to override any of the defaults. For example, to change the name of all the Identity tables:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    modelBuilder.Entity<IdentityUser>(b =>
    {
       b.ToTable("MyUsers");
    });

    modelBuilder.Entity<IdentityUserClaim<string>>(b =>
    {
        b.ToTable("MyUserClaims");
    });

    modelBuilder.Entity<IdentityUserLogin<string>>(b =>
    {
        b.ToTable("MyUserLogins");
    });

    modelBuilder.Entity<IdentityUserToken<string>>(b =>
    {
        b.ToTable("MyUserTokens");
    });

    modelBuilder.Entity<IdentityRole>(b =>
    {
        b.ToTable("MyRoles");
    });

    modelBuilder.Entity<IdentityRoleClaim<string>>(b =>
    {
        b.ToTable("MyRoleClaims");
    });

    modelBuilder.Entity<IdentityUserRole<string>>(b =>
    {
        b.ToTable("MyUserRoles");
    });
}

Upvotes: 2

sgrysoft

Reputation: 628

Just for documentation purpose, for the one who comes to this post on the years anyears on the future, (like me XD), The answer to the question: