MySQL Data Source not appearing in Visual Studio


Answers

Stuzor and hexcodes solution worked for me as well. However, if you do want the latest connector you have to download another product. From the oracle website:

Starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html).

Question

I just installed the ADO.NET connector from here http://dev.mysql.com/downloads/connector/net/

Yet MySQL doesn't appear as a data source like it should. I tried restarting Visual Studio. It doesn't fix my issue. Did I install the wrong connector?

EDIT: STill nothing. I'm using Visual Studio Express For Desktop. Do I need to pay for the Ultimate edition to use a MySQL Data Source?




How to connect to a MySQL Data Source in Visual Studio

Visual Studio requires that DDEX Providers (Data Designer Extensibility) be registered by adding certain entries in the Windows Registry during installation (HKLM\SOFTWARE\Microsoft\VisualStudio\{version}\DataProviders) . See DDEX Provider Registration in MSDN for more details.







MySQL Database Connection With Visual Studio 2013 Preview

I am using Visual Studio 2013 Ultimate and I got it working with the Mysql Visual Studio 1.1.1 beta plugin.

Requirements:

  • Windows OS 7 or later.
  • Visual Studio 2010, 2012 or 2013 professional or higher version.
  • Connector/Net 6.8.1 beta or higher version to check the Connector/Net & Entity Framework features. (download at: http://dev.mysql.com/downloads/connector/net/ on the development releases).

Download:

https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi

You can find the latest here (v1.2.3):

http://dev.mysql.com/downloads/windows/visualstudio/

Source:

http://forums.mysql.com/read.php?174,601041,601041#msg-601041




You have to install a the Entity Framework NuGet Package by right-clicking the specific project and then select "Manage NuGet Package". It'll pop-up a Window where you can search for existing packages online and install them