OracleDataReader Members
OracleDataReader members are listed in the following tables.
OracleDataReader Static Methods
The OracleDataReader static method is listed in Table 6-81.
Table 81 OracleDataReader Static Method
| Method | Description |
|---|---|
Equals |
Inherited from System.Object (Overloaded) |
OracleDataReader Properties
OracleDataReader properties are listed in Table 6-82.
Table 82 OracleDataReader Properties
| Property | Description |
|---|---|
| Depth | Gets a value indicating the depth of nesting for the current row |
| FetchSize | Specifies the size of OracleDataReader’s internal cache |
| FieldCount | Gets the number of columns in the result set |
| HasRows | Indicates whether the OracleDataReader has one or more rows |
| HiddenFieldCount | Gets the number of fields in the OracleDataReader that are hidden |
| IsClosed | Indicates whether or not the data reader is closed |
| Item | Gets the value of the column (Overloaded) |
| InitialLOBFetchSize | Specifies the amount that the OracleDataReader initially fetches for LOB columns |
| InitialLONGFetchSize | Specifies the amount that the OracleDataReader initially fetches for LONG and LONG RAW columns |
| RecordsAffected | Gets the number of rows changed, inserted, or deleted by execution of the SQL statement |
| RowSize | Gets the amount of memory the internal cache of the OracleDataReader needs 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 |
| SuppressGetDecimalInvalidCastException | Specifies whether to suppress the InvalidCastException and return a rounded-off 28 precision value if the Oracle NUMBER value has more than 28 precision. |
| UseEdmMapping | Indicates whether or not the OracleDataReader utilizes the Entity Data Model mapping configuration when returning values |
| VisibleFieldCount | Gets the number of fields in the OracleDataReader that are not hidden |
OracleDataReader Public Methods
OracleDataReader public methods are listed in Table 6-83.
Table 83 OracleDataReader Public Methods
| Public Method | Description |
|---|---|
| Close | Closes the OracleDataReader |
CreateObjRef |
Inherited from System.MarshalByRefObject |
| Dispose | Releases any resources or memory allocated by the object |
Equals |
Inherited from System.Object (Overloaded) |
| GetBoolean | Returns the bool value of the specified numeric column |
| GetByte | Returns the byte value of the specified column |
| GetByteArray(int) | Returns the byte array value of the specified numeric column Not Available in ODP.NET, Unmanaged Driver |
| GetByteArray(string) | Returns the byte array value of the specified numeric column Not Available in ODP.NET, Unmanaged Driver |
| GetBytes | Populates the provided byte array with up to the maximum number of bytes, from the specified offset (in bytes) of the column |
| GetChar | Not Supported |
| GetChars | Populates the provided character array with up to the maximum number of characters, from the specified offset (in characters) of the column |
| GetData | Not Supported |
| GetDataTypeName | Returns the ODP.NET type name of the specified column |
| GetDateTime | Returns the DateTime value of the specified column |
| GetDateTimeOffset | Returns the DateTimeOffset value of the specified column |
| GetDecimal | Returns the decimal value of the specified NUMBER column |
| GetDouble | Returns the double value of the specified NUMBER column or BINARY_DOUBLE column |
| GetDoubleArray(int) | Returns the double[] value of the specified VECTOR column |
| GetDoubleArray(string) | Returns the double[] value of the specified VECTOR column |
| GetEnumerator | Returns an IEnumerator that can be used to iterate through the collection |
| GetFieldType | Returns the Type of the specified column |
| GetFieldValueAsync | Returns a Task-based asynchronous version of OracleDataReader.GetFieldValue(), which returns the column value as a specified type (Overloaded) |
| GetFloat | Returns the float value of the specified NUMBER column or BINARY_FLOAT column |
| GetFloatArray(int) | Returns the float[] value of the specified VECTOR column |
| GetFloatArray(string) | Returns the float[] value of the specified VECTOR column |
| GetGuid | Returns the Guid value of the specified binary data column |
GetHashCode |
Inherited from System.Object |
| GetInt16 | Returns the Int16 value of the specified NUMBER column |
| GetInt16Array(int) | Returns the short[] value of the specified VECTOR column |
| GetInt16Array(string) | Returns the short[] value of the specified VECTOR column |
| GetInt32 | Returns the Int32 value of the specified NUMBER column |
| GetInt64 | Returns the Int64 value of the specified NUMBER column |
GetLifetimeService |
Inherited by System.MarshalByRefObject |
| GetName | Returns the name of the specified column |
| GetNonZeroDoubleArray | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroFloatArray | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroIndexArray | Returns the non-zero-dimension indices Not Available in ODP.NET, Unmanaged Driver |
| GetNonZeroInt16Array | Returns the non-zero-dimension values Not Available in ODP.NET, Unmanaged Driver |
| GetOracleBFile | Returns an OracleBFile object of the specified BFILE column |
| GetOracleBinary | Returns an OracleBinary structure of the specified column |
| GetOracleBlob | Returns an OracleBlob object of the specified BLOB column |
| GetOracleBlobForUpdate | Returns an updatable Not Available in ODP.NET, Managed Driver and ODP.NET Core |
| GetOracleBoolean(int) | Returns the OracleBoolean value of the column |
| GetOracleClob | Returns an OracleClob object of the specified CLOB column |
| GetOracleClobForUpdate | Returns an updatable Not Available in ODP.NET, Managed Driver and ODP.NET Core |
| GetOracleDataReader | Returns the Not Available in ODP.NET, Unmanaged Driver |
| GetOracleDate | Returns an OracleDate structure of the specified DATE column |
| GetOracleDecimal | Returns an OracleDecimal structure of the specified NUMBER column |
| GetOracleIntervalDS | Returns an OracleIntervalDS structure of the specified INTERVAL DAY TO SECOND column |
| GetOracleIntervalYM | Returns an OracleIntervalYM structure of the specified INTERVAL YEAR TO MONTH column |
| GetOracleRef | Returns an OracleRef object of the specified REF column |
| GetOracleRefCursor | Returns the Not Available in ODP.NET, Unmanaged Driver |
| GetOracleString | Returns an OracleString structure of the specified column |
| GetOracleTimeStamp | Returns an OracleTimeStamp structure of the Oracle TimeStamp column |
| GetOracleTimeStampLTZ | Returns an OracleTimeStampLTZ structure of the specified Oracle TimeStamp WITH LOCAL TIME ZONE column |
| GetOracleTimeStampTZ | Returns an OracleTimeStampTZ structure of the specified Oracle TimeStamp WITH TIME ZONE column |
| GetOracleXmlType | Returns an OracleXmlType object of the specified XMLType column |
| GetOracleValue | Returns the specified column value as a ODP.NET type |
| GetOracleValues | Gets all the column values as ODP.NET types |
| GetOracleVector | Returns Not Available in ODP.NET, Unmanaged Driver |
| GetOrdinal | Returns the 0-based ordinal (or index) of the specified column name |
| GetProviderSpecificFieldType | Returns the provider-specific type of the specified column |
| GetProviderSpecificValue | Returns an object that represents the underlying provider-specific value of the specified ordinal |
| GetProviderSpecificValues | Returns an array of objects that represent the underlying provider-specific values |
| GetSchemaTable | Returns a DataTable that describes the column metadata of the OracleDataReader |
| GetString | Returns the string value of the specified column. (Overloaded) |
| GetTimeSpan | Returns the TimeSpan value of the specified INTERVAL DAY TO SECOND column |
GetType |
Inherited from System.Object class |
| GetValue | Returns the column value as a .NET type |
| GetValues | Gets all the column values as .NET types |
| GetVectorDimensions | Returns the number of dimensions of the specified VECTOR column.(Overloaded) Not Available in ODP.NET, Unmanaged Driver |
| GetVectorNumericFormat(int) | Returns the OracleDbType value of the VECTOR column numeric format |
| GetVectorNumericFormat(string) | Returns the OracleDbType value of the VECTOR column numeric format |
| GetXmlReader | Returns the value of an XMLType column as an instance of an .NET XmlTextReader |
| IsDBNull | Indicates whether or not the column value is null |
| IsDBNullAsync | Returns a Task-based asynchronous version of OracleDataReader.IsDBNull() (Overloaded) |
| NextResult | Advances the data reader to the next result set when reading the results |
| NextResultAsync | Returns a Task-based asynchronous version of OracleDataReader.NextResult() (Overloaded) |
| Read | Reads the next row in the result set |
| ReadAsync | Returns a Task-based asynchronous version of OracleDataReader.Read() (Overloaded) |
ToString |
Inherited from System.Object |