CommandType Enumeration
TOC
Collapse the table of content
Expand the table of content

CommandType Enumeration

 

Specifies how a command string is interpreted.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public enum CommandType

Member nameDescription
StoredProcedure

The name of a stored procedure.

TableDirect

The name of a table.

Text

An SQL text command. (Default.)

When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure to be accessed. The user may be required to use escape character syntax or include qualifying characters if any of the specified tables named contain any special characters. All rows and columns of the named table or tables will be returned when you call one of the Execute methods of a Command object.

When the CommandType property is set to TableDirect, the CommandText property should be set to the name of the table to be accessed. The user may be required to use escape character syntax or include qualifying characters if any of the tables named contain any special characters. All rows and columns of the named table will be returned when you call one of the Execute methods.

In order to access multiple tables, use a comma delimited list, without spaces or padding, containing the names of the tables to access. When the CommandText property names multiple tables, a join of the specified tables is returned.

System_CAPS_noteNote

TableDirect is only supported by the .NET Framework Data Provider for OLE DB. Multiple table access is not supported when CommandType is set to TableDirect.

Universal Windows Platform
Available since 10
.NET Framework
Available since 1.1
Return to top
Show:
© 2016 Microsoft