title: How do I use Web.Config transform on my connection strings?
body: <p>In my current project, I have some connection strings that are valid for local development machines:</p>
  
  <pre><code>&lt;configuration&gt;
    &lt;connectionStrings&gt;
      &lt;add name="ApplicationServices"
           connectionString="Data Source=localhost;Initial Catalog=MyDB;Integrated Security=SSPI"
    &lt;/connectionStrings&gt;
  ....
  &lt;/configuration&gt;
  </code></pre>
  
  <p>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:</p>
  
  <pre><code>&lt;configuration&gt;
    &lt;connectionStrings&gt;
      &lt;add name="ApplicationServices"
           connectionString="Data Source=IPAddress,Port;Initial Catalog=SomeOtherDB;User ID=TopSecretUsername;Password=SecurePassword"
    &lt;/connectionStrings&gt;
  ....
  &lt;/configuration&gt;
  </code></pre>
  
  <p>The syntax isn't obvious to me, and I'm completely failing at grokking the <a href="http://msdn.microsoft.com/en-us/library/dd465326%28VS.100%29.aspx" rel="noreferrer">page</a> on it.</p>