Missing MySQL Provider

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
guinness
Posts: 25
Joined: Tue 22 Nov 2016 03:19

Missing MySQL Provider

Post by guinness » Tue 22 Nov 2016 04:15

I downloaded Entity Developer 6.0 Express to evaluate. When I create an Entity Model, I have the following options for providers:

.NET Framework Data Provider for Microsoft SQL Server Compact 4.0
.Net Framework Data Provider for MySQL
.Net Framework Data Provider for SqlServer

When I try to create an EF Core Model, I only have the following options for providers:

.NET Framework Data Provider for Microsoft SQL Server Compact 4.0
.Net Framework Data Provider for SqlServer

I had installed MySQL Connector/NET 7.0.6, what is needed to show the MySQL provider for EF Core?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Missing MySQL Provider

Post by Shalex » Tue 22 Nov 2016 19:12

Thank you for your report. We will fix the issue with MySQL Connector/NET and notify you.

As a workaround, please use dotConnect for MySQL Professional (Trial).

SharpDog
Posts: 1
Joined: Thu 05 Feb 2015 18:19

Re: Missing MySQL Provider

Post by SharpDog » Fri 02 Dec 2016 15:34

I'm having the same issue. I've been using the registered version of ED for about 2 years with no problems and recently attempted to upgrade the MySql connector. Now I do not have the option for the MySql provider.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Missing MySQL Provider

Post by Shalex » Fri 02 Dec 2016 18:59

MySQL EF Core provider in Connector/Net was implemented recently, and it is pre-release: https://docs.microsoft.com/en-us/ef/cor ... ers/mysql/. That's why it is missing in a current version of Entity Developer. Anyway, we have supported it. Look forward to the next public build of Entity Developer.

guinness
Posts: 25
Joined: Tue 22 Nov 2016 03:19

Re: Missing MySQL Provider

Post by guinness » Sat 10 Dec 2016 01:57

@Shalex - thank you! I downloaded Entity Developer version 6.0.147 and Connector/Net data provider now works.

@SharpDog - it works for me. Maybe download Connector/Net version 7.0.6 and try again, or use the repair option.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Missing MySQL Provider

Post by Shalex » Thu 15 Dec 2016 14:57

MySql.Data 7.0.6 is a .Net Core provider. Entity Developer works only with .NET Framework providers. Please use MySql.Data 6.9.9 for creating the EF Core model and generating the code.

Post Reply