- 21.2 MySQL Connector/Net
- 21.2.1 Connector/Net Versions
- 21.2.2 Connector/Net Installation
- 21.2.3 Connector/Net Visual Studio Integration
- 21.2.3.1 Making a Connection
- 21.2.3.2 Using IntelliSense in the SQL Editor
- 21.2.3.3 Editing Tables
- 21.2.3.4 Editing Views
- 21.2.3.5 Editing Stored Procedures and Functions
- 21.2.3.6 Editing Triggers
- 21.2.3.7 Editing User Defined Functions (UDF)
- 21.2.3.8 Debugging Stored Procedures and Functions
- 21.2.3.9 Cloning Database Objects
- 21.2.3.10 Dropping Database Objects
- 21.2.3.11 Using the ADO.NET Entity Framework
- 21.2.3.12 MySQL Website Configuration Tool
- 21.2.3.13 MySQL SQL Editor
- 21.2.3.14 DDL T4 Template Macro
- 21.2.4 Connector/Net Tutorials
- 21.2.5 Connector/Net Programming
- 21.2.6 Connector/Net Connection String Options Reference
- 21.2.7 Connector/Net API Reference
- 21.2.8 Connector/Net Support
- 21.2.9 Connector/Net FAQ
[+/-]
- 21.2.3.1. Making a Connection
- 21.2.3.2. Using IntelliSense in the SQL Editor
- 21.2.3.3. Editing Tables
- 21.2.3.4. Editing Views
- 21.2.3.5. Editing Stored Procedures and Functions
- 21.2.3.6. Editing Triggers
- 21.2.3.7. Editing User Defined Functions (UDF)
- 21.2.3.8. Debugging Stored Procedures and Functions
- 21.2.3.9. Cloning Database Objects
- 21.2.3.10. Dropping Database Objects
- 21.2.3.11. Using the ADO.NET Entity Framework
- 21.2.3.12. MySQL Website Configuration Tool
- 21.2.3.13. MySQL SQL Editor
- 21.2.3.14. 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 and higher fully integrate 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
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
.mysqlfile 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
.mysqlextension. 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.
As of Connector/Net 5.1.2, the Visual Studio Plugin is part of the main Connector/Net package. However, even for versions of Connector/Net older than 5.1.2, the Visual Studio Plugin release notes can be found at MySQL Connector/Net Release Notes.
User Comments
Add your own comment.