MySQL for Visual Studio  /  Installing and Configuring

Chapter 2 Installing and Configuring

MySQL for Visual Studio is a product for Microsoft Windows, and it is installed with MySQL Installer, or alternatively from its own MSI.

Note

Many MySQL for Visual Studio features require MySQL Connector/Net installed on the same system, and MySQL Connector/Net is a separate download. Install both using MySQL Installer.

Requirements

MySQL for Visual Studio supports full versions of Visual Studio 2008 and later, although the extent of support is based on your installed versions of MySQL Connector/Net and Visual Studio:

  • Current: Visual Studio 2013 (Professional edition and up, or Community edition) is supported using MySQL for Visual Studio with MySQL Connector/Net 6.8 and up.

    Older: Visual Studio 2012 is supported by MySQL for Visual Studio with MySQL Connector/Net 6.7.

The following table shows the support information for MySQL for Visual Studio

Table 2.1 Support Information for MySQL for Visual Studio

MySQL for Visual Studio VersionConnector/Net Version SupportedVisual Studio Version SupportedMySQL Server Versions SupportedCurrently SupportedNotes
2.06.9,6.82008, 2010, 2012, 2013, 20155.7, 5.6, 5.5, 5.1, 5.0YesSome features require C/Net 6.9
1.26.9,6.82008, 2010, 2012, 2013, 20155.7, 5.6, 5.5, 5.1, 5.0YesSome features require C/Net 6.9
1.16.82008, 2010, 2012, 20135.7, 5.6, 5.5, 5.1, 5.0Yes 
1.06.72008, 2010, 20125.7, 5.6, 5.5, 5.1, 5.0Yes 

MySQL for Visual Studio is closely tied to MySQL Connector/Net, but they are two separate products that can be used without one another. However, the following restrictions apply:

  • Important

    Always install the MySQL for Visual Studio before installing MySQL Connector/Net.

  • MySQL for Visual Studio cannot be installed alongside any version of MySQL Connector/Net 6.6 and before, which has to be removed before installing MySQL for Visual Studio.

  • The following MySQL for Visual Studio features require MySQL Connector/Net:

    • Entity Framework Designer, when using the Data Base First or the Model First approach.

    • Web Configuration Tool

MySQL Connector/Net 6.6 and earlier does not support Express versions of Microsoft development products, including the Visual Studio and the Microsoft Visual Web Developer.

MySQL for Visual Studio does not support Express versions of Microsoft development products, including the Visual Studio and the Microsoft Visual Web Developer.

To use MySQL Connector/Net with an Express versions of Microsoft development products, use MySQL Connector/Net 6.7.4 or later, without installing the MySQL for Visual Studio.

Up till Connector/Net 6.6, the Visual Studio Plugin was part of the main Connector/Net package and is automatically installed together with MySQL Connector/Net.


User Comments
  Posted by Peter Campbell on July 19, 2016
Despite the above table saying MySQL for Visual Studio supports Visual Studio 2008 and up, when you install 1.2.6 it says you need VS 2010, 2012, 2013 or 2015. I have a full installation of 2008 and it will NOT install. As such the page should be amended to reflect its non-support for VS 2008.
It appears you need to go back to MySQL for Visual Studio version 1.1.4 for VS 2008 support.

Similarly, the latest versions of Connector/NET do not work with MySQL for Visual Studio 1.1.4 when it's installed with VS2008 either - you need to go back to Connector/NET 6.7.9 to get "MySQL Data Provider" to appear in SSIS 2008 as a ".Net Provider\SqlClient Data Provider" for an ADO.NET connection; 6.8.8 and 6.9.9 do NOT show up.

Alternatively if you use Connector/NET 6.6.7 this has the Visual Studio integration built into that package, which makes MySQL for Visual Studio redundant.

Although getting connections to work in SSIS in addition to having them appear is another issue.
Sign Up Login You must be logged in to post a comment.