OracleCommand Public Methods

OracleCommand public methods are listed in Table 6-16.

Table 6-16 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)

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

ToString

Inherited from System.Object