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