Map tables using fluent api in asp.net MVC5 EF6?

Question

I am trying to add profile/Membership information into my MVC5 application and adding configuration mappings.

I get the following error message:

my.Models.IdentityUserLogin: : EntityType 'IdentityUserLogin' has no key defined. Define the key for this EntityType.

my.Models.IdentityUserRole: : EntityType 'IdentityUserRole' has no key defined. Define the key for this EntityType.

IdentityUserLogins: EntityType: EntitySet 'IdentityUserLogins' is based on type 'IdentityUserLogin' that has no keys defined.

IdentityUserRoles: EntityType: EntitySet 'IdentityUserRoles' is based on type 'IdentityUserRole' that has no keys defined.

public class ApplicationUser : IdentityUser
{
    public string City { get; set; }
    public string Discriminator { get; set; }

    public string Address { get; set; }     
}

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("DefaultConnection")
    {
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Configurations.Add(new ApplicationUserConfiguration());           
    }
}

flip · Accepted Answer · 2013-10-24 09:43:03Z

22

Calling base.OnModelCreating(modelBuilder) did not solve the issue for me.

The behavior of Microsoft.AspNet.Identity.EntityFramework seems to be different in VS2013-Preview, VS2013-RC, and VS2013-RTM. I'm using the RTM version.

After inheriting from IdentityUser I had to recreate all other primary keys in the model to make it work:

public class ApplicationUser : IdentityUser
{
    public string DisplayName { get; set; }
}


public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext() : base("DefaultConnection") { }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);
        modelBuilder.Entity<IdentityUserLogin>().HasKey<string>(l => l.UserId);
        modelBuilder.Entity<IdentityRole>().HasKey<string>(r => r.Id);
        modelBuilder.Entity<IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId });
    }

(See Configuring/Mapping Properties and Types with the Fluent API)

I guess work on AspNet.Identity.EntityFramework is ongoing and this will be fixed (?)

answered Oct 24, 2013 at 9:43

flip

1,34215 silver badges29 bronze badges

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

5 Comments

A. Murray Over a year ago

I've had to do exactly the same thing to get by this issue. I thought that EF would pick out the entity IDs automatically?

Darren Wainwright Over a year ago

This resolved it all for me! Many thanks - should be marked as answered :)

Laurence Over a year ago

I have had a similar problem and tried this solution and thought it fixed the problem but I am getting few extra tables in the database such as IdentityUsers, and I also still have AspNetUsers table. What did i do wrong?

Arvis Over a year ago

@LaurenceNyein place base.OnModelCreating(modelBuilder) as last call in methode.

Justin Skiles Over a year ago

stackoverflow.com/questions/19913447/… fixed it for me

jd4u · Accepted Answer · 2013-10-20 06:58:49Z

19

Call base.OnModelCreating(modelBuilder) after configuration added.

answered Oct 20, 2013 at 6:58

jd4u

5,8272 gold badges32 silver badges28 bronze badges

2 Comments

taher chhabrawala Over a year ago

if this doesnt work..try calling it before the configurationaded

Jeremy Cook Over a year ago

It would seem base.OnModelCreating(modelBuilder); must be called if IdentityDbContext<ApplicationUser> is used, OnModelCreating overridden, and I am not manually configuring IdentityUserLogin, IdentityUserRole and IdentityUserClaim with attributes or the fluent API.

Amirhossein Mehrvarzi · Accepted Answer · 2015-03-23 20:03:33Z

0

Follow these steps around OnModelCreating method and test after each one to be aware of taking effect:

Make sure you have one Context to prevent of their rule conflicts.
Call base.OnModelCreating(modelBuilder); inside the mentioned method (first of all)
Add the followings plus previews step in the method:

modelBuilder.Entity<IdentityUserLogin>().HasKey<string>(l => l.UserId);
modelBuilder.Entity<IdentityRole>().HasKey<string>(r => r.Id);
modelBuilder.Entity<IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId });

answered Mar 23, 2015 at 20:03

Amirhossein Mehrvarzi

19.1k7 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

Map tables using fluent api in asp.net MVC5 EF6?

3 Answers 3

5 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related