title: Entity Framework wizard crashes on MySQL
body: <p>My question is similar to <a href="https://stackoverflow.com/questions/25875915/entity-data-model-wizard-crashes-on-specify-connection-string-dialog">this one</a> but the crash happens later. I <strong>must</strong> interoperate an EF database-first model between SQL Server and MySQL. More specifically, my application had plain SQL queries fired to either SQL Server or MySQL according to connection string and configuration setting (<code>DB_TYPE=MYSQL</code>, etc.), having both databases with same structure and maintained together, so that each modification to one's schema was reapplied to the other.</p>
  
  <p>Now I added EF support to the application using SQL Server database-first model. I <strong>must</strong> now let the application run on MySQL too. In order to verify that the old developer didn't leave something disaligned between the two DBMSes, I tried to <code>Update model against database</code>* and this time I selected the MySQL connection to my development database on localhost.</p>
  
  <p>After I click <code>Next</code> on the screen below, it will simply crash and return to EDMX editor</p>
  
  <p><img src="https://i.stack.imgur.com/9tarH.png" alt="Data Model wizard"></p>
  
  <p>I need to go ahead with the project, I'm stuck on this since a while.</p>
  
  <p>Here is my Web.config fragment:</p>
  
  <pre><code>&lt;entityFramework&gt;
      &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"&gt;
        &lt;parameters&gt;
          &lt;parameter value="v11.0" /&gt;
        &lt;/parameters&gt;
      &lt;/defaultConnectionFactory&gt;
      &lt;providers&gt;
        &lt;provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt;
        &lt;provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /&gt;
      &lt;/providers&gt;
    &lt;/entityFramework&gt;
    &lt;system.data&gt;
      &lt;DbProviderFactories&gt;
        &lt;remove invariant="MySql.Data.MySqlClient" /&gt;
        &lt;add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt;
      &lt;/DbProviderFactories&gt;
    &lt;/system.data&gt;
  </code></pre>
  
  <p>How can I solve my problem? I reinstalled MySQL tools for Visual Studio but didn't help.</p>
  
  <p>*I use a localized version of Visual Studio, so I don't know the original English for all commands</p>