MySQL for Visual Studio  /  Installing MySQL for Visual Studio

Chapter 2 Installing MySQL for Visual Studio

MySQL for Visual Studio is an add-on for Microsoft Visual Studio that simplifies the development of applications using data stored by the MySQL RDBMS. Many MySQL features also require that MySQL Connector/Net be installed on the same host where you perform Visual Studio development. Connector/Net is a separate product with several versions.

The options for installing MySQL for Visual Studio are:

  • Using MySQL Installer (preferred): Download and execute the MySQL Installer.

    With this option you can download and install MySQL Server, MySQL for Visual Studio, and Connector/Net together from the same software package, based on the server version. Initially, MySQL Installer assists you by evaluating the software prerequisites needed for the installation. Thereafter, MySQL Installer enables you to keep your installed products updated or to easily add and remove related MySQL products.

    For additional information about using MySQL Installer with MySQL products, see MySQL Installer for Windows.

  • Using the standalone Zip or MSI file: This option is ideal if you have MySQL Server and Connector/Net installed already. Use the information in this section to determine which version of MySQL for Visual Studio to install.

Minimum Requirements

MySQL for Visual Studio 1.2.8 is compatible with Connector/Net 6.9.12, 6.10.7 and 8.0.11. Previous Connector/Net versions are not supported by this release.

MySQL for Visual Studio operates with several versions of Visual Studio, although the extent of support is based on your installed versions of Connector/Net and Visual Studio. MySQL for Visual Studio no longer supports Visual Studio 2010 or 2008. Minimum requirements for the supported versions of Visual Studio are as follows:

  • Visual Studio 2017 (Community, Professional, and Enterprise):

    MySQL for Visual Studio 1.2.7 or 2.0.5 with Connector/Net 6.9.8

  • Visual Studio 2015 (Community, Professional, and Enterprise):

    MySQL for Visual Studio 1.2.7 or 2.0.2 with Connector/Net 6.9.8

  • Visual Studio 2013 (Professional, Premium, Ultimate):

    • .NET Framework 4.5.2 (install first).

    • MySQL for Visual Studio 1.2.1 or 2.0.0 with Connector/Net 6.9.8

  • Visual Studio 2012 (Professional, Test Professional, Premium, Ultimate):

    • .NET Framework 4.5.2 (install first).

    • MySQL for Visual Studio 1.2.1 or 2.0.0 with Connector/Net 6.9.8

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 Connector/Net with Express versions of Microsoft development products, use Connector/Net 6.9 or later, without installing the MySQL for Visual Studio.

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 VersionMySQL Connector/Net Version SupportedVisual Studio Version SupportedMySQL Server Versions SupportedNotes
2.08.0, 6.10, 6.92017, 2015, 2013, 20125.7, 5.6, 5.5Enables MySQL Configurations Manager and X DevAPI (with MySQL 5.7) features.
1.28.0, 6.10, 6.92017, 2015, 2013, 20128.0, 5.7, 5.6, 5.5Support for MySQL 8.0 features requires MySQL for Visual Studio 1.2.8 or higher.

MySQL Connector/Net Restrictions

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

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

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

    • The Entity Framework Designer

    • The Website Configuration Tool

    • Debugging Stored Procedures and Functions

    • The DDL T4 Template Macro (to generate a database from an EF Model)


User Comments
Sign Up Login You must be logged in to post a comment.