Entity framework mvc .net

mayur pandit

Please anyone help me.i have problem with entity database connection.

i have mvc project this is run online successully . but i am trying to connect with local database but this exeption is caught. i also change connection in web config for local database after that i fetch that problem

EntityExeption was caught-

The underlying provider failed on Open.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger9y ago
this error come because connection string not match. put your valid connection string like
"ModEntity" connectionString="metadata=res://*/ModEntity.csdl|res://*/ModEntity.ssdl|res://*/ModEntity.msl;provider=System.Data.SqlClient;provider connection string="Data Source=SomeServer;Initial Catalog=SomeCatalog;Persist Security Info=True;User ID=Entity;Password=SomePassword;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
"Entity" connectionString="metadata=res://*/Entity.csdl|res://*/Entity.ssdl|res://*/Entity.msl;provider=System.Data.SqlClient;provider connection string="Data Source=SOMESERVER;Initial Catalog=SOMECATALOG;Persist Security Info=True;User ID=Entity;Password=Entity;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />
+1
Bhuvan Pandey9y ago
If you local database and online database both are same. Then try to update your model.
Right click-> update model.
+2
mayur pandit9y ago

I have use entity framework,I put heare my local database connection manually without upgrading entity database because my online and local database is same
+1
Vishal Prajapati9y ago
please post the source code in .rar format so that we can go through the code and find the problem.
+1