ASP NET Identity DbContext confusion

Question

A default MVC 5 App comes with this piece of code in IdentityModels cs - this piece of code is for all the ASP NET Identity operations for the default templates   public class ApplicationDbContext   IdentityDbContext lt ApplicationUser gt        public ApplicationDbContext             base  DefaultConnection                   If I scaffold a new controller using views with Entity Framework and create a  New data context     in the dialog  I get this generated for me   using System  using System Collections Generic  using System Data Entity  using System Linq  using System Web   namespace WebApplication1 Models       public class AllTheOtherStuffDbContext   DbContext                  You can add custom code to this file  Changes will not be overwritten                         If you want Entity Framework to drop and regenerate your database            automatically whenever you change your model schema  please use data migrations             For more information refer to the documentation             http   msdn microsoft com en-us data jj591621 aspx          public AllTheOtherStuffDbContext     base  name AllTheOtherStuffDbContext                                public System Data Entity DbSet lt WebApplication1 Models Movie gt  Movies   get  set                If I scaffold another controller   view using EF  say for instance for an Animal model  this new line would get autogenerated right under public System Data Entity DbSet lt WebApplication1 Models Movie gt  Movies   get  set    - like this   using System  using System Collections Generic  using System Data Entity  using System Linq  using System Web   namespace WebApplication1 Models       public class AllTheOtherStuffDbContext   DbContext                  You can add custom code to this file  Changes will not be overwritten                         If you want Entity Framework to drop and regenerate your database            automatically whenever you change your model schema  please use data migrations             For more information refer to the documentation             http   msdn microsoft com en-us data jj591621 aspx          public AllTheOtherStuffDbContext     base  name AllTheOtherStuffDbContext                                public System Data Entity DbSet lt WebApplication1 Models Movie gt  Movies   get  set            public System Data Entity DbSet lt WebApplication1 Models Animal gt  Animals   get  set                ApplicationDbContext  for all the ASP NET Identity stuff  inherits from IdentityDbContext which in turn inherits from DbContext  AllOtherStuffDbContext  for my own stuff  inherits from DbContext   So my question is   Which of these two  ApplicationDbContext and AllOtherStuffDbContext  should I use for all my other own models  Or should I just use the default autogenerated ApplicationDbContext since it shouldn t be a problem using it since it derives from the base class DbContext  or will there be some overhead  You should use only one DbContext object in your app for all your models  I ve read this somewhere  so I should not even consider using both ApplicationDbContext and AllOtherStuffDbContext in a single app  Or what is best practice in MVC 5 with ASP NET Identity

User · Answer

If you drill down through the abstractions of the IdentityDbContext you ll find that it looks just like your derived DbContext  The easiest route is Olav s answer  but if you want more control over what s getting created and a little less dependency on the Identity packages have a look at my question and answer here  There s a code example if you follow the link  but in summary you just add the required DbSets to your own DbContext subclass

User · Answer

I would use a single Context class inheriting from IdentityDbContext  This way you can have the context be aware of any relations between your classes and the IdentityUser and Roles of the IdentityDbContext  There is very little overhead in the IdentityDbContext  it is basically a regular DbContext with two DbSets  One for the users and one for the roles

User · Answer

This is a late entry for folks  but below is my implementation   You will also notice I stubbed-out the ability to change the the KEYs default type  the details about which can be found in the following articles    Extending Identity Models and Using Integer Keys Instead of Strings Change Primary Key for Users in ASP NET Identity   NOTES  It should be noted that you cannot use Guid s for your keys   This is because under the hood they are a Struct  and as such  have no unboxing which would allow their conversion from a generic  lt TKey gt  parameter   THE CLASSES LOOK LIKE   public class ApplicationDbContext   IdentityDbContext lt ApplicationUser  CustomRole  string  CustomUserLogin  CustomUserRole  CustomUserClaim gt         region  lt Constructors gt       public ApplicationDbContext     base Settings ConnectionString Database AdministrativeAccess                    endregion       region  lt Properties gt         public DbSet lt Case gt  Case   get  set          endregion       region  lt Methods gt        region      protected override void OnModelCreating DbModelBuilder modelBuilder                base OnModelCreating modelBuilder              modelBuilder Configurations Add new ResourceConfiguration               modelBuilder Configurations Add new OperationsToRolesConfiguration                 endregion       region      public static ApplicationDbContext Create                 return new ApplicationDbContext                endregion       endregion        public class ApplicationUser   IdentityUser lt string  CustomUserLogin  CustomUserRole  CustomUserClaim gt                 region  lt Constructors gt           public ApplicationUser                         Init                        endregion           region  lt Properties gt            Required           StringLength 250           public string FirstName   get  set              Required           StringLength 250           public string LastName   get  set              endregion           region  lt Methods gt            region private          private void Init                         Id   Guid Empty ToString                        endregion           region public          public async Task lt ClaimsIdentity gt  GenerateUserIdentityAsync UserManager lt ApplicationUser  string gt  manager                           Note the authenticationType must match the one defined in CookieAuthenticationOptions AuthenticationType             var userIdentity   await manager CreateIdentityAsync this  DefaultAuthenticationTypes ApplicationCookie                   Add custom user claims here              return userIdentity                      endregion           endregion            public class CustomUserStore   UserStore lt ApplicationUser  CustomRole  string  CustomUserLogin  CustomUserRole  CustomUserClaim gt                 region  lt Constructors gt           public CustomUserStore ApplicationDbContext context    base context                                endregion            public class CustomUserRole   IdentityUserRole lt string gt                   public class CustomUserLogin   IdentityUserLogin lt string gt                   public class CustomUserClaim   IdentityUserClaim lt string gt                     public class CustomRoleStore   RoleStore lt CustomRole  string  CustomUserRole gt                 region  lt Constructors gt           public CustomRoleStore ApplicationDbContext context    base context                                 endregion            public class CustomRole   IdentityRole lt string  CustomUserRole gt                 region  lt Constructors gt           public CustomRole               public CustomRole string name                          Name   name                       endregion

