- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 21.2.5 Connector/NET Programming
- 21.2.5.1 Connecting to MySQL Using Connector/NET
- 21.2.5.2 Creating a Connection String
- 21.2.5.3 Using MySqlCommand
- 21.2.5.4 Using Connector/NET with Connection Pooling
- 21.2.5.5 Using the Connector/NET with Prepared Statements
- 21.2.5.6 Accessing Stored Procedures with Connector/NET
- 21.2.5.7 Handling BLOB Data With Connector/NET
- 21.2.5.8 Using Connector/NET with Crystal Reports
- 21.2.5.9 Handling Date and Time Information in Connector/NET
- 21.2.5.10 ASP.NET Provider Model
- 21.2.5.11 Binary/Nonbinary Issues
- 21.2.5.12 Character Sets
- 21.2.5.13 Working with medium trust
A MySqlCommand has the CommandText and
CommandType properties associated with it. The
CommandText will be handled differently
depending on the setting of CommandType.
CommandType can be one of:
Text - A SQL text command (default)
StoredProcedure - The name of a Stored Procedure
TableDirect - The name of a table (new in Connector/NET 6.2)
The default CommandType,
Text, is used for executing queries and other
SQL commands. Some example of this can be found in the following
section Section 21.2.4.1.2, “The MySqlCommand Object”.
If CommandType is set to
StoredProcedure, CommandText
should be set to the name of the Stored Procedure to access.
If CommandType is set to
TableDirect, all rows and columns of the named
table will be returned when you call one of the Execute methods.
Examples of using the CommandType of StoredProcedure can be found in the section Section 21.2.5.6.2, “Calling a Stored Procedure from Connector/NET”.
User Comments
Add your own comment.