Entity Framework Core Using multiple DbContexts

by

I figured it out. This mostly came about because I accidentally deleted the database that Identity was using and I needed to figure out how to get it back.

Apparently there’s nothing wrong with my connection string the way it is. I just needed to go into the package manager and type these commands in this order:

  1. Add-Migration init -Context PartsDbContext
  2. Update-Database -Context PartsDbContext

I found this out because that is what I had to do to get my ApplicationDbContext working again and it turns out that this step is done for you when you create a new MVC Core Web Application in Visual Studio using Individual User Authentication.

So basically the steps for adding more DbContexts is to:

  1. Create a DbContext Class
  2. Create a Connection string for that DbContext in appsettings.json
  3. Add the DbContext to your configured services in Startup.cs
  4. Setup the DbContext in the controllers that will use it.
  5. Open the package manager and run the 2 lines above. (if “-Context” doesn’t work try “–context”
  6. Run your program and let EntityFrameworkCore take care of the rest.

More Related Contents:

  1. One DbContext per web request… why?
  2. Get SQL code from an Entity Framework Core IQueryable
  3. Entity Framework Core 2.0.1 Eager Loading on all nested related entities
  4. Dynamically access table in EF Core 2.0
  5. How to mock an async repository with Entity Framework Core
  6. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  7. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  8. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  9. How to instantiate a DbContext in EF Core
  10. Map category parent id self referencing table structure to EF Core entity
  11. Filter all queries (trying to achieve soft delete)
  12. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  13. Why re-initiate the DbContext when using the Entity Framework?
  14. Cascade deleting with EF Core
  15. How to make EF-Core use a Guid instead of String for its ID/Primary key
  16. Configure multiple database Entity Framework 6
  17. How to seed in Entity Framework Core 2?
  18. In-memory database doesn’t save data
  19. How do you show underlying SQL query in EF Core?
  20. EF Core queries all columns in SQL when mapping to object in Select
  21. Entity Framework Core: Guid Greater Than for Paging
  22. ASP – Core Migrate EF Core SQL DB on Startup
  23. How to refresh an Entity Framework Core DBContext?
  24. Entity Framework Core Many to Many change navigation property names
  25. EF models. Navigation properties can only participate in a single relationship
  26. “Build failed” on Database First Scaffold-DbContext
  27. DbSet doesn’t have a Find method in EF7
  28. NSubstitute DbSet / IQueryable
  29. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists
  30. Entity Framework Core RC2 table name pluralization

Leave a Comment