Problem to connect Visual Studio project to MySQL database

0

My problem is as follows, and I can not find a solution.

I have a MySQL database, which I want to manage from my application.

I have a project in C # with Visual Studio, in which I am using the MVVM architecture, and I am trying to use the Entity Framework utility to connect to the database, read its structure and automatically generate the class layer which represents the model.

For this, I have created a directory in my project, and I have added a new element of type "ADO.NET Entity Data Model". I choose the first option, which is "EF Designer from database". Then I open the window that allows me to choose the connection and the configuration with the database. And this is where I find the problem.

Among the available options, only those from Microsoft SQL Server appear, and the connector does not appear in MySQL.

I have installed the "MySQL Tools for Visual Studio" and the "Connector / NET", I can manage the database from Visual Studio using the server browser, and I can also compile and perfectly run any application that already has the layer of the generated model. But I can not personally generate this layer. In the wizard that is supposed to generate the model, I do not have the option to configure a MySQL database.

The most frustrating thing about all this, is that I have commented on this problem with some colleagues, and when I reply the same steps from their editors, in the list of connections, MySQL appears. But not mine.

Would anyone know what I'm doing wrong?

Thank you very much!

PS: I attach the window in which I'm supposed to choose the MySQL connection, which does not appear.

    
asked by Alberto Torre 12.01.2018 в 17:22
source

1 answer

2

Try installing the following versions:

mysql-connector-net-6.9.10

mysql-for-visualstudio-1.2.7

The same thing happened to me, I had a higher version of the connector installed, I uninstalled it and installed this one that I told you and it worked perfect!

Irene.

    
answered by 18.01.2018 в 12:38