Chapter 5 Connector/NET Programming

Table of Contents     [+/-]

5.1 Connecting to MySQL Using Connector/NET     [+/-]

5.1.1 Creating a Connector/NET Connection String

5.1.2 Handling Connection Errors

5.1.3 Using GetSchema on a Connection

5.2 Using MySqlCommand

5.3 Connecting With TCP/IP Over SSH

5.4 Using Connector/NET with Connection Pooling

5.5 Using the Windows Native Authentication Plugin

5.6 Writing a Custom Authentication Plugin

5.7 Using Connector/NET with Table Caching

5.8 Using the Connector/NET with Prepared Statements     [+/-]

5.8.1 Preparing Statements in Connector/NET

5.9 Accessing Stored Procedures with Connector/NET     [+/-]

5.9.1 Using Stored Routines from Connector/NET

5.10 Handling BLOB Data With Connector/NET     [+/-]

5.10.1 Preparing the MySQL Server

5.10.2 Writing a File to the Database

5.10.3 Reading a BLOB from the Database to a File on Disk

5.11 Asynchronous Methods

5.12 Using the Connector/NET Interceptor Classes

5.13 Handling Date and Time Information in Connector/NET     [+/-]

5.13.1 Fractional Seconds

5.13.2 Problems when Using Invalid Dates

5.13.3 Restricting Invalid Dates

5.13.4 Handling Invalid Dates

5.13.5 Handling NULL Dates

5.14 Using the MySqlBulkLoader Class

5.15 Using the Connector/NET Trace Source Object     [+/-]

5.15.1 Viewing MySQL Trace Information

5.15.2 Building Custom Listeners

5.16 Binary/Nonbinary Issues

5.17 Character Set Considerations for Connector/NET

5.18 Using Connector/NET with Crystal Reports     [+/-]

5.18.1 Creating a Data Source

5.18.2 Creating the Report

5.18.3 Displaying the Report

5.19 ASP.NET Provider Model

5.20 Working with Partial Trust / Medium Trust     [+/-]

5.20.1 Evolution of Partial Trust Support Across Connector/NET Versions

5.20.2 Configuring Partial Trust with Connector/NET Library Installed in GAC

5.20.3 Configuring Partial Trust with Connector/NET Library Not Installed in GAC

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.

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

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.