dotConnect for MySQL Documentation
In This Topic
    Components
    In This Topic

    This topic presents a brief description of the classes and components included in dotConnect for MySQL. Click on the name of each component for more information.

    Core ADO.NET Classes

    Class Description
    MySqlConnection Establishes a connection to MySQL database and manages transactions.
    MySqlCommand Executes SQL statements and stored procedures at MySQL database.
    MySqlDataReader Exposes and reads a forward-only stream of data from MySQL database.
    MySqlDataAdapter* Populates a DataSet and resolves updates with 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 MySQL database. For an error encountered at the client, dotConnect for MySQL throws a .NET Framework exception.

    Complementary ADO.NET Classes

    Class Description
    MySqlCommandBuilder* A helper object that automatically generates command properties of MySqlDataAdapter* and populates the MySqlParameter collection of MySqlCommand object.
    MySqlConnectionStringBuilder Constructs a connection string by assigning values to appropriate properties.
    MySqlDataSourceEnumerator* Retrieves list of available servers in the network.
    MySqlDataSource** Enables flexible data binding for ASP.NET applications.

    dotConnect for MySQL Advanced Classes

    Class Description
    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

    Class Description
    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 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.