How to fix 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer'

The error message "'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer' and no accessible extension method 'UseSqlServer'" typically occurs when the necessary NuGet package for Entity Framework Core SQL Server is not installed or not properly referenced in your project.

Error

Severity Code Description Project File Line Suppression State

Error CS1061 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer' and no accessible extension method 'UseSqlServer' accepting a first argument of type 'DbContextOptionsBuilder' could be found (are you missing a using directive or an assembly reference?)

The error occurs because the UseSqlServer method is not recognized by the DbContextOptionsBuilder. This typically means the required Microsoft.EntityFrameworkCore.SqlServer package is missing from the project.

To resolve this issue, you need to ensure that you have the necessary packages installed and properly configured in your project.

Make sure you have installed the package for SQL Server provider.

You can do that by right-clicking on your project, then select Manage Nuget Packages => Search for 'Microsoft.EntityFrameworkCore.SqlServer' and install it to your ASP.Net Core project.

PM > Install-Package Microsoft.EntityFrameworkCore.SqlServer

Ensure that you have the correct using directive at the top of your C# file where you are configuring the DbContextOptionsBuilder.

using Microsoft.EntityFrameworkCore;

Manually delete the Bin, Obj, package, and .vs directories in your project to resolve potential build or dependency issues.

Then, right-click on the project to clean and rebuild it.