System.Data.OracleClient Namespace
The System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle.
The .NET Framework Data Provider for Oracle describes a collection of classes for accessing an Oracle data source in the managed space. Using the OracleDataAdapter class, you can fill a memory-resident DataSet, query it, and use it to update the data source.
For additional information about how to use this namespace, see the OracleDataReader, OracleCommand, and OracleConnection classes.
Note: |
|---|
For conceptual information about using this namespace when programming with the .NET Framework, see Oracle and ADO.NET. |
The .NET Framework Data Provider for Oracle supports a number of Oracle data types, including the BFILE, LOB, and REF CURSOR data types. For information about using Oracle data types in parameters, see OracleType.
| Class | Description | |
|---|---|---|
![]() | OracleBFile | Represents a managed OracleBFile object designed to work with the Oracle BFILE data type. This class cannot be inherited. |
![]() | OracleClientFactory | Represents a set of methods for creating instances of the Oracle provider's implementation of the data source classes. |
![]() | OracleCommand | Represents an SQL statement or stored procedure to execute against a database. This class cannot be inherited. |
![]() | OracleCommandBuilder | Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited. |
![]() | OracleConnection | Represents an open connection to a database. This class cannot be inherited. |
![]() | OracleConnectionStringBuilder | Provides a simple way to create and manage the contents of connection strings used by the OracleConnection class. |
![]() | OracleDataAdapter | Represents a set of data commands and a connection to a database that are used to fill the DataSet and update the database. This class cannot be inherited. |
![]() | OracleDataReader | Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited. |
![]() | OracleException | The exception that is generated when a warning or error is returned by an Oracle database or the .NET Framework Data Provider for Oracle. This class cannot be inherited. |
![]() | OracleInfoMessageEventArgs | Provides data for the InfoMessage event. This class cannot be inherited. |
![]() | OracleLob | Represents a large object binary (LOB) data type stored on an Oracle server. This class cannot be inherited. |
![]() | OracleParameter | Represents a parameter to an OracleCommand and optionally its mapping to a DataColumn. This class cannot be inherited. |
![]() | OracleParameterCollection | Represents a collection of parameters relevant to an OracleCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited. |
![]() | OraclePermission | Enables the .NET Framework Data Provider for Oracle to help ensure that a user has a security level adequate to access an Oracle database. |
![]() | OraclePermissionAttribute | Associates a security action with a custom security attribute. |
![]() | OracleRowUpdatedEventArgs | Provides data for the RowUpdated event. This class cannot be inherited. |
![]() | OracleRowUpdatingEventArgs | Provides data for the RowUpdating event. |
![]() | OracleTransaction | Represents a transaction to be made in the database. |
| Structure | Description | |
|---|---|---|
![]() | OracleBinary | Represents a variable-length stream of binary data to be stored in or retrieved from a database. |
![]() | OracleBoolean | Represents the value returned from a database comparison operation between Oracle data types, and exposes methods used to perform data type conversions. |
![]() | OracleDateTime | Represents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD. |
![]() | OracleMonthSpan | Represents a time interval in months and corresponds to the Oracle 9i INTERVAL YEAR TO MONTH data type. |
![]() | OracleNumber | Represents a fixed precision and scale numeric value between -10 27 -1 and 10 27 -1 to be stored in or retrieved from a database. |
![]() | OracleString | Represents a variable-length stream of characters to be stored in or retrieved from the database. |
![]() | OracleTimeSpan | Represents a time interval and corresponds to the Oracle 9i INTERVAL DAY TO SECOND data type. |
| Delegate | Description | |
|---|---|---|
![]() | OracleInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of an OracleConnection. |
![]() | OracleRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of an OracleDataAdapter. |
![]() | OracleRowUpdatingEventHandler | Represents the method that will handle the RowUpdating event of an OracleDataAdapter. |
| Enumeration | Description | |
|---|---|---|
![]() | OracleLobOpenMode | Specifies whether an OracleLob should be opened in read-only or read/write mode. |
![]() | OracleType | Specifies the data type of a field or property for use in an OracleParameter. |
Note:


