Skip Headers

Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1)

Part Number B10117-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ODP.NET Assembly

Oracle.DataAccess.dll assembly provides two namespaces:

Oracle.DataAccess.Client Classes and Enumerations

This namespace is the Oracle Data Provider for .NET (ODP.NET).

Table 1-1 lists the client classes:

Table 1-1 Oracle.DataAccess.Client Classes

Class Description
OracleCommand Class
An OracleCommand object represents a SQL command, a stored procedure, or a table name
OracleCommandBuilder Class
An OracleCommandBuilder object provides automatic SQL generation for the OracleDataAdapter when updates are made to the database
OracleConnection Class
An OracleConnection object represents a connection to an Oracle database
OracleDataAdapter Class
An OracleDataAdapter object represents a data provider object that communicates with the DataSet
OracleDataReader Class
An OracleDataReader object represents a forward-only, read-only, in-memory result set
OracleError Class
The OracleError object represents an error reported by an Oracle database
OracleErrorCollection Class
An OracleErrorCollection object represents a collection of OracleErrors
OracleException Class
The OracleException object represents an exception that is thrown when Oracle Data Provider for .NET encounters an error
OracleFailoverEventArgs Class
The OracleFailoverEventArgs object provides event data for the OracleConnection.Failover event
OracleFailoverEventHandler Delegate The OracleFailoverEventHandler delegate represents the signature of the method that handles the OracleConnection.Failover event
OracleGlobalization Class
The OracleGlobalization class is used to obtain and set the Oracle globalization settings of the session, thread, and local computer (read-only)
OracleInfoMessageEventHandler Delegate
The OracleInfoMessageEventHandler delegate represents the signature of the method that handles the OracleConnection.InfoMessage event
OracleInfoMessageEventArgs Class
The OracleInfoMessageEventArgs object provides event data for the OracleConnection.InfoMessage event
OracleParameter Class
An OracleParameter object represents a parameter for an OracleCommand
OracleParameterCollection Class
An OracleParameterCollection object represents a collection of OracleParameters
OracleRowUpdatedEventArgs Class
The OracleRowUpdatedEventArgs object provides event data for the OracleDataAdapter.RowUpdated event
OracleRowUpdatedEventHandler Delegate
The OracleRowUpdatedEventHandler delegate represents the signature of the method that handles the OracleDataAdapter.RowUpdated event
OracleRowUpdatingEventArgs Class
The OracleRowUpdatingEventArgs object provides event data for the OracleDataAdapter.RowUpdating event
OracleRowUpdatingEventHandler Delegate
The OracleRowUpdatingEventHandler delegate represents the signature of the method that handles the OracleDataAdapter.RowUpdating event
OracleTransaction Class
An OracleTransaction object represents a local transaction
OracleXmlQueryProperties Class
An OracleXmlQueryProperties object represents the XML properties used by the OracleCommand class when the XmlCommandType property is Query
OracleXmlSaveProperties Class
An OracleXmlSaveProperties object represents the XML properties used by the OracleCommand class when the XmlCommandType property is Insert, Update, or Delete

Table 1-2 lists the client enumerations:

Table 1-2 Oracle.DataAccess.Client Enumerations

Enumeration Description
FailoverEvent Enumeration
FailoverEvent enumerated values are used to explicitly specify the state of the failover
FailoverReturnCode Enumeration
FailoverReturnCode enumerated values are passed back by the application to the ODP.NET provider to request a retry in case of a failover error or to continue in case of a successful failover
FailoverType Enumeration
FailoverType enumerated values are used to indicate the type of failover event that was raised
OracleDbType Enumeration
OracleDbType enumerated values are used to explicitly specify the OracleDbType of an OracleParameter
OracleParameterStatus Enumeration
The OracleParameterStatus enumeration type indicates whether a NULL value is fetched from a column, whether truncation has occurred during the fetch, or whether a NULL value is to be inserted into a database column
OracleXmlCommandType Enumeration
The OracleXmlCommandType enumeration specifies the values that are allowed for the OracleXmlCommandType property of the OracleCommand class

Oracle.DataAccess.Types Classes and Structures

The Oracle.DataAccess.Types namespace provides classes and structures for Oracle native types that can be used with Oracle Data Provider for .NET.

Table 1-3 lists the types structures:

Table 1-3 Oracle.DataAccess.Types Structures

Structure Description
OracleBinary Structure
The OracleBinary structure represents a variable-length stream of binary data
OracleDate Structure
The OracleDate structure represents the Oracle DATE datatype
OracleDecimal Structure
The OracleDecimal structure represents an Oracle NUMBER in the database or any Oracle numeric value
OracleIntervalDS Structure
The OracleIntervalDS structure represents the Oracle INTERVAL DAY TO SECOND datatype
OracleIntervalYM Structure
The OracleIntervalYM structure represents the Oracle INTERVAL YEAR TO MONTH datatype
OracleString Structure
The OracleString structure represents a variable-length stream of characters
OracleTimeStamp Structure
The OracleTimeStamp structure represents the Oracle TimeStamp datatype
OracleTimeStampLTZ Structure
The OracleTimeStampLTZ structure represents the Oracle TIMESTAMP WITH LOCAL TIME ZONE data type
OracleTimeStampTZ Structure
The OracleTimeStampTZ structure represents the Oracle TIMESTAMP WITH TIME ZONE data type

Type Exceptions are thrown only by ODP.NET type structures. Table 1-4 lists the type exceptions:

Table 1-4 Oracle.DataAccess.Types Exceptions

Exception Description
OracleTypeException Class
The OracleTypeException object is the base exception class for handling exceptions that occur in the ODP.NET Type classes
OracleNullValueException Class
The OracleNullValueException represents an exception that is thrown when trying to access an ODP.NET Type structure that is null
OracleTruncateException Class
The OracleTruncateException class represents an exception that is thrown when truncation in an ODP.NET Type class occurs

Table 1-5 lists the types classes:

Table 1-5 Oracle.DataAccess.Types Classes

Class Description
OracleBFile Class
An OracleBFile is an object that has a reference to BFILE data. It provides methods for performing operations on BFiles
OracleBlob Class
An OracleBlob object is an object that has a reference to BLOB data. It provides methods for performing operations on BLOBs
OracleClob Class
An OracleClob is an object that has a reference to CLOB data. It provides methods for performing operations on CLOBs
OracleRefCursor Class
An OracleRefCursor object represents an Oracle REF CURSOR
OracleXmlStream Class
An OracleXmlStream object represents a sequential read-only stream of XML data stored in an OracleXmlType object
OracleXmlType Class
An OracleXmlType object represents an Oracle XmlType instance