- 20.2 MySQL Connector/NET
- 20.2.1 Connector/NET Versions
- 20.2.2 Connector/NET Installation
- 20.2.3 Connector/NET Visual Studio Integration
- 20.2.4 Connector/NET Tutorials
- 20.2.5 Connector/NET Programming
- 20.2.5.1 Connecting to MySQL Using Connector/NET
- 20.2.5.2 Creating a Connection String
- 20.2.5.3 Using MySqlCommand
- 20.2.5.4 Using Connector/NET with Connection Pooling
- 20.2.5.5 Using the Connector/NET with Prepared Statements
- 20.2.5.6 Accessing Stored Procedures with Connector/NET
- 20.2.5.7 Handling BLOB Data With Connector/NET
- 20.2.5.8 Using Connector/NET with Crystal Reports
- 20.2.5.9 Handling Date and Time Information in Connector/NET
- 20.2.5.10 ASP.NET Provider Model
- 20.2.5.11 Binary/Nonbinary Issues
- 20.2.5.12 Character Sets
- 20.2.5.13 Working with medium trust
- 20.2.5.14 Using the MySQL Connector/NET Trace Source Object
- 20.2.5.15 Using the Bulk Loader
- 20.2.6 Connector/NET Connection String Options Reference
- 20.2.7 Connector/NET API Reference
- 20.2.8 Connector/NET Support
- 20.2.9 Connector/NET FAQ
[+/-]
- 20.2.5.1. Connecting to MySQL Using Connector/NET
- 20.2.5.2. Creating a Connection String
- 20.2.5.3. Using MySqlCommand
- 20.2.5.4. Using Connector/NET with Connection Pooling
- 20.2.5.5. Using the Connector/NET with Prepared Statements
- 20.2.5.6. Accessing Stored Procedures with Connector/NET
- 20.2.5.7. Handling BLOB Data With Connector/NET
- 20.2.5.8. Using Connector/NET with Crystal Reports
- 20.2.5.9. Handling Date and Time Information in Connector/NET
- 20.2.5.10. ASP.NET Provider Model
- 20.2.5.11. Binary/Nonbinary Issues
- 20.2.5.12. Character Sets
- 20.2.5.13. Working with medium trust
- 20.2.5.14. Using the MySQL Connector/NET Trace Source Object
- 20.2.5.15. Using the Bulk Loader
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
Add your own comment.