Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

System.Data.OracleClient Namespace

 

The System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle.

ClassDescription
System_CAPS_pubclassOracleBFile

Represents a managed OracleBFile object designed to work with the Oracle BFILE data type. This class cannot be inherited.

System_CAPS_pubclassOracleClientFactory

Obsolete. Represents a set of methods for creating instances of the Oracle provider's implementation of the data source classes.

System_CAPS_pubclassOracleCommand

Obsolete. Represents an SQL statement or stored procedure to execute against a database. This class cannot be inherited.

System_CAPS_pubclassOracleCommandBuilder

Obsolete. Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited.

System_CAPS_pubclassOracleConnection

Obsolete. Represents an open connection to a database. This class cannot be inherited.

System_CAPS_pubclassOracleConnectionStringBuilder

Obsolete. Provides a simple way to create and manage the contents of connection strings used by the OracleConnection class.

System_CAPS_pubclassOracleDataAdapter

Obsolete. 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.

System_CAPS_pubclassOracleDataReader

Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

System_CAPS_pubclassOracleException

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.

System_CAPS_pubclassOracleInfoMessageEventArgs

Provides data for the InfoMessage event. This class cannot be inherited.

System_CAPS_pubclassOracleLob

Represents a large object binary (LOB) data type stored on an Oracle server. This class cannot be inherited.

System_CAPS_pubclassOracleParameter

Represents a parameter to an OracleCommand and optionally its mapping to a DataColumn. This class cannot be inherited.

System_CAPS_pubclassOracleParameterCollection

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.

System_CAPS_pubclassOraclePermission

Obsolete. Enables the .NET Framework Data Provider for Oracle to help ensure that a user has a security level adequate to access an Oracle database.

System_CAPS_pubclassOraclePermissionAttribute

Obsolete. Associates a security action with a custom security attribute.

System_CAPS_pubclassOracleRowUpdatedEventArgs

Provides data for the RowUpdated event. This class cannot be inherited.

System_CAPS_pubclassOracleRowUpdatingEventArgs

Provides data for the RowUpdating event.

System_CAPS_pubclassOracleTransaction

Represents a transaction to be made in the database.

StructureDescription
System_CAPS_pubstructureOracleBinary

Represents a variable-length stream of binary data to be stored in or retrieved from a database.

System_CAPS_pubstructureOracleBoolean

Represents the value returned from a database comparison operation between Oracle data types, and exposes methods used to perform data type conversions.

System_CAPS_pubstructureOracleDateTime

Represents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD.

System_CAPS_pubstructureOracleMonthSpan

Represents a time interval in months and corresponds to the Oracle 9i INTERVAL YEAR TO MONTH data type.

System_CAPS_pubstructureOracleNumber

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.

System_CAPS_pubstructureOracleString

Represents a variable-length stream of characters to be stored in or retrieved from the database.

System_CAPS_pubstructureOracleTimeSpan

Represents a time interval and corresponds to the Oracle 9i INTERVAL DAY TO SECOND data type.

DelegateDescription
System_CAPS_pubdelegateOracleInfoMessageEventHandler

Represents the method that will handle the InfoMessage event of an OracleConnection.

System_CAPS_pubdelegateOracleRowUpdatedEventHandler

Represents the method that will handle the RowUpdated event of an OracleDataAdapter.

System_CAPS_pubdelegateOracleRowUpdatingEventHandler

Represents the method that will handle the RowUpdating event of an OracleDataAdapter.

EnumerationDescription
System_CAPS_pubenumOracleLobOpenMode

Specifies whether an OracleLob should be opened in read-only or read/write mode.

System_CAPS_pubenumOracleType

Specifies the data type of a field or property for use in an OracleParameter.

This types in System.Data.OracleClient are deprecated and will be removed in a future version of the .NET Framework. For more information, see Oracle and ADO.NET.

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.

System_CAPS_noteNote

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.

Return to top
Show: