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#. It does not use the MySQL C client library.
For notes detailing the changes in each release of Connector/Net, see MySQL Connector/Net Release Notes.
Connector/Net includes full support for:
Features provided by MySQL Server up to and including MySQL Server 5.7.
Large-packet support for sending and receiving rows and
BLOBvalues 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.
Microsoft Entity Framework.
Microsoft Windows RT.
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
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 Chapter 4, Connector/Net Visual Studio Integration.
From Connector/Net 5.1 through 6.6, the Visual Studio Plugin is part of the main Connector/Net package. Starting with 6.7, the Visual Studio Plugin has been separated out into it's own product. The MySQL for Visual Studio Plugin release notes can be found at MySQL Connector/Net Release Notes.
MySQL Connector/Net supports full versions of Visual Studio 2008, 2010, and 2012, although the extent of support may be limited depending on your versions of MySQL Connector/Net and Visual Studio. For details, see Chapter 4, Connector/Net Visual Studio Integration.
MySQL Connector/Net does not support Express versions of Microsoft products, including Microsoft Visual Web Developer.
For connection string properties when using the
MySqlConnectionclass, see Chapter 7, Connector/Net Connection String Options Reference.