title: Select build configuration DbContext migration
body: <p>I can update the database in my web config:</p>
  <pre class="lang-none prettyprint-override"><code>Update-Database -Verbose 
  </code></pre>
  <p>When the database is deployed, I have a different connection string defined in the web.config.debug transform file.</p>
  <p>How can I use the correct connection string for the build configuration?</p>
  <p>For example:</p>
  <p><code>Web.config</code>:</p>
  <pre class="lang-xml prettyprint-override"><code>&lt;configuration&gt;
      &lt;connectionStrings&gt;
          &lt;add name=&quot;MyConnection&quot; 
               connectionString=&quot;My_Local_Connection_String&quot;/&gt;
      &lt;/connectionStrings&gt;
  &lt;/configuration&gt;
  </code></pre>
  <p><code>Web.config.Debug</code>:</p>
  <pre class="lang-xml prettyprint-override"><code>&lt;configuration&gt;
      &lt;connectionStrings&gt;
          &lt;add name=&quot;MyConnection&quot; 
               connectionString=&quot;My_Debug_Connection_String&quot; 
               xdt:Transform=&quot;SetAttributes&quot; 
               xdt:Locator=&quot;Match(name)&quot;/&gt;
      &lt;/connectionStrings&gt;
  &lt;/configuration&gt;
  </code></pre>
  <p><code>Web.config.Release</code>:</p>
  <pre class="lang-xml prettyprint-override"><code>&lt;configuration&gt;
      &lt;connectionStrings&gt;
          &lt;add name=&quot;MyConnection&quot; 
               connectionString=&quot;My_Release_Connection_String&quot; 
               xdt:Transform=&quot;SetAttributes&quot;
               xdt:Locator=&quot;Match(name)&quot;/&gt;
      &lt;/connectionStrings&gt;
  &lt;/configuration&gt;
  </code></pre>
  <p>Once I've proved that the migration locally is fine, I need to make the same migration on the connection string the <code>Web.config.Debug</code> and, assuming that works then the release version.</p>
  <p>How to I tell EF which configuration transform to use?</p>