Can’t use a MySQL connection for entity framework 6

by

LATEST EDIT

The bug has been fixed.

Chris’ comment:

2015-11-07 and you can now get it all working without editing any
files or doing weird stuff. Use the MySQL for Windows installer and
include the Visual Studio support and the latest Connector.Net. Be
sure to update after installing and you will get the latest of each
(1.2.5 and 6.9.8). Use NuGet to install EntityFramework, MySql.Data,
and MySql.Data.Entity. Finally, built and enjoy code-first reverse
engineering goodness by adding an Ado.Net Entity Model.

Original answer

I found out it’s a bug from MySQL.

Here’s the link explaining a workarround.

On your machine where VS 2013 is installed, VS plugin (1.1.3 GA) and
Connector/Net

Close all VS instances before doing the steps.

On a Windows Explorer window go to this path or wherever you installed
you Connector/net binaries

C:\Program Files (x86)\MySQL\MySQL Connector Net
6.8.3\Assemblies\v4.5\

Copy the file:

MySql.Data.Entity.EF6.dll

And paste it to this folder

C:\Program Files (x86)\Microsoft Visual Studio
12.0\Common7\IDE\PrivateAssemblies

If it asks you to overwrite it please do so.

You’ll need admin rights in order to overwrite the file.

Then you can try again to generate the script for your model.

It is important that you have the 1.1.3 version of the VS plugin
installed since this workaround is for that.

Unfortunately it doesn’t work for me, so I downgraded to entity framework 5 until they fix this.

EDIT

Finaly, it works now.

I had to add the 3 following DLLs :

  • C:\Program Files (x86)\MySQL\MySQL Connector Net
    6.8.3\Assemblies\v4.5\MySql.Data.dll
  • C:\Program Files (x86)\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.5\MySql.Data.Entity.EF6.dll
  • C:\Program Files (x86)\MySQL\MySQL Connector Net
    6.8.3\Assemblies\v4.5\MySql.Web.dll

Then I changed the EntityFramework part in the web config to :

<entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6">
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" /> 
    </providers>
  </entityFramework>

Don’t forget to REBUILD and you should be able to create a entity framework 6 model with MySQL.

IMPORTANT

Make sure you have installed MySQL for visual studio 1.1.3 and MySQL connector .net 6.8.3

More Related Contents:

  1. Can’t Create Entity Data Model – using MySql and EF6
  2. Entity Framework wizard crashes on MySQL
  3. Using MySQL with Entity Framework [closed]
  4. mySQL DataSource on Visual Studio 2012
  5. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  6. How to use unsigned int / long types with Entity Framework?
  7. How to get a ranking result for special record in mysql [closed]
  8. SQL Query needed for fetch value from Two identical table but not fully identical table
  9. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  10. How to reset AUTO_INCREMENT in MySQL
  11. MySQL Query GROUP BY day / month / year
  12. What is MySQL row order for “SELECT * FROM table_name;”?
  13. MySQL Like multiple values
  14. Error: select command denied to user ”@” for table ”
  15. MySQL : Multiple row as comma separated single row
  16. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  17. MySQL Trigger: Delete From Table AFTER DELETE
  18. Return a default value if single row is not found
  19. How to find out the MySQL root password
  20. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  21. SQL search multiple values in same field
  22. Removing duplicates with unique index
  23. MySQL – Select the last inserted row easiest way
  24. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  25. ALTER table – adding AUTOINCREMENT in MySQL
  26. How to restrict a column value in SQLite / MySQL
  27. Does MySQL foreign_key_checks affect the entire database?
  28. Array data type, split string,
  29. Trouble with GROUP_CONCAT and Longtext in MySQL
  30. How can I make a table in MySQL called “order”?

Leave a Comment