User · Answer

There is a lot of confusion about IdentityDbContext  a quick search in Stackoverflow and you ll find these questions    Why is Asp Net Identity IdentityDbContext a Black-Box  How can I change the table names when using Visual Studio 2013 AspNet Identity  Merge MyDbContext with IdentityDbContext   To answer to all of these questions we need to understand that IdentityDbContext is just a class inherited from DbContext  Let s take a look at IdentityDbContext source         lt summary gt      Base class for the Entity Framework database context used for identity       lt  summary gt       lt typeparam name  TUser  gt The type of user objects  lt  typeparam gt       lt typeparam name  TRole  gt The type of role objects  lt  typeparam gt       lt typeparam name  TKey  gt The type of the primary key for users and roles  lt  typeparam gt       lt typeparam name  TUserClaim  gt The type of the user claim object  lt  typeparam gt       lt typeparam name  TUserRole  gt The type of the user role object  lt  typeparam gt       lt typeparam name  TUserLogin  gt The type of the user login object  lt  typeparam gt       lt typeparam name  TRoleClaim  gt The type of the role claim object  lt  typeparam gt       lt typeparam name  TUserToken  gt The type of the user token object  lt  typeparam gt  public abstract class IdentityDbContext lt TUser  TRole  TKey  TUserClaim  TUserRole  TUserLogin  TRoleClaim  TUserToken gt    DbContext     where TUser   IdentityUser lt TKey  TUserClaim  TUserRole  TUserLogin gt      where TRole   IdentityRole lt TKey  TUserRole  TRoleClaim gt      where TKey   IEquatable lt TKey gt      where TUserClaim   IdentityUserClaim lt TKey gt      where TUserRole   IdentityUserRole lt TKey gt      where TUserLogin   IdentityUserLogin lt TKey gt      where TRoleClaim   IdentityRoleClaim lt TKey gt      where TUserToken   IdentityUserToken lt TKey gt             lt summary gt          Initializes a new instance of  lt see cref  IdentityDbContext   gt            lt  summary gt           lt param name  options  gt The options to be used by a  lt see cref  DbContext   gt   lt  param gt      public IdentityDbContext DbContextOptions options    base options                    lt summary gt          Initializes a new instance of the  lt see cref  IdentityDbContext    gt  class           lt  summary gt      protected IdentityDbContext                     lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of Users           lt  summary gt      public DbSet lt TUser gt  Users   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of User claims           lt  summary gt      public DbSet lt TUserClaim gt  UserClaims   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of User logins           lt  summary gt      public DbSet lt TUserLogin gt  UserLogins   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of User roles           lt  summary gt      public DbSet lt TUserRole gt  UserRoles   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of User tokens           lt  summary gt      public DbSet lt TUserToken gt  UserTokens   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of roles           lt  summary gt      public DbSet lt TRole gt  Roles   get  set              lt summary gt          Gets or sets the  lt see cref  DbSet TEntity    gt  of role claims           lt  summary gt      public DbSet lt TRoleClaim gt  RoleClaims   get  set              lt summary gt          Configures the schema needed for the identity framework           lt  summary gt           lt param name  builder  gt          The builder being used to construct the model for this context           lt  param gt      protected override void OnModelCreating ModelBuilder builder                builder Entity lt TUser gt  b   gt                        b HasKey u   gt  u Id               b HasIndex u   gt  u NormalizedUserName  HasName  UserNameIndex   IsUnique                b HasIndex u   gt  u NormalizedEmail  HasName  EmailIndex                b ToTable  AspNetUsers                b Property u   gt  u ConcurrencyStamp  IsConcurrencyToken                 b Property u   gt  u UserName  HasMaxLength 256               b Property u   gt  u NormalizedUserName  HasMaxLength 256               b Property u   gt  u Email  HasMaxLength 256               b Property u   gt  u NormalizedEmail  HasMaxLength 256               b HasMany u   gt  u Claims  WithOne   HasForeignKey uc   gt  uc UserId  IsRequired                b HasMany u   gt  u Logins  WithOne   HasForeignKey ul   gt  ul UserId  IsRequired                b HasMany u   gt  u Roles  WithOne   HasForeignKey ur   gt  ur UserId  IsRequired                         builder Entity lt TRole gt  b   gt                        b HasKey r   gt  r Id               b HasIndex r   gt  r NormalizedName  HasName  RoleNameIndex                b ToTable  AspNetRoles                b Property r   gt  r ConcurrencyStamp  IsConcurrencyToken                 b Property u   gt  u Name  HasMaxLength 256               b Property u   gt  u NormalizedName  HasMaxLength 256                b HasMany r   gt  r Users  WithOne   HasForeignKey ur   gt  ur RoleId  IsRequired                b HasMany r   gt  r Claims  WithOne   HasForeignKey rc   gt  rc RoleId  IsRequired                         builder Entity lt TUserClaim gt  b   gt                         b HasKey uc   gt  uc Id               b ToTable  AspNetUserClaims                         builder Entity lt TRoleClaim gt  b   gt                         b HasKey rc   gt  rc Id               b ToTable  AspNetRoleClaims                         builder Entity lt TUserRole gt  b   gt                         b HasKey r   gt  new   r UserId  r RoleId                 b ToTable  AspNetUserRoles                         builder Entity lt TUserLogin gt  b   gt                        b HasKey l   gt  new   l LoginProvider  l ProviderKey                 b ToTable  AspNetUserLogins                         builder Entity lt TUserToken gt  b   gt                         b HasKey l   gt  new   l UserId  l LoginProvider  l Name                 b ToTable  AspNetUserTokens                           Based on the source code if we want to merge IdentityDbContext with our DbContext we have two options  First Option  Create a DbContext which inherits from IdentityDbContext and have access to the classes      public class ApplicationDbContext        IdentityDbContext       public ApplicationDbContext             base  DefaultConnection                    static ApplicationDbContext                 Database SetInitializer lt ApplicationDbContext gt  new ApplicationDbInitializer                public static ApplicationDbContext Create                 return new ApplicationDbContext                  Add additional items here as needed     Extra Notes   1  We can also change asp net Identity default table names with the following solution       public class ApplicationDbContext   IdentityDbContext                   public ApplicationDbContext    base  DefaultConnection                                protected override void OnModelCreating System Data Entity DbModelBuilder modelBuilder                        base OnModelCreating modelBuilder               modelBuilder Entity lt IdentityUser gt    ToTable  user                modelBuilder Entity lt ApplicationUser gt    ToTable  user                 modelBuilder Entity lt IdentityRole gt    ToTable  role                modelBuilder Entity lt IdentityUserRole gt    ToTable  userrole                modelBuilder Entity lt IdentityUserClaim gt    ToTable  userclaim                modelBuilder Entity lt IdentityUserLogin gt    ToTable  userlogin                      2  Furthermore we can extend each class and add any property to classes like  IdentityUser    IdentityRole            public class ApplicationRole   IdentityRole lt string  ApplicationUserRole gt        public ApplicationRole                  this Id   Guid NewGuid   ToString               public ApplicationRole string name            this                 this Name   name                Add any custom Role properties code here        Must be expressed in terms of our custom types  public class ApplicationDbContext        IdentityDbContext lt ApplicationUser  ApplicationRole       string  ApplicationUserLogin  ApplicationUserRole  ApplicationUserClaim gt        public ApplicationDbContext             base  DefaultConnection                    static ApplicationDbContext                 Database SetInitializer lt ApplicationDbContext gt  new ApplicationDbInitializer                public static ApplicationDbContext Create                 return new ApplicationDbContext                  Add additional items here as needed     To save time we can use AspNet Identity 2 0 Extensible Project Template to extend all the classes   Second Option  Not recommended   We actually don t have to inherit from IdentityDbContext if we write all the code ourselves   So basically we can just inherit from DbContext and implement our customized version of  OnModelCreating ModelBuilder builder   from the IdentityDbContext source code

[asp.net] ASP.NET Identity DbContext confusion

Examples related to asp.net

Examples related to asp.net-mvc

Examples related to entity-framework

Examples related to asp.net-mvc-5

Examples related to asp.net-identity