System.NotSupportedException: 'Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config

[maddy027]

dotnet/ef6#623

Code is available here https://github.com/maddy027/IssueWithEF6WithCore.git
when I tried to use EDMX with Asp.net core , getting the below error
System.NotSupportedException: 'Unable to determine the provider name for provider factory of type 'System.Data.SqlClient.SqlClientFactory'. Make sure that the ADO.NET provider is installed or registered in the application config

VS: 2017 15.8
EF: 6.2

[ajcvickers]

@maddy027 This project file: https://github.com/maddy027/IssueWithEF6WithCore/blob/master/CoreWithEF/CoreWithEF.csproj

targets .NET Core and references the EntityFramework package. This is not supported. If the documentation you are using results in this kind of project structure, then the documentation needs to be changed. As I said on the other issue, this should be reported as a "content feedback". See here:

[maddy027]

@ajcvickers Yes , in the doc you can find the below instructions:
:

Create a solution.

Add New Project > Web > ASP.NET Core Web Application (.NET Framework)

Add New Project > Windows Classic Desktop > Class Library (.NET Framework)

In Package Manager Console (PMC) for both projects, run the command Install-Package Entityframework.