dotConnect for MySQL Components

See a brief description of the classes and components included in dotConnect for MySQL. For more information, click the name of each component.

Class

Description

Core ADO.NET Classes
MySqlConnection

Establishes a connection to the MySQL database and manages transactions.

MySqlCommand

Executes SQL statements and stored procedures at the MySQL database.

MySqlDataReader

Exposes and reads a forward-only stream of data from the MySQL database.

MySqlDataAdapter*

Populates a DataSet and resolves updates with the MySQL database.

MySqlTransaction

Starts, commits, or rolls back server transactions.

MySqlParameter

Represents input, output, and return value parameters for commands.

MySqlException

Represents an error encountered at the MySQL database. For an error encountered at the client, dotConnect for MySQL throws a .NET Framework exception.

Complementary ADO.NET Classes
MySqlCommandBuilder*

A helper object that automatically generates command properties of MySqlDataAdapter and populates the MySqlParameter collection of the MySqlCommand object.

MySqlConnectionStringBuilder

Constructs a connection string by assigning values to appropriate properties.

MySqlDataSourceEnumerator*

Retrieves the list of available servers in the network.

MySqlDataSource**

Enables flexible data binding for ASP.NET applications.

dotConnect for MySQL Advanced Classes
MySqlDataTable**

Provides all of the functionality needed to retrieve and manipulate data from a MySQL server data source. Combines connected and disconnected data access models.

MySqlDataSet**

Represents typed and untyped MySQL-specific datasets. Bases on MySqlDataTable objects to build the schema.

DataLink**

Serves to establish flexible cross-form data binding.

dotConnect for MySQL Auxiliary Classes
MySqlScript

Serves to execute series of SQL statements.

MySqlLoader

Serves to load external data into the MySQL database.

MySqlDump*

Serves to store a database or its parts as a script and also to restore a database from the received script.

MySqlMonitor

Serves to monitor dynamic SQL execution in applications that use dotConnect for MySQL.

* This class is not available in the dotConnect for MySQL .Net Standard 1.3 compatible assemblies. It is supported only for full .NET Framework and .NET Standard 2.0.

** This class is supported only for full .NET Framework. It is not available in the dotConnect for MySQL .Net Standard compatible assemblies.