26.2.3. Connector/NET Architecture
MySQL Connector/NET comprises several classes that are used to connect
to the database, execute queries and statements, and manage query
The following are the major classes of MySQL Connector/NET:
MySqlCommand: Represents an SQL statement
to execute against a MySQL database.
generates single-table commands used to reconcile changes made
to a DataSet with the associated MySQL database.
MySqlConnection: Represents an open
connection to a MySQL Server database.
MySqlDataAdapter: Represents a set of data
commands and a database connection that are used to fill a
dataset and update a MySQL database.
MySqlDataReader: Provides a means of
reading a forward-only stream of rows from a MySQL database.
MySqlException: The exception that is
thrown when MySQL returns an error.
MySqlHelper: Helper class that makes it
easier to work with the provider.
MySqlTransaction: Represents an SQL
transaction to be made in a MySQL database.
Each of these objects will be described in the upcoming sections.
These sections are intended to be an overview of the major classes
of MySQL Connector/NET, and not a syntax reference. If you need more
detailed information you should read the
Documentation.chm file included with the
MySQL Connector/NET distribution.