No Entity Framework provider found ... with invariant name 'System.Data.SqlClient'

Question

None of the posts on here has seemed to address this specific version of my error but I may just be missing something...

Situation:

MVC website consumes a WCF service. Data is saved in the WCF service. Both are running

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

Both have connection string:

    <add name="SiteTrackerEntities" connectionString="metadata=res://*/VisitorInformation.csdl|res://*/VisitorInformation.ssdl|res://*/VisitorInformation.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=BADLANDS\;initial catalog=SiteTracker;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Site runs until I actually try to save to the database in the WCF service using (errors on second line)...

SiteTrackerEntities db = new SiteTrackerEntities();
db.Entry(visitorData).State = System.Data.Entity.EntityState.Added;

I then get this lovely error:

VisitorInformation.ssdl(2,2) : error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

Made sure that both are using the same version of EF (6.0). Check.
Tried to enter the provider name in the connection string but already using providerName="System.Data.EntityClient"
Tried removing and reinstalling EF using PM console. Check.
Manually removed Ef references and readded them. Check.
WCF Service has reference to Entity.Framework.SqlServer (version 6.0.0.0). Check.
MVC application has connection string to the database that is only used in the WCF service (odd that it needs it but okay). Check.

What am I missing?

Multiproject solution. Running it in the PM console added it to both projects, modified both .config files to sync up to the same version. Moo pointed me in the right direction. — user4593252
– user4593252, Commented Jun 12, 2014 at 14:26

user32826 · Accepted Answer · 2014-06-12 14:11:08Z

6

Make sure you have something similar to the following in your Web.config or App.config.

<entityFramework>
   <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
   <providers>
     <provider invariantName="System.Data.SqlClient"         type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
   </providers>
</entityFramework>

answered Jun 12, 2014 at 14:11

user32826

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

4 Comments

user4593252 Over a year ago

That did it. It was already in the app config but not the web config. It doesn't error on that line anymore but is now blathering on about no insert function existing or some nonsense. You get the answer and the vote! Thanks

user4593252 Over a year ago

Question: why does the MVC project need to have the data information in web.config even though the WCF service is the one accessing the database?

tranceporter Over a year ago

That's because .net uses the config file of the calling application by default. Which in most cases is the main web/windows application.

user4593252 Over a year ago

Thanks. I guess I'm thinking a bit too extreme in the "modular coding" paradigm.

Collectives™ on Stack Overflow

No Entity Framework provider found ... with invariant name 'System.Data.SqlClient'

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related