No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions

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

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

ODP.NET for Microsoft OracleClient Developers Home