Specifies how a command string is interpreted.
public enum class CommandTypepublic enum CommandTypetype CommandType = Public Enum CommandTypeAn SQL text command. (Default.)
StoredProcedure 4The name of a stored procedure.
TableDirect 512The name of a table.
When the IDbCommand.CommandType property is set to StoredProcedure, the IDbCommand.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 IDbCommand.CommandType property is set to TableDirect, the IDbCommand.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.
Note
TableDirect is only supported by the .NET Framework Data Provider for OLE DB. Multiple table access is not supported when IDbCommand.CommandType is set to TableDirect.
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide. In this articleWas this page helpful?
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4