DataDirect Connect - Competitive Advantage Matrix for ADO.net vs Oracle Providers

DataDirect Connect for ADO.NET

Oracle Providers

100% Managed Code Benefits

100% managed code

Oracle providers are not 100% managed code. As such, they rely on the native database client.

Managed code eliminates calls outside the CLR providing better performance, scalability, security and reliability.

No database clients required

Oracle providers require native database clients installed.

Cost to develop, test and deploy are significantly reduced since the database client is not needed. In addition, application issues relating to client version conflicts are eliminated.

Complete interoperability between a variety of Oracle versions (and across other databases including Sybase, DB2 and more.)

Oracle offers three providers; one supports Oracle 8i, one supports 9i and the other supports Oracle 10g. These providers are not interoperable between databases or database versions.

Interoperability between databases and versions reduces development, testing and deployment cost, and reduces incidence of "vendor lock-in".

Robust functionality

Oracle providers lack critical functionality, including distributed transaction support.

100% managed code offers robust functionality, ensuring that your application can withstand the most demanding set of data provisioning requirements.