title: How to use two connection strings on development vs production
body: <p>I have two connection strings in my Web.config.</p>
  
  <pre><code>  &lt;connectionStrings&gt;
      &lt;add name="AuthContext" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=mokey;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
      &lt;add name="AuthContextMySQL" providerName="MySql.Data.MySqlClient" connectionString="database=mokey;persistsecurityinfo=True" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I can specify which one to use in code like this:</p>
  
  <pre><code>public class AuthContext : IdentityDbContext&lt;IdentityUser&gt;
  {
      public AuthContext()
          : base("AuthContextMySQL")
      {
      }
  }
  </code></pre>
  
  <p>How do I specify which one to use depending on development vs production?</p>