The provider did not return a ProviderManifest instance

c# entity-framework connection-string entity-framework-6 entitydatasource
Parsa picture Parsa · Sep 23, 2014 · Viewed 8.2k times · Source

when I want to configure my Datasource (EntityDataSource1) and assign the connectionString that is generated automatically by entity data model to it. I get the error:

"The metadata specified in the connection string could not be loaded. Consider rebuilding the web project to build assemblies that may contain metadata. The following error(s) occurred: The provider did not return a ProviderManifest instance".

I read so many suggestions like http://blogs.teamb.com/craigstuntz/2010/08/13/38628/ They all suggest to replace * with assembly-name in connection string. for example :

<connectionStrings>
    <add name="MyEntities" connectionString="metadata=
            res://*/Model.csdl|
            res://*/Model.ssdl|
            res://*/Model.msl;provider= <!-- ... -->

replace with

<connectionStrings>
    <add name="MyEntities" connectionString="metadata=
            res://Simple Mvc.Data.dll/Model.csdl|
            res://Simple Mvc.Data.dll/Model.ssdl|
            res://Simple Mvc.Data.dll/Model.msl;provider= <!-- ... -->

my question is. Where can I find name of assembly? I installed .Net Reflector as well but i could not find the correct assembly name for entity data model.

Answer

Parsa picture Parsa · Sep 23, 2014

I found a solution for this error.

I keep my connectionString as same as before (I mean with *) then I opened the EDMX file with notepad and change ProviderManifestToken="2012" to ProviderManifestToken="2008" That's it ;)

Now I can configure the EntityDataSourc with existing connectionString

Related questions

Entity Framework Timeouts

I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. I tried the following and have not been able to resolve this issue: I added Default Command Timeout=300000 to the …

Read More
Entity Framework change connection at runtime

I have a web API project which references my model and DAL assemblies. The user is presented with a login screen, where he can select different databases. I build the connection string as follows: public void Connect(Database database) { //Build …

Read More
Get SqlConnection from DbConnection

I have an Extension method on DbContext where I want to do a SqlBulkCopy. Therefore I need a SqlConnection. The connection from the DbContext is from the type DbConnection though. Among a few other things I tried this: var connection = …

Read More