6.12.1 OracleDataReader Members

OracleDataReader members are listed in the following tables.

OracleDataReader Static Methods

The OracleDataReader static method is listed in Table 6-73.

Table 6-73 OracleDataReader Static Method

Method	Description
Equals	Inherited from System.Object (Overloaded)

OracleDataReader Properties

OracleDataReader properties are listed in Table 6-74.

Table 6-74 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.
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-75.

Table 6-75 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	Not Supported
GetByte	Returns the byte value of the specified column
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
GetDecimal	Returns the decimal value of the specified NUMBER column
GetDouble	Returns the double value of the specified NUMBER column or BINARY_DOUBLE column
GetEnumerator	Returns an IEnumerator that can be used to iterate through the collection
GetFieldType	Returns the Type of the specified column
GetFloat	Returns the float value of the specified NUMBER column or BINARY_FLOAT column
GetGuid	Not Supported
GetHashCode	Inherited from System.Object
GetInt16	Returns the Int16 value of the specified NUMBER 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
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 OracleBlob object of the specified BLOB column Not Available in ODP.NET, Managed Driver and ODP.NET Core
GetOracleClob	Returns an OracleClob object of the specified CLOB column
GetOracleClobForUpdate	Returns an updatable OracleClob object of the specified CLOB column Not Available in ODP.NET, Managed Driver and ODP.NET Core
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 Not Available in ODP.NET, Managed Driver and ODP.NET Core
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
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
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
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
NextResult	Advances the data reader to the next result set when reading the results
Read	Reads the next row in the result set
ToString	Inherited from System.Object

See Also:

• "Oracle.DataAccess.Client and Oracle.ManagedDataAccess.Client Namespaces"

• OracleDataReader Class