Oracle® Data Provider for .NET Developer's Guide 10g Release 1 (10.1) Part Number B10117-01 |
|
|
View PDF |
Oracle.DataAccess.dll
assembly provides two namespaces:
The Oracle.DataAccess.Client
namespace contains ODP.NET classes and enumerations.
The Oracle.DataAccess.Types
namespace contains the Oracle Data Provider for .NET Types (ODP.NET Types).
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 OracleError s |
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 OracleParameter s |
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 |
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 BFile s |
OracleBlob Class |
An OracleBlob object is an object that has a reference to BLOB data. It provides methods for performing operations on BLOB s |
OracleClob Class |
An OracleClob is an object that has a reference to CLOB data. It provides methods for performing operations on CLOB s |
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 |