Bug #90114 suddenly Entity Data Model wizard window crashes with Mysql DB
Submitted: 16 Mar 2018 16:33 Modified: 20 Mar 2018 5:45
Reporter: amit p Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.7.21.0 OS:Windows
Assigned to: CPU Architecture:Any

[16 Mar 2018 16:33] amit p
Description:
Hi,

I am using Mysql Community-5.7.21.0 database and Visual Studio 2017.
MySQL database is successfully Installed. also, I have created database & some table.

My Problem is when I am trying to the establish the connection with Entity Data Model wizard, after establishing the database configuration in Entity Data Model wizard click Next button, then suddenly Entity Data Model wizard window crashes.

please help me to solve this problem.

How to repeat:
establishing the database configuration in Entity Data Model wizard click Next button, then suddenly Entity Data Model wizard window crashes.
[19 Mar 2018 12:38] amit p
Hi Chiranjeevi,

I am not founding/understanding any solution from that page(Bug #85908).

I am using a licensed version of visual studio professional 2017.
MySQL DB(5.7.21) also working fine, but I am unable to connect my database using Entity Framework. After choosing my database name when I click on Next button then Entity Data Model wizard window is crashing.

Thanks,
Amit
[19 Mar 2018 12:53] Chiranjeevi Battula
Hello amit,

Thank you for the bug report.
This is most likely duplicate of Bug #89338, please see Bug #89338

Thanks,
Chiranjeevi.
[19 Mar 2018 13:49] amit p
please see the screen shot attached- After established the connection,Next button appears , once i click it, its disappear/crash

Attachment: mysql.png (image/png, text), 120.88 KiB.

[20 Mar 2018 5:45] amit p
I Found the solution for the above issue.
1. Goto this path \Common7\IDE\PrivateAssemblies\ 
2. Search the .dll file name start with MySQL.Data.Entity.EF6, --> Check the file details using right click -->
	Properties --> Details tab. Check the file version: Example:(6.10.6.0 or 6.9.8.0 etc).
3. Goto https://dev.mysql.com/downloads/connector/net/    
   and download the same version whatever you got in the file version. and Install the same.
4. Goto your Visual Studio project and click on view --> Other Windows --> Package Manager Console
   and Install from there: pm> Install-Package MySql.Data.Entity -Version (Whatever you got the file version like 6.10.6, 6.9.8 etc).
5. Restart the visual studio. This problem will be solved.
[23 Aug 2018 11:09] Wasim Qadir
I am facing the exact same issue as described in the bug. I tried solutions suggested in Bug 89338 but those did not help me. I followed the solution suggested by Amit P, and that worked for me but for that I had to uninstall latest version of .Net connector and revert back to 6.10.7 version of the connector which I don't prefer. Any proper fix for this?
[22 Jan 2020 12:33] Francesco Valentino
I have the same problem with Visual Studio 2019

I have installed:
Mysql for Visual Studio 1.2.9
Mysql Connector/NET 8.0.19

I have created my solution and i have installed nuget
EntityFramework 6.4.0
Mysql.Data 8.0.19
Mysql.Data.Entity 6.10.9

I chacked in the folder 
\Microsoft Visual Studio\2019\Community\Common7\IDE\PrivateAssemblies
version of files

MySql.Data.dll
MySql.Data.Entity.EF6.dll
MySql.Data.EntityFramework.dll

and all file are the same version

After i have selected provider and database in next page after select in automatic mode EntityFramework 6.0 wizard closed without message.

How i can solve?
I have tried all solutions posted in this forum but i not have solved the problem

Cai you help me? Please.

Thank you so much in advance
[22 Jan 2020 12:44] Francesco Valentino
I have solved problem

Instead of installing the Nuget Mysql.Data.Entity version 6.10.9 package 
I installed the Nuget Mysql.Data.EntityFramework version 8.0.19 package

in this way i solved problem.

Thank you so muche to all