MySqlDirect .NET is data provider to direct access to MySQL
database server for the Microsoft .NET Framework and .NET Compact Framework.
It completely based on ActiveX Data Objects for the .NET Framework ADO.NET
technology. ADO.NET provides a rich set of components for creating
distributed, data-sharing applications. It is an integral part of
the .NET Framework, providing access to relational data, XML, and
application data.
MySqlDirect .NET data provider can be used in the same way as the
SQL Server .NET or the OLE DB .NET Data Provider.
MySqlDirect .NET uses native MySQL programming interface to access
to MySQL database. It allows to create lightweight and fast
applications working with MySQL.
MySqlDirect .NET provides functionality for connecting to MySQL
database, executing commands, and retrieving results.
Those results can be processed directly, or placed in an ADO.NET
DataSet for further processing while in a disconnected state. While
in the DataSet, data can be exposed to the user, combined with other
data from multiple sources, or passed remotely between tiers. Any
processing performed on the data while in the DataSet can then be
reconciled to MySQL database.
MySqlDirect .NET data provider is designed to be lightweight. It
consists of a minimal layer between MySQL database and your code.
This extends functionality without sacrificing performance.
There are core classes that make up MySQLDirect .NET data provider.
The following table describes those classes and their functions.
MySqlConnection - Establishes a connection to MySQL database and can begin a transaction.
MySqlCommand - Executes a SQL at MySQL database, and exposes parameters.
MySqlDataReader - Exposes and reads a forward-only stream of data from MySQL database.
MySqlDataAdapter - Populates a DataSet and resolves updates with MySQL database.
MySqlTransaction - Enables you to enlist commands in transaction