1.4 Differences between the ODP.NET Drivers

ODP.NET, Managed Driver, ODP.NET, Unmanaged Driver, and ODP.NET Core have a number of configuration setting differences.

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

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	OracleClientFactory class	Not supported in ODP.NET Core only
Oracle.ManagedDataAccess.Client	OracleCommand class	ArrayBindRowsAffected property
Oracle.ManagedDataAccess.Client	OracleCommand class	ImplicitRefCursors 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	SetShardingKey method
Oracle.ManagedDataAccess.Client	OracleConnection class	EnlistDistributedTransaction(ITransaction) method Not supported in ODP.NET Core only
Oracle.ManagedDataAccess.Client	OracleConnectionType enumeration	All
Oracle.ManagedDataAccess.Client	OracleDBShutdownMode enumeration	All
Oracle.ManagedDataAccess.Client	OracleDBStartupMode enumeration	All
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	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	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	OracleNotificationRequest class	GroupingInterval property
Oracle.ManagedDataAccess.Client	OracleNotificationRequest class	GroupingNotificationEnabled property
Oracle.ManagedDataAccess.Client	OracleNotificationRequest class	GroupingType property
Oracle.ManagedDataAccess.Client	OraclePermission class	Not supported in ODP.NET Core only
Oracle.ManagedDataAccess.Client	OraclePermissionAttribute class	Not supported in ODP.NET Core only
Oracle.ManagedDataAccess.Client	OracleRowsCopiedEventArgs class	All
Oracle.ManagedDataAccess.Client	OracleRowsCopiedEventHandler 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	OracleCustomTypeMappingAttribute class	All
Oracle.ManagedDataAccess.Types	OracleObjectMappingAttribute class	All
Oracle.ManagedDataAccess.Types	OracleRef class	All
Oracle.ManagedDataAccess.Types	OracleShardingKey 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

ODP.NET Core supports the OracleConfiguration , OracleDataSourceCollection, and OracleOnsServerCollection classes, which are not present in managed nor unmanaged ODP.NET.

See Also:

Oracle Data Provider for .NET, Managed Driver Configuration and Configuration differences between ODP.NET, Managed Driver and ODP.NET, Unmanaged Driver for more information about ODP.NET, Managed Driver .NET configuration settings.

Distributed Transactions for information about distributed transaction setup difference.

Oracle Data Provider for .NET Core Configuration for more information about configuring ODP.NET Core.