Asp.net Identity Validation Error

Question

I want integrate IdentityContext with mydbcontext but i am taking this error

One or more validation errors were detected during model generation:

Ivdb.Dal.Concrete.EFCodeFirst.IdentityUserLogin: : EntityType 'IdentityUserLogin' has no key defined. Define the key for this EntityType. Ivdb.Dal.Concrete.EFCodeFirst.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.

How can i solve this ?

Code:

 public partial class ivdbDb156978Context : IdentityDbContext<ApplicationUser> 
{
    static ivdbDb156978Context()
    {
        Database.SetInitializer<ivdbDb156978Context>(null);
    }

    public ivdbDb156978Context()
        : base("Name=ivdbContext")
    {
    }


    public DbSet<Car> Cars { get; set; }

Application User

    public class ApplicationUser : IdentityUser
{

}

Olav Nybø · Accepted Answer · 2013-11-15 07:45:26Z

152

Your code does't show this, but from the errors you are getting I assume that you are overriding OnModelCreating.This is where IdentityDbContext<ApplicationUser> configure the entity framework mappings. This means that if you want to override OnModelCreating you need to either call the base or you must do the mapping yourself.

So either this:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    // your stuff here
}

Or you do the mapping:

protected override void OnModelCreating(DbModelBuilder 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 });
}

answered Nov 15, 2013 at 7:45

Olav Nybø

11.6k8 gold badges44 silver badges35 bronze badges

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

6 Comments

Vahid Ghadiri Over a year ago

I'm sure I can find your correct answers about EF Code First approach, in the StackOverFlow whenever I need it. thanks

GDB Over a year ago

I created an override on OnModelCreating so I could add modelBuilder.Conventions.Remove<PluralizingTableNameConvention>(); to prevent EF from pluralizing my table names and this bit me on the first attempt to add a migration. Thanks for your very helpful answer Olav

Joe Over a year ago

Hello Olav, This solved my no key defined error but now I get numerous Invalid column name errors. I've posted here stackoverflow.com/questions/23346422/…. Would you have any insight on this. Thank you, Joe

Isuru Fonseka Over a year ago

base.OnModelCreating(modelBuilder); Worked for me, I have existing users so didnt want to do anything to radical. Thanks Olav

Rudey Over a year ago

I got this error after copy pasting some of AppHarbor's documentation code. Thanks!

|

AAD · Accepted Answer · 2014-01-25 17:16:59Z

6

If you don't want to call base.OnModelCreating and want to do your own mapping, your mapping should look like this:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<IdentityRole>().HasKey<string>(r => r.Id).Property(p => p.Name).IsRequired();
    modelBuilder.Entity<IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId });
    modelBuilder.Entity<IdentityUserLogin>().HasKey(u => new {u.UserId, u.LoginProvider, u.ProviderKey});
}

If you put the key for IdentityUserLogin only on UserId, you get DbEntityValidationExceptions when using the default google login.

answered Jan 25, 2014 at 17:16

AAD

3793 silver badges9 bronze badges

Comments

Barry MSIH · Accepted Answer · 2014-08-27 11:46:30Z

3

The take away is that you cannot have an empty OnModelCreating

Good

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
  base.OnModelCreating(modelBuilder);
  // your stuff here
}

Bad

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
  // base.OnModelCreating(modelBuilder);
  // your stuff here
}

answered Aug 27, 2014 at 11:46

Barry MSIH

3,8177 gold badges41 silver badges59 bronze badges

Collectives™ on Stack Overflow

Asp.net Identity Validation Error

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related