Permalink
Fetching contributors…
Cannot retrieve contributors at this time
86 lines (64 sloc) 4.71 KB
title ms.custom ms.date ms.prod ms.reviewer ms.suite ms.technology ms.tgt_pltfrm ms.topic ms.assetid caps.latest.revision author ms.author manager
Oracle and ADO.NET
03/30/2017
.net-framework
dotnet-ado
article
8ee8e389-53cf-45cf-80bd-1df63ef34f2e
4
JennieHubbard
jhubbard
jhubbard

Oracle and ADO.NET

[!NOTE] The types in xref:System.Data.OracleClient are deprecated. The types remain supported in the current version of.NET Framework but will be removed in a future release. Microsoft recommends that you use a third-party Oracle provider.

This section describes features and behaviors that are specific to the [!INCLUDEdnprdnshort] Data Provider for Oracle.

The [!INCLUDEdnprdnshort] 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 [!INCLUDEdnprdnshort] data providers for [!INCLUDEssNoVersion], OLE DB, and ODBC.

To use the [!INCLUDEdnprdnshort] Data Provider for Oracle, an application must reference the xref:System.Data.OracleClient namespace as follows:

Imports System.Data.OracleClient  
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
Describes requirements for using the [!INCLUDEdnprdnshort] Data Provider for Oracle, and describes a number of issues to be aware when using it.

Oracle BFILEs
Describes the xref:System.Data.OracleClient.OracleBFile class, which is used to work with the Oracle BFILE data type.

Oracle LOBs
Describes the xref:System.Data.OracleClient.OracleLob class, which is used to work with Oracle LOB data types.

Oracle REF CURSORs
Describes support for the Oracle REF CURSOR data type.

OracleTypes
Describes structures you can use to work with Oracle data types, including xref:System.Data.OracleClient.OracleNumber and xref:System.Data.OracleClient.OracleString.

Oracle Sequences
Describes support for retrieving the server-generated key Oracle Sequence values.

Oracle Data Type Mappings
Lists Oracle data types and their mappings to the xref:System.Data.OracleClient.OracleDataReader.

Oracle Distributed Transactions
Describes how the xref:System.Data.OracleClient.OracleConnection object automatically enlists in an existing distributed transaction if it determines that a transaction is active.

Related Sections

Securing ADO.NET Applications
Describes secure coding practices when using [!INCLUDEvstecado].

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

Retrieving and Modifying Data in ADO.NET
Describes how to work with data in ADO.NET.

SQL Server and ADO.NET
Describes how to work with features and functionality that are specific to [!INCLUDEssNoVersion].

DbProviderFactories
Describes generic classes that allow you to write provider-independent code in [!INCLUDEvstecado].

See Also

ADO.NET
ADO.NET Managed Providers and DataSet Developer Center