Entity Framework Core: DbContextOptionsBuilder does not contain a definition for ‘usesqlserver’ and no extension method ‘usesqlserver’

by

First we install the Microsoft.EntityFrameworkCore.SqlServer NuGet Package:

PM > Install-Package Microsoft.EntityFrameworkCore.SqlServer

Then, after importing the namespace with

using Microsoft.EntityFrameworkCore;

we add the database context:

services.AddDbContext<AspDbContext>(options =>
    options.UseSqlServer(config.GetConnectionString("optimumDB")));

More Related Contents:

  1. How to run stored procedures in Entity Framework Core?
  2. Entity Framework Core service default lifetime
  3. why remove-migration run my app?
  4. How to update the model when using database first approach
  5. AddDbContext or AddDbContextPool
  6. where to download the dotnet-dev-win-x86.1.0.0-preview 2-1-003180
  7. Dynamically change connection string in Asp.Net Core
  8. Where are the Login and Register pages in an AspNet Core scaffolded app?
  9. How to instantiate a DbContext in EF Core
  10. Unable to create migrations after upgrading to ASP.NET Core 2.0
  11. Dynamically changing schema in Entity Framework Core
  12. EF CORE 2.1 HasConversion on all properties of type datetime
  13. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  14. Loop/reflect through all properties in all EF Models to set Column Type
  15. .NET Core vs ASP.NET Core
  16. How to set redirect_uri protocol to HTTPS in Azure Web Apps
  17. ASP.NET Core change EF connection string when user logs in
  18. Avoid or control circular references in Entity Framework Core
  19. Using EF Core ThenInclude() on Junction tables
  20. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  21. Add migration with different assembly
  22. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  23. How to publish environment specific appsettings in .Net core app?
  24. What goes into DbContextOptions when invoking a new DbContext?
  25. Configure cors to allow all subdomains using ASP.NET Core (Asp.net 5, MVC6, VNext)
  26. Read request body twice
  27. How to get user information in DbContext using Net Core
  28. How should I manage DbContext Lifetime in MVC Core?
  29. How to inject a reference to a specific IHostedService implementation?
  30. Store / Retrieve ConnectionString from appSettings.json in ASP.net Core 2 MVC app

Leave a Comment