Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
.NET Framework Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
.NET Framework 3.5
Collapse All/Expand All Collapse All
This page is specific to
Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:
.NET Framework Class Library
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.

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.

 Classes
  ClassDescription
Public classOracleBFileRepresents a managed OracleBFile object designed to work with the Oracle BFILE data type. This class cannot be inherited.
Public classOracleClientFactoryRepresents a set of methods for creating instances of the Oracle provider's implementation of the data source classes.
Public classOracleCommandRepresents an SQL statement or stored procedure to execute against a database. This class cannot be inherited.
Public classOracleCommandBuilderAutomatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited.
Public classOracleConnectionRepresents an open connection to a database. This class cannot be inherited.
Public classOracleConnectionStringBuilderProvides a simple way to create and manage the contents of connection strings used by the OracleConnection class.
Public classOracleDataAdapterRepresents 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.
Public classOracleDataReaderProvides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.
Public classOracleExceptionThe 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.
Public classOracleInfoMessageEventArgsProvides data for the InfoMessage event. This class cannot be inherited.
Public classOracleLobRepresents a large object binary (LOB) data type stored on an Oracle server. This class cannot be inherited.
Public classOracleParameterRepresents a parameter to an OracleCommand and optionally its mapping to a DataColumn. This class cannot be inherited.
Public classOracleParameterCollectionRepresents a collection of parameters relevant to an OracleCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.
Public classOraclePermissionEnables the .NET Framework Data Provider for Oracle to help ensure that a user has a security level adequate to access an Oracle database.
Public classOraclePermissionAttributeAssociates a security action with a custom security attribute.
Public classOracleRowUpdatedEventArgsProvides data for the RowUpdated event. This class cannot be inherited.
Public classOracleRowUpdatingEventArgsProvides data for the RowUpdating event.
Public classOracleTransactionRepresents a transaction to be made in the database.
 Structures
  StructureDescription
Public structureOracleBinaryRepresents a variable-length stream of binary data to be stored in or retrieved from a database.
Public structureOracleBooleanRepresents the value returned from a database comparison operation between Oracle data types, and exposes methods used to perform data type conversions.
Public structureOracleDateTimeRepresents date and time data ranging in value from January 1, 4712 BC to December 31, 4712 AD.
Public structureOracleMonthSpanRepresents a time interval in months and corresponds to the Oracle 9i INTERVAL YEAR TO MONTH data type.
Public structureOracleNumberRepresents a fixed precision and scale numeric value between -10 27 -1 and 10 27 -1 to be stored in or retrieved from a database.
Public structureOracleStringRepresents a variable-length stream of characters to be stored in or retrieved from the database.
Public structureOracleTimeSpanRepresents a time interval and corresponds to the Oracle 9i INTERVAL DAY TO SECOND data type.
 Delegates
  DelegateDescription
Public delegateOracleInfoMessageEventHandlerRepresents the method that will handle the InfoMessage event of an OracleConnection.
Public delegateOracleRowUpdatedEventHandlerRepresents the method that will handle the RowUpdated event of an OracleDataAdapter.
Public delegateOracleRowUpdatingEventHandlerRepresents the method that will handle the RowUpdating event of an OracleDataAdapter.
 Enumerations
  EnumerationDescription
Public enumerationOracleLobOpenModeSpecifies whether an OracleLob should be opened in read-only or read/write mode.
Public enumerationOracleTypeSpecifies the data type of a field or property for use in an OracleParameter.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
ODP.NET      Rhapsody   |   Edit   |   Show History
The Oracle Data Provider for .NET can be found here: http://www.oracle.com/technology/tech/windows/odpnet/index.html
Flag as ContentBug
DataDirect Oracle ADO.NET Provider      jonbruce_ddt   |   Edit   |   Show History
The DataDirect Oracle ADO.NET Provider provides superior connectivity to Oracle 8i thru 11gR1 free from Oracle client libraries (no Oracle Client or Instant Client), with superior performance, scabability, functionality all with 100% managed code.

dotConnect for Oracle      Devart Software   |   Edit   |   Show History
dotConnect - the best advanced ADO.NET data provider for Oracle.

Key Features: *Direct access mode (without Oracle client) *100% managed code *High performance *Easy to deploy *Supports the latest versions of Oracle server, including Personal and Express editions *All Oracle data types support *Full Oracle Objects support *Comprehensive REF CURSOR support *PL/SQL tables and PL/SQL records support *.NET Compact Framework support *Entity Framework support *LINQ to Oracle support *Operates in both connected and disconnected models *Powerful OracleDataTable component as all-in-one table data access solution *Typed OraclePackage component for wrapping PL/SQL packages *Auxiliary components for SQL scripts and bulk data transfer *Extra data binding capabilities *Cross-form components cooperation *Ability of monitoring query execution *Licensed royalty-free per developer, per team, or per site dotConnect for Oracle supports Oracle servers 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions. dotConnect for Oracle supports x86 and x64 versions of the following Oracle clients: 11g, 10g, 9i, 8i and 8.0. 2.0, 3.0, 3.5, and .NET Compact Framework. dotConnect for Oracle supports Mono version 2.0 and above. The product is compatible with the latest version of ADO.NET Entity Framework. Development environments: * Microsoft Visual Studio .NET 2002, 2003, 2005, 2008 * Turbo Delphi for .NET Professional * Turbo C# Professional * Borland Developer Studio 2006 * Borland Developer Studio 2005 * Borland Delphi 8 * Borland C#Builder

You can download it here: http://www.devart.com/dotconnect/oracle/
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker