I have 2 projects in a solution one asp.net 5, and one class library project containing EFModel. I used install-package to install : "EntityFramework": "6.1.3", "EntityFramework.SqlServerCompact": "6.1.3" on both projects and have the connection string in both classlibrary\app.config and wwwroot\web.config I searched the internet some said placing:
<entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework"> <parameters> <parameter value="System.Data.SqlServerCe.4.0" /> </parameters> </defaultConnectionFactory> <providers> <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> <provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" /> </providers> </entityFramework>â€‹
in web.config solves the problem, I have this section in app.config and when I try to place this in web.config file I get angularjs inject error. My entity framework code gets me the error: "Schema specified is not valid. Errors: error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'. Make sure ... And I am not able to solve this, help Please.
I Solved my problem as bellow: Although I added EntityFramework and EntityFramework.SqlServerCompact using Nuget once for every project in the solution and my project.json says that: "EntityFramework": "6.1.3", "EntityFramework.SqlServerCompact": "6.1.3", But I noticed that Visual Studio did a nasty job of referencing all packages from the ClassLibrary project, So I copied all the assemblies from classlibrary project's bin to MainProject bin and add a reference to all of them through browsing, And Finally copied required Auto Generated configurations from ClassLibrary's app.config to MainProject's web.config and Problem Solved.
usually this error occurs due to the Entityframework. follow the following
entityframeworkcore from the NuGet,
last give a rebuild for the solution the above method worked for me as I also found that issue.