How to merge DbContext with IdentityDbContext

Question

I am attempting to get away from code-first migrations.

The problem is that AspNetUsers is extending IdentityUser. As a result, when I try to use a DbContext then I get the following errors.

EntityType 'IdentityUserLogin' has no key defined. Define the key for this EntityType.
EntityType 'IdentityUserRole' has no key defined. Define the key for this EntityType.

I want to use AspNetUsers for two purposes:

Identity management.
Querying users from the database.

Is it possible to go this route without having to use IdentityDbContext?

public class MyEntities : DbContext
{
     public DbSet<AspNetUsers> AspNetUsers { get; set; }
}

Possible duplicate of EntityType 'IdentityUserLogin' has no key defined. Define the key for this EntityType — trailmax
– trailmax, Commented Jan 29, 2018 at 11:10

Nikolai · Accepted Answer · 2018-01-29 07:05:12Z

3

you don't need to add

public DbSet<AspNetUsers> AspNetUsers { get; set; }

inherit your context from IdentityDbContext to have only one context

public class MyEntities : IdentityDbContext<AspNetUsers>

also don't forget to set up UserManager to use your MyEntities context with AspNetUsers

answered Jan 29, 2018 at 7:05

Nikolai

3061 silver badge10 bronze badges

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

1 Comment

J Weezy Over a year ago

That worked, thank you sir. I had already taken care of the MyEntities context with AspNetUsers. But, it was all relevant so I mark yours as the answer.

Stephan Oomen · Accepted Answer · 2018-01-29 07:28:18Z

2

You could avoid using the IdentityDbContext but you need to setup the mapping yourself in the OnModelCreating method within your DbContext class.

However, if you are using the SignInManager etc.. I recommend you use the IdentityDbContext. You are not constraint to use Code-First Migrations.

answered Jan 29, 2018 at 7:28

Stephan Oomen

816 bronze badges

1 Comment

J Weezy Over a year ago

I did not need to add anything to the OnModelCreating. Thank you for responding.

qamar · Accepted Answer · 2018-01-29 07:00:02Z

1

Identity context inherits from DBContext. Hence as long as your own db context inherits from identity context, it should be enough. Something like following :-

public class MyDbContext : IdentityContext {}

answered Jan 29, 2018 at 7:00

qamar

1,4471 gold badge10 silver badges12 bronze badges

1 Comment

J Weezy Over a year ago

This was also part of the answer, but Nikolay provided additional context that was necessary. I thank you for responding to this post.

Collectives™ on Stack Overflow

How to merge DbContext with IdentityDbContext

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related