Oracle 5.0, Reference Manual

Page: 1836 / 3232

Connector/Net Versions
1816
• 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
Section 20.2.3, “Connector/Net Visual Studio Integration” .
Note
Connector/Net 5.1.2 and later include the Visual Studio Plugin by default.
MySQL Connector/Net supports full versions of Visual Studio 2005, 2008, and 2010, although certain
features are only available in Visual Studio 2010 when using MySQL Connector/Net version 6.3.2
and later. Note that MySQL Connector/Net does not currently support Express versions of Microsoft
products, including Microsoft Visual Web Developer.
Key topics:
• For connection string properties when using the
MySqlConnection
class, see Section 20.2.6,
“Connector/Net Connection String Options Reference” .
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 .
20.2.1. Connector/Net Versions
There are several versions of Connector/Net available:
• Connector/Net 6.6 includes support for MySQL Server 5.6, 5.5, 5.1, and 5.0. Important new features
include stored procedure debugging in Microsoft Visual Studio, support for pluggable authentication
including the ability to write you own authentication plugin, Entity Framework 4.3 Code First support,
and enhancements to partial trust support to allow hosting services to deploy applications without
installing the Connector/Net library in the GAC.
• Connector/Net 6.5 includes support for MySQL Server 5.6, 5.5, 5.1, and 5.0. Important new features
include interceptor classes for exceptions and commands, support for the MySQL 5.6 fractional
seconds feature, better partial-trust support, and better IntelliSense, including auto-completion when
editing stored procedures or
.mysql
files.
• Connector/Net 6.4 includes support for MySQL Server 5.5, 5.1, and 5.0. Important new features
include support for Windows authentication (when connecting to MySQL Server 5.5+), table caching
on the client side, simple connection fail-over support, and improved SQL generation from the Entity
Framework provider.