Entity framework connection string

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" />

which online Mssql hosting service you are using and how to connect with online because in my case it shows error while online localhost work fine — Ahmad
– Ahmad, Commented Mar 11, 2018 at 15:13

BrokenGlass · Accepted Answer · 2011-03-03 04:18:03Z

9

"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

edited Mar 3, 2011 at 4:18

answered Mar 3, 2011 at 3:12

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wegelagerer Over a year ago

Thank you, that's the answer, I really don't know how couldn't I see something that obvious! Thank you once again for explanation!

Bala R · Accepted Answer · 2011-03-03 03:18:00Z

2

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.

answered Mar 3, 2011 at 3:18

Bala R

109k23 gold badges203 silver badges212 bronze badges

Comments

sajoshi · Accepted Answer · 2011-03-03 03:21:03Z

1

Other way would be copy the connection string and make another one for your local. Open you EDMX properties and in the connectionstrings dropdown select the local connectionstring.

answered Mar 3, 2011 at 3:21

sajoshi

2,7631 gold badge18 silver badges22 bronze badges

Comments

user2529558 · Accepted Answer · 2013-07-26 22:50:42Z

0

I don't know if this is recommended but I think it will work.

In the model.context.cs file there is a constructor:

public ModeEntities() : base("name=ConnectionStringName_In_Config") { }

if we create another constructor in that file such as:

public ModeEntities(string connName) : base("name=" + connName) { }

Then we can pass any connectionstring we want using the new constructor assuming the replaced connstring has the same database structure as the original EF connstring.

answered Jul 26, 2013 at 22:50

user2529558

11 bronze badge

Collectives™ on Stack Overflow

Entity framework connection string

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related