Can’t Create Entity Data Model – using MySql and EF6

by

I just had the same situation when trying to configure Visual Studio Professional 2017 environment with MySQL, ADO.NET (Database First) and EF6.

Note: Please follow steps in the same order.

  1. Uninstall/remove “Connector/NET” and “MySQL for Visual Studio” if installed.

  2. Install “MySQL for Visual Studio” v2.0.5 CTP (MySQL for Visual Studio).
    Note: Install MySQL for Visual Studio before Connector/NET.

  3. Install “Connector/NET” v6.9.10 (Connector/Net).
    https://i.stack.imgur.com/XOT1I.jpg Note: I tried using Connector/NET v6.8, v6.10 and v8 first, but none of them worked with Visual Studio 2017 and ADO.Net. Here you can find all Connector Versions and Compatibilities with Visual Studio IDEs, but so far this list is inaccurate.

  4. Create new Visual Studio Professional 2017 project.

  5. Download and Install “EntityFramework” v6.2.0 through NuGet, by going to Project Tab/Manage NuGet Packages/Browse -> Entity Framework.

  6. Add references to C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.dll
    and
    C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.Entity.EF6.dll; by Right Clicking over References inside Solution Explorer and selecting Add Reference/Browse ->Browse button.

  7. Add MySQL EF6 provider info inside App.config under entity framework providers as follow:

<entityFramework>
       <providers>
         <provider invariantName="MySql.Data.MySqlClient"
              type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
       </providers>
</entityFramework>
  1. Rebuild project by going to Build tab/Rebuild ProjectName.

And that’s it. VS2017 is ready to go. Hope this works for everybody, as it did for me today.

References:

  1. Can’t Create Entity Data Model – using MySql and EF6

  2. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider

More Related Contents:

  1. Entity Framework wizard crashes on MySQL
  2. Can’t use a MySQL connection for entity framework 6
  3. Using MySQL with Entity Framework [closed]
  4. How to connect to a MySQL Data Source in Visual Studio
  5. mySQL DataSource on Visual Studio 2012
  6. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  7. How do I setup ASP.NET MVC 2 with MySQL?
  8. How to use unsigned int / long types with Entity Framework?
  9. Metadata file not found – Data.Entity.Model
  10. How do I set the time zone of MySQL?
  11. How to set initial value and auto increment in MySQL?
  12. When should I use a composite index?
  13. Mysql: Select rows from a table that are not in another
  14. setting global sql_mode in mysql
  15. Writing optional parameters within stored procedures in MySQL? [duplicate]
  16. How to get all columns’ names for all the tables in MySQL?
  17. How do I get MySQL to use an INDEX for view query?
  18. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  19. Restore the mysql database from .frm files
  20. Mysql insert random datetime in a given datetime range
  21. Greatest value of multiple columns with column name?
  22. insert data from one table to another in mysql
  23. MySQL UPDATE syntax with multiple tables using WHERE clause
  24. How does MySQL Auto Increment work?
  25. MySQL load data infile – acceleration?
  26. mysql – Dynamic column alias
  27. MySQL Fulltext Search Score Explained
  28. MySQL Alter table causes Error: Invalid use of NULL value
  29. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  30. Inventory management with stock options

Leave a Comment