Can I use the same dbcontext for asp identity

Question

Is it possible to tell asp identity to use the same dbcontext as application dbcontext? My tables need to relate to identity table. Each table has createuser and edituser field that linked to identity table. If asp use its own dbcontext, then i have to also add entities and mapping to identity tables to the application dbcontext. Is the a better approach for this situation? I use entity framework code first 6 and and asp mvc 5.

EDIT

Based on answers below, i can use the same dbcontext as long as my dbcontext inherited from IdentityContext.

My question:

Do i still need to create entity class and map manually? How do i map relations between my tables to identityuser?

This is my current dbcontext

    public partial class MyContext : DbContext
{
    static MyContext()
    {
        Database.SetInitializer<MyContext>(null);
    }

    public MyContext()
        : base("Name=MyContext")
    {
        this.Configuration.ProxyCreationEnabled = false;
        this.Configuration.LazyLoadingEnabled = false;
    }

    public new DbSet<TEntity> Set<TEntity>() where TEntity : BaseEntity
    {
        return base.Set<TEntity>();
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Configurations.Add(new AspNetRoleMap());
        modelBuilder.Configurations.Add(new AspNetUserClaimMap());
        modelBuilder.Configurations.Add(new AspNetUserLoginMap());
        modelBuilder.Configurations.Add(new AspNetUserMap());
        modelBuilder.Configurations.Add(new PersonMap());
    }

Mohsen Esmailpour · Accepted Answer · 2014-07-12T10:41:39.093

1

Your context class must be inherited form IdentityDbContext instead of DbContext. IdentityDbContext contains some configuration for IdentityUser, IdentityRole, IdentityUserLogin, IdentityUserRole, IdentityUserClaim and it has IDbSet Users and IDbSet Roles.

public class MyContext : IdentityDbContext<IdentityUser or your own UserEntity>
{
   .
   .
   .
}

edited Jul 12 '14 at 10:41

answered Jul 12 '14 at 10:32

Mohsen Esmailpour

11,224
3
45
66

score 0 · Answer 2 · answered Jul 12 '14 at 09:47

0

Sure

When you create an instance of your User Manager just pass over the User Store along with your own dbContext.

new UserManager<IdentityUser>(new UserStore<IdentityUser>(new MyDbContext()))

answered Jul 12 '14 at 09:47

heymega

9,215
8
42
61

2

Identity use IdentityDbContext. Are there any downside in using normal DbContext? – Reynaldi Jul 12 '14 at 10:13

brnt · Answer 3 · 2014-07-14T08:28:27.037

0

My question:

Do i still need to create entity class and map manually? How do i map relations between my tables to identityuser?

No, all of your Identity classes are already mapped. If you want to add relationship to your Identity, you can do that as you would normally in the OnModelCreating method in the context itself reffering to your Identity classes(e.g. IdentityRole, IdentityUserRole, IdentityUser).

For more information on how this is done, take a look at this article.

edited Jul 14 '14 at 08:28

answered Jul 14 '14 at 08:22

brnt

108
1
8

Thanks. I found a question that similar to mine and find the solution there. http://stackoverflow.com/questions/21418902/integrating-asp-net-identity-into-existing-dbcontext – Reynaldi Jul 14 '14 at 12:12

score 0 · Answer 4 · edited May 23 '17 at 12:21

0

In EF 6.0, the better way to go will be to have two separate Contexts and then use the same connection string and 2 different migration configurations as per Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations.

edited May 23 '17 at 12:21

Community

1
1

answered May 19 '15 at 06:52

Marius

85
9

Can I use the same dbcontext for asp identity

4 Answers4