4.1 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.


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


MySQL Connector/Net 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:

  • Visual Studio 2013 (Professional edition and up, or Community edition) is supported by MySQL Connector/Net 6.8 and up with the MySQL for Visual Studio product.

    Visual Studio 2012 is supported by MySQL Connector/Net 6.7 with MySQL for Visual Studio, and by MySQL Connector/Net 6.6 with the older Visual Studio Plugin.

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

    Table 4.1 Support Information for MySQL for Visual Studio

    MySQL for Visual Studio VersionConnector/Net Version SupportedVisual Studio Version SupportedMySQL Server Versions SupportedCurrently SupportedNotes
    1.26.9,6.82008, 2010, 2012, 20135.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 Connector/Net and MySQL for Visual Studio are two separate products and can be used without one another. However, the following restrictions apply:

    • 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 functions of MySQL for Visual Studio require MySQL Connector/Net to be installed:

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

      • Web Configuration Tool

  • Full integration with Visual Studio 2010 is available only with MySQL Connector/Net 6.3.2 and up, although applications using earlier versions of the connector can be built with the Visual Studio 2010 environment using .NET 2.x frameworks. Since version 6.3.2 onwards, MySQL Connector/Net has been shipped with both .NET 2.x and .NET 4.x versions of the entity framework support files, mysql.data.ef.dll and mysql.visualstudio.dll. The .NET 4.x versions are required to enable new integration features supported in Visual Studio 2010, including:

    • New DDL T4 template for the Entity Framework (EF) - This enables developers to design an EF model from scratch and use the native Visual Studio 2010 facility to generate MySQL DDL from that model. This is done by creating the model, and with the model open, choosing the SSDLToMySQL template in the properties window. The correct DDL is then generated. The developer can then save this code as a .mysql file in their project and execute it against the MySQL server.

    • New SQL Editor - A new SQL editor lets you connect to a MySQL server to execute SQL. This is activated by creating a new file with a .mysql extension. A new template lets you create files with this file type using the Visual Studio 2010 main menu item File, New. Note that the MySQL SQL Editor is also available in Visual Studio 2005 and 2008.

  • Visual Studio 2005 is supported only through MySQL Connector/Net 6.4.

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 is part of the main Connector/Net package and is automatically installed together with MySQL Connector/Net. The old Visual Studio Plugin release notes can be found here.

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