Connection Strings - MVC Entity Framework - Database First

Question

Can anyone suggest how I could programatically switch debug and live connection strings?

I've seen other people have passed an EntityConnection to the constructor from the controller like this :

private XYZDatabase db = new XYZDatabase(ConfigurationManager.
ConnectionStrings["XYZDatabase-TEST"].ConnectionString);

but it still requires manually changing it? is there a way to use

System.Net.Dns.GetHostName() or similar to switch it automatically?

Thanks

ckal · Accepted Answer · 2012-12-10 18:53:52Z

1

Ayende has a post that addresses this issue.

http://ayende.com/blog/135169/frictionless-development-web-config-and-connection-strings

answered Dec 10, 2012 at 18:53

ckal

3,5802 gold badges25 silver badges21 bronze badges

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

Comments

Malcolm O'Hare · Accepted Answer · 2012-12-10 16:40:53Z

0

In my software I just have 2 connection strings of the same name in my app.config and comment/uncomment to switch between configurations.

Another method is that you could create a static property in your solution (.asax file?) and just use that to swap between XYZDatabase-TEST and XYZDatabase when you are fetching ConnectionStrings.

answered Dec 10, 2012 at 16:40

Malcolm O'Hare

5,0393 gold badges36 silver badges56 bronze badges

Comments

Dawid Dziadkiewicz · Accepted Answer · 2012-12-11 07:49:24Z

Add connection string to your Web.config like:

<connectionStrings>
    <add name="XYZDatabase-TEST" connectionString="Server=.\SQLEXPRESS;Database=XYZDatabase-TEST";integrated security=SSPI;" providerName="System.Data.SqlClient" />
</connectionStrings>

Then open you Web.Release.config and add

<connectionStrings>
    <add name="XYZDatabase-TEST"
        connectionString="Data Source=OTHERSERVER;Initial Catalog=XYZDatabase-TEST;Persist Security Info=True;User ID=sa;Password=password" providerName="System.Data.SqlClient"
        xdt:Transform="SetAttributes"
        xdt:Locator="Match(name)"/>
</connectionStrings>

Now, everytime you will publish you application to deployment server using Release configuration it will use the connection string from web.release.config

Note that this transformation will not work locally when you debug. You must publish to run the web.config transformation.

Collectives™ on Stack Overflow

Connection Strings - MVC Entity Framework - Database First

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related