MySQL Data Provider Not Showing in Entity Data Model Wizard

Question

I am creating an MVC application with MySQL as backend. I am planning to use Entity Framework to work with this database. I already have a database so need to generate models from a database

Environment:

MySQL Server 5.7.21 MySQL for Visual Studio 1.27 Connector/NET 6.10.5 Visual Studio 2015

To Reproduce Issue:

Step 1: Add new item 'Ado.net Entity Data Model' Step 2: Selected 'EF Designer from database' and click 'Next' Step 3: Clicked 'New Connection'

There is no mysql connector available.

Other Details:

1. I already added "System. Runtime" deal as it shows error when installing Mysql. data. Ef6 from nugget
2. I changed "CopyLocal= true" in 'System. Data' assembly reference
3. I tried the same steps in Visual Studio 2017. Here I can see the provider in the step 3 but after click ok dialogue closed instead of showing table list

In Visual Studio 2015 and 17 initial time it shows the provider. when I tried next time it's not displaying Please help. I am checking this for 2 days

Answer 1

To start working with VS 2013 and EF 6

1. Install the MySQL for Visual Studio 1.1.1
2. Install the Connector/Net 6.8.1 product.
3. To work with Database first please do the following
   • Add the reference for the new assembly called MySql.Data.Entity.EF6 and copy it to the bin forlder of your application.
   • Add the provider to your app/web config file on the providers for Entity Framework section with the following line:
   • Before you run the Wizard compile your application so the new changes are applied.
4. To work with Model First please do the following
   • Add the reference for the new assembly called MySql.Data.Entity.EF6 and copy it to the bin forlder of your application.
   • Add the ADO.Net Entity Model new or existing.
   • Select the T4 template corresponding to MySQL (SSDLToMySQL)
   • Right click on the model and then select Generate Script to Create Database. (A MySQL script should be generated for you to create your database).

Hope this helps a bit.

MySQL for Visual Studio 1.1.1

MySQL Connector/Net 6.8.1 Beta