Documentation Home
MySQL Connector/NET Developer Guide
Related Documentation Download this Manual

MySQL Connector/NET Developer Guide  /  Connector/NET Programming

Chapter 5 Connector/NET Programming

Table of Contents     [+/-]

5.1 Connecting to MySQL Using Connector/NET     [+/-]
5.2 Using MySqlCommand
5.3 Using Connector/NET with Connection Pooling
5.4 Using the Windows Native Authentication Plugin
5.5 Writing a Custom Authentication Plugin
5.6 Using Connector/NET with Table Caching
5.7 Using the Connector/NET with Prepared Statements     [+/-]
5.8 Accessing Stored Procedures with Connector/NET     [+/-]
5.9 Handling BLOB Data With Connector/NET     [+/-]
5.10 Asynchronous Methods
5.11 Using the Connector/NET Interceptor Classes
5.12 Handling Date and Time Information in Connector/NET     [+/-]
5.13 Using the MySqlBulkLoader Class
5.14 Using the Connector/NET Trace Source Object     [+/-]
5.15 Binary/Nonbinary Issues
5.16 Character Set Considerations for Connector/NET
5.17 Using Connector/NET with Crystal Reports     [+/-]
5.18 ASP.NET Provider Model
5.19 Working with Partial Trust / Medium Trust     [+/-]

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:

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

In the following sections, you will learn about some common use cases for Connector/NET, including BLOB handling, date handling, and using Connector/NET with common tools such as Crystal Reports.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.