Entity Framework's Entity Data Wizard Crashes When Connecting to MySQL Database

c# entity-framework-6 mysql visual-studio-2015

Question

I'm trying to reverse engineer an existing MySQL database by utilising the wizard to generate an Entity Data Model. The wizard fails when I choose an existing MySQL connection on the Choose Your Data Connection page of the wizard and click Next. Particularly, the dialogue window just vanishes without a trace or an error notice. Each and every time. Nothing happens when you restart Windows or VS.

I'm rather convinced it isn't a connection issue since I can successfully connect to the database using Server Explorer with the same connection.

This is using a fully updated version of Visual Studio 2015, MySQL for Visual Studio version 1.2.6, EF 6.1.3, and the MySql.Data and MySql.Data.Entity libraries. versions 6.8.3.0 of EF6. The.NET Framework 4.6.1 is the objective of the Console application.

Nothing helpful has yet been disclosed by Google. Similar to the previous here's the query, but failing at a different point, the user is unable to connect using Server Explorer. Thus, it seems to be a separate circumstance.

The Windows logs include no useful information.

How can I fix this issue?

1
24
5/23/2017 11:47:00 AM

Accepted Answer

It results from a version mismatch.

I have MySQL Connector 6.9.6 installed on my PC. Using the NuGet Package Manager Console to run the command:

Install-Package MySql.Data. Version 6.9.8 is installed by default by entity. The NuGet Package's real version must be compatible with your connection. You can download an updated version of the connector from: https://www.mysql.com/products/connector/

Choose "Ado.net driver for MySQL" here, then download the relevant version (in this case 6.9.8). When Visual Studio is reopened, the wizard no longer crashes. No need to restart.

37
8/25/2016 8:05:11 PM

Popular Answer

ZZZ_tmp


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow