Using the .NET Framework Data Provider for Oracle
This section describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.
The .NET Framework Data Provider for Oracle provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for SQL Server, OLE DB, and ODBC.
To use the .NET Framework Data Provider for Oracle, an application must reference the System.Data.OracleClient namespace as follows:
You also must include a reference to the .DLL when you compile your code. For example, if you are compiling a C# program, your command line should include:
csc /r:System.Data.OracleClient.dll
In This Section
- System Requirements for the .NET Framework Data Provider for Oracle
-
Describes requirements for using the .NET Framework Data Provider for Oracle, and describes a number of issues to be aware when using it.
- Working with Oracle BFILEs
-
Describes the OracleBFile class, which is used to work with the Oracle BFILE data type.
- Working with Oracle LOBs
-
Describes the OracleLob class, which is used to work with Oracle LOB data types.
- Working with Oracle REF CURSORs
-
Describes support for the Oracle REF CURSOR data type.
- Working with OracleTypes
-
Describes structures you can use to work with Oracle data types, including OracleNumber and OracleString.
- Mapping Data Types
-
Lists Oracle data types and their mappings to the OracleDataReader.
- Enlisting in Distributed Transactions
-
Describes how the OracleConnection object automatically enlists in an existing distributed transaction if it determines that a transaction is active.