How to make an int field named UserID as the primary key in AspNetUsers table in Asp.Net Core 6.0 MVC

Question

How to make an int field named UserID as the primary key in AspNetUsers table in Asp.Net Core 6.0 MVC

Sherpa 326

I am implementing Asp.Net Core Identity on an existing legacy website. I have created the Identity tables using migrations. The legacy database has a table named Users which was used for the logging. I have replaced the Users table with the AspNetUsers table. The legacy table had a field named UserID which was int as well as a primary key. I have modified the AspNetUsers table by adding a field named UserID of type int and moved all the rows from the Users table to the AspNetUsers table. The AspNetUsers table by default has ID field as the primary key which is a GUID. Is there a way to make the UserID the primary key in the AspNetUsers table?

1 answer

Your answer

Answer 1

AgaveJoe 30,126

Identity allows you to configure the primary key. The official documentation covers the details with source code.

Change Primary Key for Users in ASP.NET Identity

Sherpa 326 Reputation points

2024-05-24T19:03:27.9733333+00:00

Thanks for your answer. I saw this article. I believe it changes the ID field as int and uses it as the primary key. However, I want to use my custom field, UserID, which I have added.
AgaveJoe 30,126 Reputation points

2024-05-24T19:15:10.77+00:00
If I understand, you are asking how to add a custom field to the User table. The official documentation covers adding a custom field as well.

Identity model customization in ASP.NET Core

You also might try mapping the Id field to UserId using the Column attribute. You'll still need to use the link above to update the Id type.

[Column("UserId", TypeName="int")] //... modelBuilder.Entity<IdentityUser>().ToTable("Users", "dbo").Property(p => p.Id).HasColumnName("UserId");

Lastly, you can configure Identity to use whatever store you like.

Configure ASP.NET Core Identity
Sherpa 326 Reputation points

2024-05-25T20:01:45.2166667+00:00

I have already added custom fields, such as FirstName, LastName etc. However I want to make the Id column an Int type and rename it from Id into UserID and rename the table from AspNetUsers into Users.

AgaveJoe 30,126

This code names the table Users and renames the Id field to Users.

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);
    modelBuilder.Entity<IdentityUser<int>>()
        .ToTable("Users")
        .Property(p => p.Id)
        .HasColumnName("UserId");
}

Share via

How to make an int field named UserID as the primary key in AspNetUsers table in Asp.Net Core 6.0 MVC

1 answer

Your answer