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	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	OracleConfiguration class	Most members not supported in ODP.NET, Unmanaged Driver only
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	EnlistDistributedTransaction(ITransaction) method Not supported in ODP.NET Core only
Oracle.ManagedDataAccess.Client	OracleConnection class	ChunkMigrationConnectionTimeout, KeepAlive, KeepAliveInterval, KeepAliveTime, TnsAdmin, and WalletLocation Not supported in ODP.NET Unmanaged Driver only
Oracle.ManagedDataAccess.Client	OracleConnectionType enumeration	All
Oracle.ManagedDataAccess.Client	OracleDataSourceCollection class	Not supported in ODP.NET Unmanaged Driver only
Oracle.ManagedDataAccess.Client	OracleDBShutdownMode enumeration	All
Oracle.ManagedDataAccess.Client	OracleDBStartupMode enumeration	All
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	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	OracleOnsServerCollection class	Not supported in ODP.NET Unmanaged Driver only
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.Client	IOracleCustomType interface	Equivalent functionality available in all providers with differences in parameters.
Oracle.ManagedDataAccess.Types	OracleRef class	The following unmanaged ODP.NET class members are not supported in managed and core: Constructors OracleRef(OracleConnection conn, string udtTypeName, string objTableName) OracleRef(OracleConnection conn, string hexStr) Methods Flush() GetCustomObject(OracleUdtFetchOption fetchOption, int depthLevel) GetCustomObjectForUpdate(bool bWait) GetCustomObjectForUpdate(bool bWait, int depthLevel) Lock(bool bWait) Properties HasChanges {get} ObjectTableName {get}
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 providers have same APIs or equivalent APIs with differences in parameters.

See Also:

Oracle Data Provider for .NET, Managed Driver Configuration and Configuration Differences among ODP.NET Drivers 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.