Users Guide

MySQL Connector/Net

Users Guide
MySQL Connector/Net

Connector/Net lets you easily develop .NET applications that require secure, high-performance data connectivity with MySQL. It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. Developers can build applications using their choice of .NET languages. Connector/Net is a fully managed ADO.NET driver written in 100% pure C#.

Connector/Net includes full support for:

  • Features provided by MySQL Server up to and including MySQL Server version 5.5.

  • Large-packet support for sending and receiving rows and BLOBs up to 2 gigabytes in size.

  • Protocol compression, which enables compressing the data stream between the client and server.

  • Connections using TCP/IP sockets, named pipes, or shared memory on Windows.

  • Connections using TCP/IP sockets or Unix sockets on Unix.

  • The Open Source Mono framework developed by Novell.

  • Fully managed, does not utilize the MySQL client library.

This document is intended as a user's guide to Connector/Net and includes a full syntax reference. Syntax information is also included within the Documentation.chm file included with the Connector/Net distribution.

If you are using MySQL 5.0 or later, and Visual Studio as your development environment, you can also use the MySQL Visual Studio Plugin. The plugin acts as a DDEX (Data Designer Extensibility) provider: you can use the data design tools within Visual Studio to manipulate the schema and objects within a MySQL database. For more information, see [9f3f194e-ad35-4379-b04d-5dce4b34ce6a].

Note Note

Connector/Net 5.1.2 and later include the Visual Studio Plugin by default.

supports full versions of Visual Studio 2005, 2008, and 2010, although certain features are only available in Visual Studio 2010 when using version 6.3.2 and later. Note that does not currently support Express versions of Microsoft products, including Microsoft Visual Web Developer.

Key topics: