MySQL for Visual Studio

Abstract

This is the MySQL for Visual Studio User Manual. It documents the MySQL for Visual Studio through 1.2.9.

For notes detailing the changes in each release, see the MySQL for Visual Studio Release Notes.

For legal information, including licensing information, see the Preface and Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2020-10-23 (revision: 67821)

---

Table of Contents

Preface and Legal Notices

1 General Information

1.1 New in Version 2.0

1.2 New in Version 1.2

2 Installing MySQL for Visual Studio

3 Enabling the MySQL Toolbar

4 Making a Connection

4.1 Connect Using Server Explorer

4.2 Connect Using MySQL Connections Manager

5 Editing

5.1 MySQL SQL Editor

5.2 Code Editors

5.3 Editing Tables

5.3.1 Column Editor

5.3.2 Column Properties

5.3.3 Table Properties

5.4 Editing Views

5.5 Editing Indexes

5.6 Editing Foreign Keys

5.7 Editing Stored Procedures and Functions

5.8 Editing Triggers

6 Using the ADO.NET Entity Framework

7 MySQL Application Configuration Tool

7.1 Entity Framework

7.2 Web Providers

7.3 Using the MySQL Connection String Editor

8 MySQL Project Items

8.1 MySQL ASP.NET MVC Items

8.2 MySQL Windows Forms Items

9 MySQL Data Export Tool

10 DDL T4 Template Macro

11 Debugging Stored Procedures and Functions

A MySQL for Visual Studio Frequently Asked Questions