The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' could not be loaded

.net entity-framework wcf winforms

Question

I created a WCF Service using dotNet 4.5. The database layer is built with Entity Framework 6.

I hosted the service with IIS 8. It is working fine.

Now I need to consume the service with windows forms client, that is built using dotnet framework 3.5.

I can create the service reference successfully. But when I run the code, getting the following error;

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.

Any suggestions?

1
4
9/30/2016 11:48:26 PM

Accepted Answer

I fixed this by installing entity framework in the WCF host site.

That worked.

2
9/30/2015 6:23:53 AM

Popular Answer

You don't need to Install EF6 NuGet Package in client application, The error is not related to client application because the client application connects to WCF Services and don't know even if a database or data access layer exists.

This error is related to lack of EntityFramework.SqlServer.dll in bin folder of your service library and/or host project.

Option 1

The most simple way is to install EF6 using NuGet Package Manager in your WCF Host project too, and if it has been installed before, try uninstalling and installing it again. This way EntityFramework.SqlServer.dll to output directories.

Please note that this way is somehow against n-layered rules because this your libraries above data access layer are dependent to EF6 which is not so good.

Option 2

As a workaround to copy EntityFramework.SqlServer.dll in output directories, make sure Copy Local of this dll is set to true and then put this code in your DbContext constructor:

var ensureDllIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance; 

It ensures EntityFramework.SqlServer.dll is copied to output directory of consumers of data access project. This is a workaround.

Using this way you don't have any dependency to EF in your layers above data access layer.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow