title: No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider
body: <p>I'm trying to use Entity Framework with MySQL and I get the above error. I have the latest MySQL connector installed.</p>
  
  <p>The full error reads:</p>
  
  <pre><code>No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider. Make sure the provider is registered in the 'entityFramework' section of the application config file.
  </code></pre>
  
  <p>However, I can't find anything that suggests just how you register it in the 'entityFramework' section.</p>
  
  <p>Some other posts (<a href="https://stackoverflow.com/questions/14355659/entityframework-6-alpha-2-mysql-connector-net-6-6-4">example</a>) suggest adding the provider to the <code>system.Data</code> <code>DbProviderFactories</code> section like this:</p>
  
  <pre><code>&lt;DbProviderFactories&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.2.3.0, Culture=neutral, 
      PublicKeyToken=c5687fc88969c44d" /&gt;
  &lt;/DbProviderFactories&gt;
  </code></pre>
  
  <p>But that doesn't work because it claims that the <code>invariant</code> name is duplicated. And, if I actually iterate through the <code>System.Data.Common.DbProviderFactories</code> I can see the last one is the MySQL provider:</p>
  
  <pre><code>MySQL Data Provider
  .Net Framework Data Provider for MySQL
  MySql.Data.MySqlClient
  MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.6.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d
  </code></pre>
  
  <p>So the provider is there, but EF refuses to use it. Any ideas?</p>
  
  <p>My full config looks like this:</p>
  
  <pre><code>&lt;configuration&gt;
      &lt;configSections&gt;
      &lt;!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --&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;system.data&gt;
     &lt;!--&lt;DbProviderFactories&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.2.3.0, Culture=neutral, 
      PublicKeyToken=c5687fc88969c44d" /&gt;
     &lt;/DbProviderFactories&gt;--&gt;
  &lt;/system.data&gt;
  
  &lt;connectionStrings&gt;
      &lt;add name="myContext" connectionString="server=****;User Id=****;password=****;Persist Security Info=True;database=myDb"
    providerName="MySql.Data.MySqlClient" /&gt;
  &lt;/connectionStrings&gt;
  &lt;startup&gt;
      &lt;supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /&gt;
  &lt;/startup&gt;
  
  &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;/entityFramework&gt;
  
  &lt;/configuration&gt;
  </code></pre>