auto create database in Entity Framework Core

by

If you have created the migrations, you could execute them in the Startup.cs as follows.

 public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
 {
      using (var serviceScope = app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
      {
            var context = serviceScope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
            context.Database.Migrate();
      }
      
      ...

This will create the database and the tables using your added migrations.

If you’re not using Entity Framework Migrations, and instead just need your DbContext model created exactly as it is in your context class at first run, then you can use:

 public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
 {
      using (var serviceScope = app.ApplicationServices.GetService<IServiceScopeFactory>().CreateScope())
      {
            var context = serviceScope.ServiceProvider.GetRequiredService<ApplicationDbContext>();
            context.Database.EnsureCreated();
      }
      
      ...

Instead.

If you need to delete your database prior to making sure it’s created, call:

            context.Database.EnsureDeleted();

Just before you call EnsureCreated()

Adapted from: http://docs.identityserver.io/en/latest/quickstarts/7_entity_framework.html?highlight=entity

More Related Contents:

  1. How to auto create database on first run?
  2. How to instantiate a DbContext in EF Core
  3. Filter all queries (trying to achieve soft delete)
  4. How to add the same column to all entities in EF Core?
  5. Command dotnet ef not found
  6. How to unapply a migration in ASP.NET Core with EF Core
  7. Cascade deleting with EF Core
  8. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  9. How to seed in Entity Framework Core 2?
  10. Entity framework EF.Functions.Like vs string.Contains
  11. EF Core queries all columns in SQL when mapping to object in Select
  12. How to refresh an Entity Framework Core DBContext?
  13. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  14. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  15. How to get user information in DbContext using Net Core
  16. How should I manage DbContext Lifetime in MVC Core?
  17. How to create a password protected database?
  18. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  19. SQLite Insert very slow?
  20. System.Text.Json: How do I specify a custom name for an enum value?
  21. The current .NET SDK does not support targeting .NET Core 2.2. (SDK 2.2.202)
  22. Killing gracefully a .NET Core daemon running on Linux
  23. Include ONLY .xml file of SPECIFIC nuget package in a different folder
  24. Unable to find the requested .Net Framework Data Provider – SQLite
  25. EF models. Navigation properties can only participate in a single relationship
  26. Using a Scoped service in a Singleton in an Asp.Net Core app
  27. How to use SqlClient in ASP.NET Core?
  28. Difference between .Net Core, Portable, Standard, Compact, UWP, and PCL?
  29. How to load navigation properties on an IdentityUser with UserManager
  30. Implementing recursive property loading in EF Core

Leave a Comment