Export (0) Print
Expand All

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:

using System.Data.OracleClient;

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.

Related Sections

What's New in ADO.NET

Introduces new features in ADO.NET.

Overview of ADO.NET

Provides an introduction to the design and components of ADO.NET.

Securing ADO.NET Applications

Describes secure coding practices when using ADO.NET.

Using DataSets in ADO.NET

Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

Connecting and Retrieving Data in ADO.NET

Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.

Modifying Data in ADO.NET

Describes how to modify data in a database and how to use transactions.

Using the .NET Framework Data Provider for SQL Server

Describes how to work with features and functionality that are specific to SQL Server.

Using SQL Server Common Language Runtime Integration

Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server 2005.

Writing Provider-Independent Code in ADO.NET

Describes generic classes that allow you to write provider-independent code in ADO.NET.

Performing General Tasks in ADO.NET

Describes how to use various general-purpose features of ADO.NET.

Finding Additional ADO.NET Information

Provides links to additional online information about ADO.NET.

See Also

Other Resources

ADO.NET

Community Additions

ADD
Show:
© 2014 Microsoft