How to instantiate a DbContext in EF Core

by

Instantiate new object of DbContext from ConnectionString

var connectionstring = "Connection string";

var optionsBuilder = new DbContextOptionsBuilder<ApplicationDbContext>();
    optionsBuilder.UseSqlServer(connectionstring);


ApplicationDbContext dbContext = new ApplicationDbContext(optionsBuilder.Options);

// Or you can also instantiate inside using

using(ApplicationDbContext dbContext = new ApplicationDbContext(optionsBuilder.Options))
{
   //...do stuff
}

More Related Contents:

  1. Command dotnet ef not found
  2. How to unapply a migration in ASP.NET Core with EF Core
  3. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  4. How to get user information in DbContext using Net Core
  5. How should I manage DbContext Lifetime in MVC Core?
  6. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  7. How to read AppSettings values from a .json file in ASP.NET Core
  8. Return View as String in .NET Core
  9. How to mock an async repository with Entity Framework Core
  10. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  11. Automatic native and managed DLLs extracting from Nuget Package
  12. Send HTTP POST message in ASP.NET Core using HttpClient PostAsJsonAsync
  13. Cascade deleting with EF Core
  14. How to make EF-Core use a Guid instead of String for its ID/Primary key
  15. How to seed in Entity Framework Core 2?
  16. In-memory database doesn’t save data
  17. Proper way to register HostedService in ASP.NET Core. AddHostedService vs AddSingleton
  18. EF Core queries all columns in SQL when mapping to object in Select
  19. Setting the version number for .NET Core projects – CSPROJ – not JSON projects
  20. System.Text.Json: Deserialize JSON with automatic casting
  21. ASP – Core Migrate EF Core SQL DB on Startup
  22. How do I reference a .NET Framework project in a .NET Core project?
  23. How to refresh an Entity Framework Core DBContext?
  24. Refresh Token using Polly with Named Client
  25. Using a Scoped service in a Singleton in an Asp.Net Core app
  26. Dependency Injection with classes other than a Controller class
  27. Cannot find command ‘dotnet ef’
  28. ASP.NET Core modify/substitute request body
  29. What Nuget packages must be referenced by an ASP.NET Core 6 application parts project
  30. No service for type ‘Microsoft.AspNetCore.Identity.UserManager`1[Microsoft.AspNetCore.Identity.IdentityUser]’ has been registered

Leave a Comment