ASP.NET MVC identity database table mapping issue

Question

I'm using the database first approach for my ASP.NET MVC5 application which uses MySQL database and I'm stuck on this weird error. In my database, I have Identity tables but all in lower case like following

link to the image

but when I published the application to my staging server it gave me error like "Table 'xxx_.AspNetUsers' doesn't exist" though I have the table in my DB but it's in the lowercase(aspnetusers). And the weird part is everything works just fine locally as well as on smarterasp.net but on my staging server it's not working for some reasons.

FIXED:

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        //Make sure you add above line
        modelBuilder.Entity<ApplicationUser>().ToTable("aspnetusers");
        modelBuilder.Entity<IdentityRole>().ToTable("aspnetroles");
        modelBuilder.Entity<IdentityUserRole>().ToTable("aspnetuserroles");
        modelBuilder.Entity<IdentityUserClaim>().ToTable("aspnetuserclaims");
        modelBuilder.Entity<IdentityUserLogin>().ToTable("aspnetuserlogins");
        //Don't add IdentityUser ToTable aspnetusers
    }

Do hou have a connectionstring named LocalMySqlServer on your Web.config? — rkawano
– rkawano, Commented Sep 24, 2015 at 18:48
@rkawano No I don't have LocalMySqlServer on my web.config I just have default connection and my DbEntities. — Swar Shah
– Swar Shah, Commented Sep 24, 2015 at 18:55
You must configure the mapping in the OnModelCreating method of IdentityDbContext class. Take a look at stackoverflow.com/a/19577814/1942895 — Rafael Companhoni
– Rafael Companhoni, Commented Sep 24, 2015 at 19:06
@rcompanhoni Thanks buddy can you tell more specific? I did IdentityRole toTable aspnetroles and all 5 tables like that and it got rid of startup error but now i'm getting error when I try to do login saying the same thing "Table 'xxx_.AspNetUsers' doesn't exist". — Swar Shah
– Swar Shah, Commented Sep 24, 2015 at 20:21

Swar Shah · Accepted Answer · 2019-02-07 18:31:47Z

1

FIXED:

protected override void OnModelCreating(System.Data.Entity.DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        //Make sure you add above line
        modelBuilder.Entity<ApplicationUser>().ToTable("aspnetusers");
        modelBuilder.Entity<IdentityRole>().ToTable("aspnetroles");
        modelBuilder.Entity<IdentityUserRole>().ToTable("aspnetuserroles");
        modelBuilder.Entity<IdentityUserClaim>().ToTable("aspnetuserclaims");
        modelBuilder.Entity<IdentityUserLogin>().ToTable("aspnetuserlogins");
        //Don't add IdentityUser ToTable aspnetusers
    }

answered Feb 7, 2019 at 18:31

Swar Shah

1733 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET MVC identity database table mapping issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related