Technical Comparison: ODP.NET Versus Microsoft OracleClient

Performance

Feature	ODP.NET	Microsoft OracleClient
Statement Caching	Yes	No
Fine Grain Contol Over Data Fetch Size	Yes	No
Parameter Array Binding	Yes	No
Performance Counters	Yes	Yes
Self-Tuning	Yes	No
Promotable Transactions	Yes	No
Local Transactions in System.Transactions	Yes	No
LOB pre-fetching	Yes	No
PL/SQL Associative Array	Yes	No
Bulk Copy	Yes	No

Security

Feature	ODP.NET	Microsoft OracleClient
Proxy Authentication	Yes	No
Virtual Private Database	Yes	No
End to End Tracing Attributes	Yes	No

High Availability and Scalability

Feature	ODP.NET	Microsoft OracleClient
RAC and Data Guard Connection Pooling: Fast Connection Failover	Yes	No
RAC Connection Pool: Connection Load Balancing	Yes	No
Transparent Application Failover Callbacks	Yes	No

Oracle Database Technology

Feature	ODP.NET	Microsoft OracleClient
PL/SQL Support	Yes	Yes
REF CURSOR Type	Yes	Partial
Oracle Complex Types: XML , OBJECT, VARRAY, NESTED TABLE, REF	Yes	No
Client Result Cache	Yes	Yes
Database Change Notification	Yes	No
Advanced Queueing API	Yes	No

Ease of Use and Developer Productivity

Feature	ODP.NET	Microsoft OracleClient
ASP.NET Providers: Membership, Role, Session State, Profile, Site Map, Web Events, Web Parts Personalization, Cache Dependency	Yes	No
Xcopy Deployable	Yes	Yes
Factory Classes	Yes	Yes
Supports All .NET Framework Versions	Yes	Yes
Globalization Settings on Session, Thread, and Local Computer	Yes	No
Data Source Enumerator	Yes	No

ODP.NET for Microsoft OracleClient Developers Home

E-mail this page

Printer View

Oracle Cloud

Java

Customer and Events

Communities

Services and Store

Log In to My Oracle Support
Training and Certification
Become a Partner
Find a Partner Solution
Purchase from the Oracle Store
Contact and Chat
Global Contacts
Oracle Support
Phone: 800-633-0738

Hardware and Software, Engineered to Work Together