title: How to set SetSqlGenerator and CodeGenerator in MySql Connector 6.9.6?
body: <p>I updated my MySql connector/net to 6.9.6 (from 6.9.5) and EF to 6.1.3 (from 6.1.2) which broke migrations :(</p>
  
  <p>I used to have this, which would make migrations work on MySql. </p>
  
  <pre><code>public Configuration()
  {
      // fails with cannot assign MySqlMigrationSqlGenerator toSystem.Data.Entity.Migrations.Sql.MigrationSqlGenerator
      SetSqlGenerator("MySql.Data.MySqlClient", new MySql.Data.Entity.MySqlMigrationSqlGenerator());
  
      // fails with cannot assign MySqlMigrationCodeGenerator to System.Data.Entity.Migrations.Design.MigrationCodeGenerator
      CodeGenerator = new MySql.Data.Entity.MySqlMigrationCodeGenerator();
  }
  </code></pre>
  
  <p>But now that doesn't work. And when I remove it the generated migrations are prefixed with <code>dbo</code> which doesn't work.</p>
  
  <p>I tried setting the <em>new</em> config in the web.config</p>
  
  <pre><code>&lt;entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6"&gt;
  </code></pre>
  
  <p>also tried setting the <em>new</em> attribute on the context.</p>
  
  <pre><code>[DbConfigurationType(typeof(MySqlEFConfiguration))]
  public class MyContext : DbContext
  </code></pre>
  
  <p>But to no avail.</p>
  
  <p>How do I make migrations work again with this new connector?</p>