EntityFramework

Question

Hi

 

I am working with EntityFramework .whenever I run the project it says  

 

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

The connection is fine with other projects. Only with entityframework it is giving the error. I changed the name in connectionstring to match with the class derived from DbContext. 

Answer 1

Problem is supposed to be reside in the Metadata definition of the edmx file.

 If you are using EntityConnectionStringBuilder & If your edmx is in same project, then it should look something as below: (I have folder hierarchy so it looks bit large.)

 

EntityConnectionStringBuilder Object.Metadata = string.Format("res://*/Folder1.SubFolder.EDMXFolder.EDMXFileName.csdl|res://*/Folder1.SubFolder.EDMXFolder.EDMXFileName.ssdl|res://*/Folder1.SubFolder.EDMXFolder.EDMXFileName.msl";

 

 If it is in different project, it should start with project name. Folder name and so on.

 

 

Please take a look at how to build connection string at below link.

 

https://msdn.microsoft.com/en-us/library/bb738533(v=vs.110).aspx

 

 

Please mark it as an answer if it resolves the issue. 

 

Answer 2

Please make sure that connection string is correct. Secondly make sure that server instance is running mode in server.

Answer 3

Hi,

 

Please check the below nice link:

 

http://stackoverflow.com/questions/24398247/entity-framework-database-issue-a-network-related-or-instance-specific-error-o

http://stackoverflow.com/questions/7781426/entity-framework-throws-exception-network-related-or-instance-specific-error-o

 

Note: Please accept the answer if it help you and answer your question.

 

Thanks & Regards,

Ritesh