© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•2y ago•
178 replies
Lamp

ASP.NET Identity Login Error

When trying to sign in using SignInManager, I get a SqlException: Invalid column name 'UserId1'.

Why is there an extra user column being added to the query? My extended identity classes are listed below.

var result = await _signInManager.PasswordSignInAsync(
    user,
    Input.Password,
    Input.RememberMe,
    lockoutOnFailure: false
);
var result = await _signInManager.PasswordSignInAsync(
    user,
    Input.Password,
    Input.RememberMe,
    lockoutOnFailure: false
);


public class ApplicationUser : IdentityUser
{
    [Required(ErrorMessage = "First name is required")]
    [Display(Name = "First Name")]
    [MaxLength(50)]
    public string FirstName { get; set; }

    [Required(ErrorMessage = "Last name is required")]
    [Display(Name = "Last Name")]
    [MaxLength(50)]
    public string LastName { get; set; }

    public virtual ICollection<ApplicationUserClaim> Claims { get; set; }

    public virtual ICollection<IdentityUserLogin<string>> Logins { get; set; }

    public virtual ICollection<IdentityUserToken<string>> Tokens { get; set; }
}

public class ApplicationRole : IdentityRole
{
}

public class ApplicationUserRole : IdentityUserRole<string>
{
    public bool IsReadOnly { get; set; }

    public string ProgramId { get; set; }

    public bool IsDefault { get; set; }

    public virtual TestProgram Program { get; set; }
}

public class ApplicationRoleClaim : IdentityRoleClaim<string>
{
    public virtual ApplicationRole Role { get; set; }
}

public class ApplicationUserClaim : IdentityUserClaim<string>
{
    public virtual ApplicationUser User { get; set; }
}

public partial class ApplicationDbContext : IdentityDbContext<
    ApplicationUser, ApplicationRole, string,
    ApplicationUserClaim, ApplicationUserRole, IdentityUserLogin<string>,
    ApplicationRoleClaim, IdentityUserToken<string>>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
    : base(options)
    {
    }

    /// DbSets

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
public class ApplicationUser : IdentityUser
{
    [Required(ErrorMessage = "First name is required")]
    [Display(Name = "First Name")]
    [MaxLength(50)]
    public string FirstName { get; set; }

    [Required(ErrorMessage = "Last name is required")]
    [Display(Name = "Last Name")]
    [MaxLength(50)]
    public string LastName { get; set; }

    public virtual ICollection<ApplicationUserClaim> Claims { get; set; }

    public virtual ICollection<IdentityUserLogin<string>> Logins { get; set; }

    public virtual ICollection<IdentityUserToken<string>> Tokens { get; set; }
}

public class ApplicationRole : IdentityRole
{
}

public class ApplicationUserRole : IdentityUserRole<string>
{
    public bool IsReadOnly { get; set; }

    public string ProgramId { get; set; }

    public bool IsDefault { get; set; }

    public virtual TestProgram Program { get; set; }
}

public class ApplicationRoleClaim : IdentityRoleClaim<string>
{
    public virtual ApplicationRole Role { get; set; }
}

public class ApplicationUserClaim : IdentityUserClaim<string>
{
    public virtual ApplicationUser User { get; set; }
}

public partial class ApplicationDbContext : IdentityDbContext<
    ApplicationUser, ApplicationRole, string,
    ApplicationUserClaim, ApplicationUserRole, IdentityUserLogin<string>,
    ApplicationRoleClaim, IdentityUserToken<string>>
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
    : base(options)
    {
    }

    /// DbSets

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements
Next page

Similar Threads

asp.net core Identity ApplicationDbContext error
C#CC# / help
3y ago
ASP.NET Core Identity?
C#CC# / help
3y ago
ASP.NET Identity or custom?
C#CC# / help
3y ago