Dynamically Create DB Connection String for Entity in MVC 4

Question

I have an entity in MVC 4 project and the connection string is placed in the web.config by the entity creation wizard.

I need to change this and assign the password to the connection string (which is stored outside the web.config) at run time.

How can I combine values outside the web.config with a string stored inside the web.config?
Or can I move the entity connection completely outside the web.config?

This is the existing entity connection string:

add name="MyEntities" connectionString="metadata=res://*/Models.NewUsers.csdl|res://*/Models.NewUsers.ssdl|res://*/Models.NewUsers.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=mydb;initial catalog=MyDatabase;persist security info=True;user id=sa;password=Mypassword;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /></connectionStrings>

Craig Stuntz · Accepted Answer · 2012-11-28 13:25:32Z

3

For 2, you can always pass a new connectionString (not from web.config) directly to the context when you create it:

string newCS = "add name=...";
var context = new MyEntities(newCS);

For 1, use EntityConnectionStringBuilder to parse an existing CS or build a new one.

answered Nov 28, 2012 at 13:25

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

Comments

Peter Smith · Accepted Answer · 2012-11-28 13:21:36Z

1

A simple solution might be to use something based on:

string con = ConfigurationManager.ConnectionStrings["PerinatalDataEntities"].
    ConnectionString;
con = con.replace("user id=sa", "user id=MyUser").
    Replace("password=Mypassword","password=MyNewpassword")

I believe there is also a connection builder but I've never used it.

answered Nov 28, 2012 at 13:21

Peter Smith

5,5529 gold badges54 silver badges80 bronze badges

1 Comment

andleer Over a year ago

Using the EntityConnectionStringBuilder is a much better approach.

Collectives™ on Stack Overflow

Dynamically Create DB Connection String for Entity in MVC 4

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related