How do I solve The Entity Framework provider exception

c# asp.net-mvc entity-framework wcf publish
ife labolz picture ife labolz · May 16, 2016 · Viewed 27.4k times · Source

I have published my WCF project onto a server, i have also published an MVC application onto the same box which consumes the WCF services.

When trying login on my MVC application, this uses a wcf service, but i get this exception on the browser,

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.

This is an entity framework exception, but i assume since my project already references EF in the dev environment, after deploying the service project, the DLLs should contain the EF reference also but I am not sure why I am getting this error.

I can see this message because I turned on the includeExceptionDetailInFaults="True"

Answer

Nazmul Hasan picture Nazmul Hasan · May 16, 2016

@FranciscoGoldenstein saying ! You don't need to install Entity Framework in your Console application or whatever, you just need to add a reference to the assembly EntityFramework.SqlServer.dll. You can copy this assembly from the Class Library project that uses Entity Framework to a LIB folder and add a reference to it.

In summary:

  • Class Library application:
    • Install Entity Framework
    • Write your data layer code
    • app.config file has all the configuration related to Entity Framework except for the connection string.
  • Create a Console, web or desktop application:
    • Add a reference to the first project.
    • Add a reference to EntityFramework.SqlServer.dll.
    • app.config/web.config has the connection string (remember that the name of the configuration entry has to be the same as the name of the DbContext class.

it is work for me ! I hope it helps.

also try this link Entity Framework Provider type could not be loaded?

Related questions

Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework

I want to save my Edit to Database and I am using Entity FrameWork Code-First in ASP.NET MVC 3 / C# but I am getting errors. In my Event class, I have DateTime and TimeSpan datatypes but in my database, I've …

Read More
Value cannot be null. Parameter name: source

This is probably the biggest waste of time problem I have spent hours on solving for a long time. var db = new hublisherEntities(); establishment_brands est = new establishment_brands(); est.brand_id = 1; est.establishment_id = 1; est.price = collection["price"]; est.…

Read More
Set database timeout in Entity Framework

My command keeps timing out, so I need to change the default command timeout value. I've found myDb.Database.Connection.ConnectionTimeout, but it's readonly. How can I set the command timeout in Entity Framework 5 ?

Read More