OracleCommand Members
OracleCommand members are listed in the following tables.
OracleCommand Constructors
OracleCommand constructors are listed in Table 6-10.
Table 10 OracleCommand Constructors
| Constructor | Description |
|---|---|
| OracleCommand Constructors | Instantiates a new instance of OracleCommand class (Overloaded) |
OracleCommand Static Methods
The OracleCommand static method is listed in Table 6-11.
Table 11 OracleCommand Static Method
| Method | Description |
|---|---|
Equals |
Inherited from System.Object (Overloaded) |
OracleCommand Properties
OracleCommand properties are listed in Table 6-12.
Table 12 OracleCommand Properties
| Property | Description |
|---|---|
| AddRowid | Adds the ROWID as part of the select list |
| AddToStatementCache | Causes executed statements to be cached, when the property is set to true and statement caching is enabled |
| ArrayBindCount | Specifies if the array binding feature is to be used and also specifies the maximum number of array elements to be bound in the Value property |
| ArrayBindRowsAffected | Returns the number of affected rows for each iteration while executing a DML using array binding |
| BindByName | Specifies the binding method in the collection |
| CommandText | Specifies the SQL statement or stored procedure to run against the Oracle database or the XML data used to store changes to the Oracle database |
| CommandTimeout | Specifies the number of seconds the command is allowed to execute before terminating the execution with an exception |
| CommandType | Specifies the command type that indicates how the CommandText property is to be interpreted |
| Connection | Specifies the OracleConnection object that is used to identify the connection to execute a command |
Container |
Inherited from System.ComponentModel.Component |
| DesignTimeVisible | Specifies whether or not the OracleCommand object is visible on designer controls. |
| FetchSize | Specifies the size of OracleDataReader’s internal cache to store result set data |
| FetchSqlId | Indicates whether or not to fetch the Not Available in ODP.NET, Unmanaged Driver |
| ImplicitRefCursors | Specifies an array of OracleRefCursors mapped to an implicit resultset returned by the stored procedure. |
| InitialLOBFetchSize | Specifies the amount of data that the OracleDataReader initially fetches for LOB columns |
| InitialLONGFetchSize | Specifies the amount of data that the OracleDataReader initially fetches for LONG and LONG RAW columns |
| Notification | Indicates that there is a notification request for the command |
| NotificationAutoEnlist | Indicates whether or not to register for a continuous query notification with the database automatically when the command is executed |
| Parameters | Specifies the parameters for the SQL statement or stored procedure |
| RowSize | Specifies the amount of memory needed by the OracleDataReader internal cache to store one row of data |
| RowsToFetchPerRoundTrip | Specifies the total number of rows to retrieve per database round trip Not Available in ODP.NET, Unmanaged Driver |
| Site | Inherited from System.ComponentModel.Component |
| SqlId | Provides the Not Available in ODP.NET, Unmanaged Driver |
| Transaction | Specifies the OracleTransaction object in which the OracleCommand executes |
| UpdatedRowSource | Specifies how query command results are applied to the row being updated |
| UseEdmMapping | Indicates whether or not the command object utilizes the Entity Data Model mapping configuration values |
| XmlCommandType | Specifies the type of XML operation on the OracleCommand |
| XmlQueryProperties | Specifies the properties that are used when an XML document is created from the result set of a SQL query statement |
| XmlSaveProperties | Specifies the properties that are used when an XML document is used to save changes to the database |
OracleCommand Public Methods
OracleCommand public methods are listed in Table 6-13.
Table 13 OracleCommand Public Methods
| Public Method | Description |
|---|---|
| Cancel | Attempts to cancels a command that is currently executing on a particular connection |
| Clone | Creates a copy of OracleCommand object |
CreateObjRef |
Inherited from System.MarshalByRefObject |
| CreateParameter | Creates a new instance of OracleParameter class |
| Dispose | Releases any resources or memory allocated by the object |
Equals |
Inherited from System.Object (Overloaded) |
| ExecuteNonQuery | Executes a SQL statement or a command using the XmlCommandType and CommandText properties and returns the number of rows affected |
| ExecuteNonQueryAsync | Returns a Task-based asynchronous version of ExecuteNonQuery() (Overloaded). |
| ExecuteReader | Executes a command (Overloaded) |
| ExecuteReaderAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteReader(), which fetches the result set as an OracleDataReader object. (Overloaded) |
| ExecuteScalar | Returns the first column of the first row in the result set returned by the query |
| ExecuteScalarAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteScalar(), which returns the first column of the first row in the result set returned by the query. (Overloaded) |
| ExecuteStatements | Executes a stream of SQL and PL/SQL statements and returns any results as a JSON string |
| ExecuteStream | Executes a command using the XmlCommandType and CommandText properties and returns the results in a new Stream object |
| ExecuteToStream | Executes a command using the XmlCommandType and CommandText properties and appends the results as an XML document to the existing Stream |
| ExecuteXmlReader | Executes a command using the XmlCommandType and CommandText properties and returns the result as an XML document in a .NET XmlTextReader object |
| ExecuteXmlReaderAsync | Returns a Task-based asynchronous version of OracleCommand.ExecuteXmlReader(), which fetches the result set as an XmlReader object (Overloaded) |
GetHashCode |
Inherited from System.Object |
GetLifetimeService |
Inherited from System.MarshalByRefObject |
GetType |
Inherited from System.Object |
InitializeLifetimeService |
Inherited from System.MarshalByRefObject |
| Prepare | This method is a no-op |
| SetParametersForExecuteStatements | Binds a JSON stream of parameters for SQL script execution |
ToString |
Inherited from System.Object |