Connection string for Entity Framework

asp.net c# entity-framework

Question

I'm not sure what to regarding the following problem so any help would be appreciated. I'm working on an application that is connected to the online MSSQL database and everything is working fine. The model I'm using is entity model.

The problem is that I have to change the connection string from the online database to the local one, but I don't know how. Creating new model isn't an option. I tried changing the connection string in web.config, but errors are the only thing I get...

This is what I have in web.config:

<connectionStrings>
<add name="PravosudnaAkademijaEntities" connectionString="metadata=res://*/PrakModel.csdl|res://*/PrakModel.ssdl|res://*/PrakModel.msl;provider=System.Data.SqlClient;provider connection string='Data Source=MY-PC;Initial Catalog=pak_baza;Integrated Security=True" providerName="System.Data.EntityClient" />

1
5
4/23/2019 9:33:57 AM

Accepted Answer

"Data Source=HRVOJE-PC;Initial Catalog=pak_baza;Integrated Security=True"

This is the part you should be changing, it's just your regular SQL server connection string, HRVOJE-PC is the machine name or IP, pak the name of your database. If you have a DB on your local machine you want to replace HRVOJE-PC with localhost.

For examples of SQL Server connection strings check here

9
3/3/2011 4:18:03 AM

Popular Answer

Alternatively, there is a DataContext constructor that takes a connection string parameter that you could use if it's a temporary change and are planning to switch back to the one that you used to use.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow