Max
Max

Reputation: 482

Error when using Custom User class inherited from IdentityUser

I am using asp.net core 2.2. When using a custom class for app user inherited from IdentityUser, register & password sign-in fails with message "SqlException: Invalid column name 'ApplicationUserId'."

Statrup.cs

 services.AddIdentity<ApplicationUser, IdentityRole>()
            .AddEntityFrameworkStores<ApplicationDbContext>()
            .AddDefaultTokenProviders();

Application User class

 public class ApplicationUser : IdentityUser
 {  
 }

The database is standard identity generated with no custom columns added.

enter image description here

Upvotes: 0

Views: 452

Answers (1)

Anduin Xue
Anduin Xue

Reputation: 3737

Try modifying your ApplicationDbContext like this:

    public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
        {
        }
    }

Your default ApplicationDbContext is using IdentityUser as its user storage not ApplicationUser.

Upvotes: 2

Related Questions