MySQL Data Source Not Displaying in Visual Studio 2015

Question

As the name says, no matter what I do, MySQL does not appear in the list of data sources in Visual Studio 2015.

I did everything suggested in this question: MySQL data source is not displayed in Visual Studio

I also installed development versions and various connector versions with the corresponding MySQL VS drivers according to this table here: https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html p>

I reinstalled Visual Studio itself.

All this to no avail. I can manually configure the connection and run the .Net application that reads and writes to MySQL, but Visual Studio refuses to do anything with MySQL in the data source popup.

Failed to move the database to SQL Server. I'm not sure what else can be done here.

Any suggestion or help to solve this problem would be great. I have been doing this for the last 48 hours.

Currently installed versions: MySQL for Visual Studio - 1.2.7, Connector / Net - 6.9.9

This is for the .Net 4.5.2 project.

Answer 1

I had the same problem a while ago. Unfortunately, I think the answer is random, and I can’t remember exactly what fixed it, except for playing with versions of MySQL Server and MySQL Connector / Net.

I have VS 2015, so I just tried to recreate this problem. I was not able to do this because I installed MySQL for VS 1.2.7 and Connector / Net 6.9.9 and was able to see the MySQL database as an option in the Data Sources window.

I recommend uninstalling both MySQL for VS and your Connector / Net 6.9.9, and then reinstalling them. Make sure you install MySQL for VS in front of the connector / network, as the documentation that you linked in your question says: "Always install MySQL for Visual Studio before installing MySQL Connector / Net."

You can also try using the MySQL community server instead of MySQL for VS, and use an older version of Connector / Net.

Update

Try the following:

• Remove MySQL for VS and Connector / Net.
• Install Connector / Net 6.9.9 using a typical installation. Remove the web provider feature from the installation and continue with the installation.
• Install MySQL for VS 1.2.7 using a typical installation. Make sure that the Visual Studio integration function is selected to install and complete the installation (it should be selected by default).

Update 2

If you need more alternatives to reinstall:

Try checking the properties of the machine.config file to see if the MySQL data provider property looks similar to mine by going to C: \ Windows \ Microsoft.NET \ Framework \ v2.0.50727 \ CONFIG

Check Lines:

• ltsadd name = "MySQL Data Provider" invariant = "MySql.Data.MySqlClient" description = "Net Framework Data Provider for MySQL" type = "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version = 6.9.9.0, Culture = neutral, PublicKeyToken = XXXXXXXXX "/ gts

Also, maybe try creating a website instead of a project, or vice versa. There are several ways to get to the Data Source window. You can try to create an ADO.Net object and add a connection to see if this window displays the MySQL data source as the data source. You can also create a connection through the server explorer window. Just follow these steps .

Answer 2

Install the latest version of NuGet:

MySql.Data MySql.Data.Entity 

Close and reopen visual studio

Select ADO Input Data Model

New connection

To the right of the data source, the edit button

In a new window you will find the MySQL database