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
results.
The following are the major classes of MySQL Connector/NET:
MySqlCommand
: Represents an SQL statement
to execute against a MySQL database.
MySqlCommandBuilder
: Automatically
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.