Table of Contents [+/-]
With MySQL's support for Visual Studio, developers can work seamlessly with MySQL Connector/Net in the familiar Visual Studio environment.
MySQL Connector/Net supports full versions of Visual Studio 2008, 2010, 2012, and 2013, although the extent of support may be limited depending on your versions of MySQL Connector/Net and Visual Studio:
Visual Studio 2013 (Professional edition and up only) 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 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 Version||Connector/Net Version Supported||Visual Studio Version Supported||MySQL Server Versions Supported||Currently Supported|
|1.1||6.8||2008, 2010, 2012, 2013||5.7, 5.6, 5.5, 5.1, 5.0||Yes|
|1.0||6.7||2008,2010,2012||5.7, 5.6, 5.5, 5.1, 5.0||Yes|
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
The MySQL for Visual Studio release notes can be found here.
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.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 Visual Studio Plugin release notes can be found here.
Copyright © 2004, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices