Change connection string in Entity Framework(Model First)

Question

I am using entity framework model first approach in WCF. The EF creates a connection stringwhich looks something like this:

automatically for the first time.

Now I want to change the connection string as database is located in other server.

How can I do it?

Connection string looks like this for now:

<connectionStrings><add name="Entities" connectionString="metadata=res://*/Database.Model1.csdl|res://*/Database.Model1.ssdl|res://*/Database.Model1.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string=&quot;data source=AB;password=admin;persist security info=True;user id=TEST&quot;" providerName="System.Data.EntityClient" /></connectionStrings>)

Regards Anudeep

reckface · Accepted Answer · 2014-02-11 09:53:02Z

2

One simple way is to modify the app.config or web.config file with the new connection details so calling the var context = new DataContext("NewServerEntities") constructor will use the named connection in your config file.

<add name="NewServerEntities" connectionString="metadata=res://*/Database.Model1.csdl|res://*/Database.Model1.ssdl|res://*/Database.Model1.msl;provider=Oracle.ManagedDataAccess.Client;provider connection string=&quot;data source=NewServer;password=admin;persist security info=True;user id=TEST&quot;" providerName="System.Data.EntityClient" />

answered Feb 11, 2014 at 9:53

reckface

5,9086 gold badges40 silver badges62 bronze badges

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

Comments

Naveen · Accepted Answer · 2014-02-11 09:56:44Z

2

Remove the connection string from the app.config file, re-run the entity Data Model wizard by right-clicking the designer and chose Update Model From Database, it will guide you to build a new connection. Or else directly edit the Datasource and credentials in the existing connection string in App.config.

answered Feb 11, 2014 at 9:56

Naveen

1,5021 gold badge15 silver badges24 bronze badges

Collectives™ on Stack Overflow

Change connection string in Entity Framework(Model First)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related