CODEWITHSUNDEEP
c#asp.netsql-serverentity-framework
Anthony
Anthony

Reputation: 342

Connecting to database in Visual Studio Express 2013 for Web

I'm using Visual Studio Express 2013 for web and I'm following this tutorial : http://www.codeproject.com/Articles/791740/Using-AngularJs-ASP-NET-MVC-Web-API-and-EntityFram which specifies this connection to connect ot the db:

<add name="MainDb" connectionString="Server=localhost; Database=SimpleTaskSystemDb; Trusted_Connection=True;" providerName="System.Data.SqlClient" />

but when I run Update-Database I get this error:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I've also finished the Music Store app which is working fine and the connection there is different:

<add name="MusicStoreEntities" connectionString="Data Source=|DataDirectory|MusicStore.sdf" providerName="System.Data.SqlServerCe.4.0"/>

I tried a similar connection string but that didn't work either.

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'. Make sure the provider is registered in the 'entityFramework' section of the application config file.

However the Music Store app.config file does not reference System.Data.SqlServerCe.4.0 but I added it to this app anyway and then I get back to my original error.

enter image description here

Any help would be greatly appreciated.

Upvotes: 0

Views: 1585

Answers (1)

Husrat Mehmood
Husrat Mehmood

Reputation: 2310

Here are some of the sample connection strings I have described every connection string with full details

For Local Sql server (BuildIn Sql Server Express into Visual Studio).

 For Sql Server instance which comes default with visual studio you can use following connection string  

 <connectionStrings>
<add name="ConnectionStringName" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=YourDatabaseName;Integrated Security=True"
  providerName="System.Data.SqlClient" />

For Sql Server Which Has been installed seperately such as Evaluation Edition etc

 <connectionStrings>
    <add name="ConnectionStringName" connectionString="Data Source=YourPCName-PC\ServerInstanceName;Initial Catalog=YourDatabaseName;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

For CompactEdition of Sql server you can use provider name as

providerName="System.Data.SqlServerCe.4.0"

Upvotes: 1

Related Questions