Skip navigation links

Additional languages
MySQL 6.0 Reference Manual :: 29 Connectors :: 29.2 MySQL Connector/NET :: 29.2.3 Connector/NET Examples and Usage Guide
29.2.3.1 Using MySqlCommand »
Section Navigation      [Toggle]

29.2.3. Connector/NET Examples and Usage Guide

[+/-]

29.2.3.1. Using MySqlCommand
29.2.3.2. Using MySqlCommandBuilder
29.2.3.3. Using MySqlConnection
29.2.3.4. Using MySqlDataAdapter
29.2.3.5. Using MySqlDataReader
29.2.3.6. Using MySqlException
29.2.3.7. Using MySqlParameter
29.2.3.8. Using MySqlParameterCollection
29.2.3.9. Using MySqlTransaction

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:

  • 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 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.

This section contains basic information and examples for each of the above classes. For a more detailed reference guide please see Section 29.2.4, “Connector/NET Reference”.