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?)

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

Here are the steps you can take:

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;