MySQL Bugs: #91195: MySQL connector/net - Entity Data Model Wizard crashes no models are generated

Bug #91195	MySQL connector/net - Entity Data Model Wizard crashes no models are generated
Submitted:	9 Jun 2018 0:49	Modified:	15 Jul 2018 6:43
Reporter:	Chris Stevens	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Visual Studio Integration	Severity:	S1 (Critical)
Version:	6.10.7, 8.0.11	OS:	Windows (Windows 10 latest)
Assigned to:	Assigned Account	CPU Architecture:	Any (i7 4790K)
Tags:	Connector/Net, crashes, database, Entity Data Model Wizard, MySQL, no models are generated, Visual Studio 2017

Description:
Duplicate of 91165 because I was told to set it to Open if I had more info but I cant re open the ticket. I only get "Can't repeat" or "Closed" in Edit submission.

Previous ticket info:

MySQL connector/net - Entity Data Model Wizard crashes no models are generated

The issue is with both the Nuget install and MySQL connector/net installer from the website.

The only difference between the Nuget install and MySQL website installer is that the Nuget install crashes immediately when click Next after the select database page.

Whereas the website installer gives a window displaying an issue with Entity Framework 6 being unselectable and only Entity Framework 5 being selectable, but clicking next after this still crashes the window.

Have tried modifying the App.config to no avail.

I found several old posts online with similar issues, but nothing fixed my issue.
https://www.google.co.uk/search?q=mysql+entity+model+data+wizard+crashes

https://stackoverflow.com/questions/43134807/entity-data-model-wizard-closes-after-selecti...

https://github.com/npgsql/npgsql/issues/1445

How to repeat:
1. Install latest MySql.Data.Entity v6.10.7 from Nuget in Visual Studio 2017.
(Also tried latest connector/net DLL's from MySql installer with similar results)
2. Reboot VS.
3. Open VS.
4. Clean and Rebuild solution.
5. RClick folder > New Item... > ADO.NET Entity Data Model > Add.
6. EF Designer from data...
7. select database, yes include, save connection to App.Config as foobar.
8. Next >
Window crashes here and no models are generated.

I am going to upload my project to the sftp for you to test.

Please see the mysql-bug-data-91195.zip file in the sftp /support/incoming/ folder. It contains my project with the issue.

http://bugs.mysql.com/bug.php?id=91201 marked as duplicate of this one.

Hello Chris Stevens,

Thank you for the bug report.
I could not repeat the issue at our end using with Visual Studio 2017 and Connector/NET 6.10.7 version.
It seems you did not install Connector/NET 6.10.7 as per your point 1. Please install Connector/NET 6.10.7 in your system.

https://dev.mysql.com/downloads/connector/net/6.9.html

Thanks,
Chiranjeevi.

Screenshot

Attachment: Bug_91195.PNG (image/png, text), 82.75 KiB.

Screenshot

Attachment: Bug_91195_1.PNG (image/png, text), 73.33 KiB.

I can confirm that. I have the same Issue.

Also I think this is interesting: https://forums.mysql.com/read.php?174,667307,667319#msg-667319

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

My problem was caused by using the mysql installer version 1.4.
Downloaded MysqlConnector/Net msi, uninstalled versio from the mentioned installer and used this msi and all worked.

Carlos's solution works. Spent hours trying to get this to work. 
Don't use installer 1.4 to install the .net connector. download connector 6.10.7 direct from the website and install. Using MySQL for VS 1.2.8 (via installer 1.4).

I tried Carlos's solution but no luck.

My environment is VS2017 17.7.1 Enterprise, windows10 64, MySQL Installer 1.4.26.

The Connector/Net installed by MySQL Installer was 8.0.12, I have tried to uninstall Connector/Net using MySQL Installer as well as tried by the Connector/Net standalone, reinstall the 8.0.12 Connector/Net using its standalone installer, no helps.

Then I tried to lower versions includes 6.10.8 and 6.9.12 Connector/Net installer from https://dev.mysql.com/downloads/connector/net/, set my nuget package versions down to the same versions, still crashes. 

Please take a look, this blocks us normal development cycles.

Nir Amber's sulution works.

install connector 6.10.8 direct and Using MySQL for VS 1.2.8