- 4.5.1 Using GetSchema on a Connection
- 4.5.2 Using MySqlCommand
- 4.5.3 Using Connector/NET with Table Caching
- 4.5.4 Preparing Statements in Connector/NET
- 4.5.5 Creating and Calling Stored Procedures
- 4.5.6 Handling BLOB Data With Connector/NET
- 4.5.7 Working with Partial Trust / Medium Trust
- 4.5.8 Writing a Custom Authentication Plugin
- 4.5.9 Using the Connector/NET Interceptor Classes
- 4.5.10 Handling Date and Time Information in Connector/NET
- 4.5.11 Using the MySqlBulkLoader Class
- 4.5.12 Using the Connector/NET Trace Source Object
- 4.5.13 Using Connector/NET with Crystal Reports
- 4.5.14 Asynchronous Methods
- 4.5.15 Binary and Nonbinary Issues
- 4.5.16 Character Set Considerations for Connector/NET
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 Connector/NET:
MySqlConnection: Represents an open connection to a MySQL database (see Section 4.4, “Connector/NET Connections”).
MySqlConnectionStringBuilderclass aids in the creation of a connection string by exposing the connection options as properties.
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.
MySqlDataAdapter: Represents a set of data commands and a database connection that are used to fill a data set 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.