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

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 2

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.