Asp.Net 5 "Schema specified is not valid. Errors: error 0152: No Entity Framework provider found for the ADO.NET

Question

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.

Is this ASP.NET MVC 5 or ASP.NET 5(vNext)? If so then I guess you need to add frameworks dependency in project.json. — Mithun Pattankar
– Mithun Pattankar, Commented Oct 28, 2015 at 19:12
I have these dependencies already in Project.json file: "EntityFramework": "6.1.3", "EntityFramework.SqlServerCompact": "6.1.3" — mz1378
– mz1378, Commented Oct 28, 2015 at 19:18
Not sure how much this link is helpful stackoverflow.com/questions/20111583/… — Mithun Pattankar
– Mithun Pattankar, Commented Oct 28, 2015 at 19:31
@mz1378 If you are targeting Core framework, try targeting full version. — Siva Gopal
– Siva Gopal, Commented Oct 28, 2015 at 19:59
I have: "dnx451": { "dependencies": { "DataAccess": "1.0.0-*" } } in my project json. — mz1378
– mz1378, Commented Oct 28, 2015 at 20:01

mz1378 · Accepted Answer · 2015-10-28 23:06:54Z

13

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.

answered Oct 28, 2015 at 23:06

mz1378

2,6327 gold badges31 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Md Shoaib Alam Over a year ago

Thanks for sharing really helpful ! for me installing EntityFramework and EntityFramework.SqlServerCompact using Nuget Manager was sufficient .

bummi · Accepted Answer · 2018-12-18 16:51:27Z

1

usually this error occurs due to the Entityframework. follow the following

Add entityframeworkcore from the NuGet,
Add entityframeworkdesign.
Add entityframework.sqlserver.compact

last give a rebuild for the solution the above method worked for me as I also found that issue.

edited Dec 18, 2018 at 16:51

bummi

27.4k14 gold badges67 silver badges105 bronze badges

answered Dec 18, 2018 at 16:43

AhmAr KAka

517 bronze badges

Collectives™ on Stack Overflow

Asp.Net 5 "Schema specified is not valid. Errors: error 0152: No Entity Framework provider found for the ADO.NET

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related