title: The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file
body: <p>I have an asp.net solution using entity framework 6 to mysql server.  </p>
  
  <p>now I have to work on that solution on a new machine,<br>
  but I have some problems:<br>
  1) when building the solution I get error: <strong>"The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file".</strong> </p>
  
  <p><a href="https://i.stack.imgur.com/TFOM4.png" rel="noreferrer"><img src="https://i.stack.imgur.com/TFOM4.png" alt="error screenshot"></a>  </p>
  
  <p>App.config:  </p>
  
  <pre><code>&lt;entityFramework&gt;
    &lt;providers&gt;
      &lt;provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"&gt;&lt;/provider&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.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" /&gt;
    &lt;/DbProviderFactories&gt;
  &lt;/system.data&gt;  
  </code></pre>
  
  <p>2) when opening model.edmx file I get message:<br>
    <strong>"the entity mode designer is unable to display the file you requested".</strong>  </p>
  
  <p><a href="https://i.stack.imgur.com/HMsKo.png" rel="noreferrer"><img src="https://i.stack.imgur.com/HMsKo.png" alt="error screenshot"></a></p>
  
  <p>I have installed on the machine:  </p>
  
  <p>1) mysql connector/net 6.9.9<br>
  2) mysql for visual studio 1.2.6<br>
  3) mysql connector odbc 5.3.6.</p>
  
  <p>what can I do?</p>