''CommandType'' ''serializable'

CommandType serializable

System.Data (system.data.dll) enum

This enumeration sets the IDbCommand.CommandType property, which defines how the IDbCommand.CommandText property is interpreted. If you use Text (the default), the IDbCommand.CommandText is interpreted as a SQL command (e.g., a direct UPDATE, DELETE, INSERT, or SELECT command). If you use StoredProcedure , IDbCommand.CommandText is the name of the stored procedure you want to execute. Some providers support the use of the TableDirect CommandType . In this case, the IDbCommand.CommandText is interpreted as the name of a table from which rows will be retrieved (in a SELECT * FROM TableName style). You can also use a comma-delimited list of tables on which a join is performed. TableDirect isn't supported by all data providers.

public enum CommandType {
   Text = 1,
   StoredProcedure = 4,
   TableDirect = 512
}

Hierarchy

System.Object figs/U2192.gif System.ValueType figs/U2192.gif System.Enum(System.IComparable, System.IFormattable , System.IConvertible) figs/U2192.gif CommandType

Returned By

IDbCommand.CommandType , System.Data.OleDb.OleDbCommand.CommandType , System.Data.OracleClient.OracleCommand.CommandType , System.Data.SqlClient.SqlCommand.CommandType

Passed To

IDbCommand.CommandType , System.Data.OleDb.OleDbCommand.CommandType , System.Data.OracleClient.OracleCommand.CommandType , System.Data.SqlClient.SqlCommand.CommandType



    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace