- 22.2.3.1. Making a connection
- 22.2.3.2. Editing Tables
- 22.2.3.3. Editing Views
- 22.2.3.4. Editing Stored Procedures and Functions
- 22.2.3.5. Editing Triggers
- 22.2.3.6. Editing User Defined Functions (UDF)
- 22.2.3.7. Cloning Database Objects
- 22.2.3.8. Dropping Database Objects
- 22.2.3.9. Using the ADO.NET Entity Framework
- 22.2.3.10. MySQL Website Configuration Tool
- 22.2.3.11. MySQL SQL Editor
- 22.2.3.12. DDL T4 Template Macro
When MySQL Connector/NET is installed on Microsoft Windows, Visual Studio integration components are also installed and initialized. This enables the developer to work seamlessly with MySQL Connector/NET in the familiar Visual Studio environment, as described in the following sections of the manual.
MySQL Connector/NET supports Visual Studio versions 2005, 2008, and 2010. However, only MySQL Connector/NET version 6.3 fully integrates with Visual Studio 2010, although applications using earlier versions of the connector can be built with the Visual Studio 2010 environment using .NET 2.x frameworks.
Visual Studio 2010 support was introduced with MySQL Connector/NET 6.3.2. From
version 6.3.2 the connector ships 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 need to be
shipped 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
.mysqlfile in their project and execute it against the MySQL server.New SQL Editor - A new SQL editor has been included that enables connections to servers to execute SQL. This is activated by creating a new file with a
.mysqlextension. A new template is also included to allow creation of this file type using the Visual Studio 2010 main menu item , . Note that the MySQL SQL Editor is also available in 2005 and 2008.