Differences between the ODP.NET Managed Driver and Unmanaged Driver

ODP.NET, Managed Driver and ODP.NET, Unmanaged Driver have a number of configuration setting differences. To learn more about ODP.NET, Managed Driver .NET configuration settings, refer to "Oracle Data Provider for .NET, Managed Driver Configuration" and "Configuration differences between ODP.NET, Managed Driver and ODP.NET, Unmanaged Driver."

For distributed transaction setup difference, see "Using Oracle Services for MTS with Oracle Data Provider for .NET, Managed Driver."

Table 1-8 list the application programming interfaces not supported in ODP.NET, Managed Driver.

Table 1-8 Application Programming Interfaces not supported in ODP.NET, Managed Driver

Namespace Class/Enumeration/Interface Unsupported Method/Property/Event

Oracle.ManagedDataAccess.Client

FailoverEvent enumeration

All

Oracle.ManagedDataAccess.Client

FailoverReturnCode enumeration

All

Oracle.ManagedDataAccess.Client

FailoverType enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQAgent class

All

Oracle.ManagedDataAccess.Client

OracleAQDequeueuMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQDequeueOptions class

All

Oracle.ManagedDataAccess.Client

OracleAQEnqueueOptions class

All

Oracle.ManagedDataAccess.Client

OracleAQMessage class

All

Oracle.ManagedDataAccess.Client

OracleAQMessageAvailableEventArgs class

All

Oracle.ManagedDataAccess.Client

OracleAQMessageAvailableEventHandler class

All

Oracle.ManagedDataAccess.Client

OracleAQMessageDeliveryMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQMessageState enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQMessageType enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQNavigationMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQNotificationGroupingType enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQNotificationType enumeration

All

Oracle.ManagedDataAccess.Client

OracleAQQueue class

All

Oracle.ManagedDataAccess.Client

OracleAQVisibilityMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleBulkCopy class

All

Oracle.ManagedDataAccess.Client

OracleBulkCopyColumnMapping class

All

Oracle.ManagedDataAccess.Client

OracleBulkCopyColumnMappingCollection class

All

Oracle.ManagedDataAccess.Client

OracleBulkCopyOptions class

All

Oracle.ManagedDataAccess.Client

OracleCommand class

ArrayBindRowsAffected property

Oracle.ManagedDataAccess.Client

OracleCommand class

ImplicitRefCursors property

Oracle.ManagedDataAccess.Client

OracleCommand class

XmlCommandType property

Oracle.ManagedDataAccess.Client

OracleCommand class

XmlQueryProperties property

Oracle.ManagedDataAccess.Client

OracleCommand class

XmlSaveProperties property

Oracle.ManagedDataAccess.Client

OracleConnection class

FlushCache() method

Oracle.ManagedDataAccess.Client

OracleConnection class

Failover event

Oracle.ManagedDataAccess.Client

OracleConnection class

ConnectionType property

Oracle.ManagedDataAccess.Client

OracleConnection class

GetLogicalTransactionStatus() method

Oracle.ManagedDataAccess.Client

OracleConnection class

LogicalTransactionId property

Oracle.ManagedDataAccess.Client

OracleConnectionType enumeration

All

Oracle.ManagedDataAccess.Client

OracleDBShutdownMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleDBStartupMode enumeration

All

Oracle.ManagedDataAccess.Client

OracleDBType enumeration

XmlType

Oracle.ManagedDataAccess.Client

OracleDataReader class

GetOracleRef() method

Oracle.ManagedDataAccess.Client

OracleDataReader class

GetOracleBlobForUpdate() method

If the method is called, then a NotSupportedException is thrown.

Oracle.ManagedDataAccess.Client

OracleDataReader class

GetOracleClobForUpdate() method

If the method is called, then a NotSupportedException is thrown.

Oracle.ManagedDataAccess.Client

OracleDataReader class

GetXmlReader() method

If the method is called, then a NotSupportedException is thrown.

Oracle.ManagedDataAccess.Client

OracleDataReader class

GetOracleXmlType() method

Oracle.ManagedDataAccess.Client

OracleDataReader class

IsAutoIncrement and IdentityType properties of the GetSchemaTable

Oracle.ManagedDataAccess.Client

OracleDataAdapter class

IdentityInsert property

Oracle.ManagedDataAccess.Client

OracleDataAdapter class

IdentityUpdate property

Oracle.ManagedDataAccess.Client

OracleDataAdapter class

SafeMapping property

Oracle.ManagedDataAccess.Client

OracleDatabase class

All

Oracle.ManagedDataAccess.Client

OracleDbType enumeration

Array

Oracle.ManagedDataAccess.Client

OracleDbType enumeration

Boolean

Oracle.ManagedDataAccess.Client

OracleDbType enumeration

Object

Oracle.ManagedDataAccess.Client

OracleDbType enumeration

Ref

Oracle.ManagedDataAccess.Client

OracleException class

IsRecoverable property

Oracle.ManagedDataAccess.Client

OracleFailoverEventArgs class

All

Oracle.ManagedDataAccess.Client

OracleFailoverEventHandler class

All

Oracle.ManagedDataAccess.Client

OracleGlobalization class

ClientCharacterSet property

Oracle.ManagedDataAccess.Client

OracleGlobalization class

GetClientInfo() method

Oracle.ManagedDataAccess.Client

OracleGlobalization class

GetThreadInfo() method

Oracle.ManagedDataAccess.Client

OracleGlobalization class

SetThreadInfo() method

Oracle.ManagedDataAccess.Client

OracleIdentityType enumeration

All

Oracle.ManagedDataAccess.Client

OracleLogicalTransactionStatus class

All

Oracle.ManagedDataAccess.Client

OracleNotificationRequest class

GroupingInterval property

Oracle.ManagedDataAccess.Client

OracleNotificationRequest class

GroupingNotificationEnabled property

Oracle.ManagedDataAccess.Client

OracleNotificationRequest class

GroupingType property

Oracle.ManagedDataAccess.Client

OracleRowsCopiedEventArgs class

All

Oracle.ManagedDataAccess.Client

OracleRowsCopiedEventHandler class

All

Oracle.ManagedDataAccess.Client

OracleXmlCommandType enumeration

All

Oracle.ManagedDataAccess.Client

OracleXmlQueryProperties class

All

Oracle.ManagedDataAccess.Client

OracleXmlSaveProperties class

All

Oracle.ManagedDataAccess.Types

IOracleArrayTypeFactory interface

All

Oracle.ManagedDataAccess.Types

IOracleCustomType interface

All

Oracle.ManagedDataAccess.Types

IOracleCustomTypeFactory interface

All

Oracle.ManagedDataAccess.Types

OracleArrayMappingAttribute class

All

Oracle.ManagedDataAccess.Types

OracleBoolean structure

All

Oracle.ManagedDataAccess.Types

OracleCustomTypeMappingAttribute class

All

Oracle.ManagedDataAccess.Types

OracleObjectMappingAttribute class

All

Oracle.ManagedDataAccess.Types

OracleRef class

All

Oracle.ManagedDataAccess.Types

OracleTimestampTZ structure

OracleTimeStampTZ(DateTime dt, string timeZone) constructor. This constructor is supported but the timeZone must be an hour offset.

Oracle.ManagedDataAccess.Types

OracleUdt class

All

Oracle.ManagedDataAccess.Types

OracleUdtFetchOption enumeration

All

Oracle.ManagedDataAccess.Types

OracleUdtStatus enumeration

All

Oracle.ManagedDataAccess.Types

OracleXmlStream class

All

Oracle.ManagedDataAccess.Types

OracleXmlType class

All