Package 'Microsoft.EntityFrameworkCore.SqlServer' is incompatible with 'all' frameworks in the project

Question

I was trying to add the package named Microsoft.EntityFrameworkCore.SqlServer by running the command.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer

in Visual Studio Code, but I get this error:

Package Microsoft.EntityFrameworkCore.SqlServer 2.0.0 is not compatible with netcoreapp1.1 (.NETCoreApp,Version=v1.1). Package Microsoft.EntityFrameworkCore.SqlServer 2.0.0 supports: netstandard2.0" (.NETStandard,Version=v2.0). Package 'Microsoft.EntityFrameworkCore.SqlServer' is incompatible with 'all' frameworks in project 'C:\users\username..'

Answer 1

I was using version 1.1. Try to run the below command including the version number:

Visual Studio Code:

'dotnet add package Microsoft.EntityFrameworkCore.SqlServer -v 1.1.1'

Visual Studio:-

'Install-Package Microsoft.EntityFrameworkCore.SqlServer -v 1.1.1'

Answer 2

In order to use version 2.0.0 of EF Core, you need the .NET Core 2.0 SDK and/or Visual Studio 2017 version 15.3.

Answer 3

This Might Be Happening due to generated NuGet Cache While Installing Packages. Go to Tools>Options>NuGet Package Manager>General and "Clear All NuGet Cache". This Worked in my case(VS Community 2019).

Also try to update Source of nuget.org by going to Tools>Options>NuGet Package Manager>Package Source and click Update Source in case of VS 2017.

Answer 4

In case I had a similar issue with the same error message.

I cloned a project which was using netcoreapp2.1 and my version was 2.2.

I updated the TargetFramework (*.csproj) to netcoreapp2.2. Then, I was able to install the package.

Answer 5

Install the SDK required (eg: dotnet-sdk-5.0.203-win-x64.exe).delete obj and bin folders. Rebuild the project. This worked for me.