title: 'Option not supported' error when using SQL Server with MySQL
body: <p>I'm trying to retrieve data from both MySQL and SQL Server on the same console application. I manage to retrieve data from MySQL, however when I trying to retrieve data from SQL Server, I got <code>System.ArgumentException: 'Option not supported. Parameter name: multipleactiveresultsets'</code> error. </p>
  
  <p>The following is my <code>app.config</code>:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;configuration&gt;
    &lt;configSections&gt;
      &lt;section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt;
    &lt;/configSections&gt;
    &lt;startup&gt;
      &lt;supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" /&gt;
    &lt;/startup&gt;
  
    &lt;connectionStrings&gt;
      &lt;add name="MySQLDb" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=sakila;uid=some_user;password=some_password"/&gt;
      &lt;add name="SQLDb" providerName="System.Data.SqlClient" connectionString="data source=USER-PC\SQLEXPRESS;initial catalog=MyDatabase;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"/&gt;
    &lt;/connectionStrings&gt;
  
    &lt;entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6"&gt;
      &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/&gt;
      &lt;providers&gt;
        &lt;provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"/&gt;
        &lt;provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/&gt;
      &lt;/providers&gt;
    &lt;/entityFramework&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>And my C#:</p>
  
  <pre class="lang-cs prettyprint-override"><code>#region MySQL.
  {
      var dbContext = new MySQLDb();
      var dbSet = dbContext.Set&lt;Actor&gt;();
  
      var actors = dbSet.ToList();
  }
  #endregion
  
  #region SQLServer.
  {
      var dbContext = new SQLDb();
      var dbSet = dbContext.Set&lt;User&gt;();
  
      var users = dbSet.ToList(); // &lt;-- Throw exception.
  }
  #endregion
  </code></pre>
  
  <p>If I disable <code>entityFramework</code> section in <code>app.config</code> and MySQL code block in my C# code, I can retrieve data from SQL Server without any issue.</p>
  
  <p>Version info</p>
  
  <ul>
  <li>MySQL.Data.Entity 6.10.8</li>
  <li>NET Framework 4.6.1</li>
  </ul>
  
  <p>Any idea?</p>
  
  <hr>
  
  <p><strong>Update 1</strong></p>
  
  <p>Found out that the connection type for <code>MySQLDb</code> is <code>MySql.Data.MySqlClient.MySqlConnection</code>, so that works just fine. But when instantiating <code>SQLDb</code>, the connection type is still <code>MySql.Data.MySqlClient.MySqlConnection</code> instead of <code>System.Data.SqlClient.SqlConnection</code>. How should we fix this?</p>