How do I use Web.Config transform on my connection strings?

Question

In my current project, I have some connection strings that are valid for local development machines:

<configuration>
  <connectionStrings>
    <add name="ApplicationServices"
         connectionString="Data Source=localhost;Initial Catalog=MyDB;Integrated Security=SSPI"
  </connectionStrings>
....
</configuration>

How would I use the Web.Config transforms to convert from this expression to one valid for our production server? The production server one would look something like:

<configuration>
  <connectionStrings>
    <add name="ApplicationServices"
         connectionString="Data Source=IPAddress,Port;Initial Catalog=SomeOtherDB;User ID=TopSecretUsername;Password=SecurePassword"
  </connectionStrings>
....
</configuration>

The syntax isn't obvious to me, and I'm completely failing at grokking the page on it.

Bala R · Accepted Answer · 2013-01-31 21:34:58Z

68

This works for me but I too have found it to be a bit flakey at times. You will need to create another file called Web.Config.Release and fill it with the following:

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

  <connectionStrings>
    <add name="local" connectionString="Data Source=IPAddress,Port;Initial Catalog=SomeOtherDB;User ID=TopSecretUsername;Password=SecurePassword" 
    xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
  </connectionStrings>

  <system.web>
    <compilation xdt:Transform="RemoveAttributes(debug)" />

  </system.web>
    <appSettings>
        <add key="default_db_connection" value="local" xdt:Transform="SetAttributes" xdt:Locator="Match(key)" />
    </appSettings>
</configuration>

edited Jan 31, 2013 at 21:34

Bala R

109k23 gold badges203 silver badges212 bronze badges

answered Dec 3, 2011 at 6:51

sbeskur

2,30025 silver badges24 bronze badges

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

3 Comments

sbeskur Over a year ago

The appSettings part is optional depending on how you set up your connection.

Mike Bailey Over a year ago

What exactly does that appSettings part do? Also, is it safe to assume that I can encrypt my transformed connectionStrings using aspnet_regiis -pef?

sbeskur Over a year ago

I use the appSettings in case I have multiple connection strings Local Db vs one hosted on a different machine. It's purely convenience driven so that I could use the appsetting to decide which db use. ( I really should just have left it out of this example)

JasonH · Accepted Answer · 2014-06-10 15:23:00Z

7

You shouldn't need to create a new file, it should be in the Solution Explorer, expand Web.config, and open Web.Release.config.

Scott Allan has a good video on it here (under Configuration and Deployment > Config Transformations).

edited Jun 10, 2014 at 15:23

JasonH

1,2412 gold badges19 silver badges19 bronze badges

answered Dec 3, 2011 at 6:56

Garrett Fogerlie

4,4583 gold badges41 silver badges56 bronze badges

3 Comments

immutabl Over a year ago

Any chance you could re-link to the video? Looks like pluralsight have changed their catalogue structure since 2011 :-(

Tomas Beblar Over a year ago

Link is to a pay wall.

Garrett Fogerlie Over a year ago

Damn, that link used to go to a free video. Sorry

Collectives™ on Stack Overflow

How do I use Web.Config transform on my connection strings?

2 Answers 2

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related