DataDirect ADO.NET Data Provider for Oracle

The only 100% managed code Oracle provider for .NET applications connecting that delivers:

  • Best application performance and scalability for Oracle
  • No need for the Oracle OCI client libraries
  • Support for many of the latest .NET technologies, including LINQ, Entity SQL, and ADO.NET Data Services.

DataDirect Connect for ADO.NET has been thoroughly proven in data transaction intensive environments in which high performance, stability and security are mission-critical requirements.

Key Benefits

Expose the full range of Oracle features to your ADO.NET Entity Framework applications

Full Oracle feature support for the ADO.NET Entity Framework including:

  • All supported versions of the Oracle database available with a single provider
  • Support for overloaded procedures and REF CURSORS (Implicit & Explicit)
  • Support for Oracle database security features such as Transparent Data and Tablespace Encryption
  • Support for catalog features such as schemas, stored procedures, REF CURSORs, and packages
  • Support for data types such as BINARY, BINARY_DOUBLE, BINARY_FLOAT, BLOB, CLOB, and XML

Improves the performance and scalability of your applications

DataDirect ADO.NET data providers outperform other providers in throughput capacity, as well as memory and CPU utilization.

Only DataDirect providers are 100% managed, making no calls outside the .NET runtime environment. This dramatically improves application performance and scalability by eliminating reliance on components that reside outside the managed environment.

DataDirect providers also include a high-performance Bulk Load capability for loading large amounts of data into Oracle very quickly, which doesn’t require application code changes or additional bulk load tools.

Provides comprehensive database/platform coverage from one vendor

DataDirect can serve all your data connectivity needs, for any API (JDBC, ODBC, .NET) for any major database—SQL Server, Oracle, DB2, Sybase, and more, while offering extensive platform support.

Enables faster, more flexible deployment

Because it doesn’t require database client libraries, the DataDirect provider supports “side-by-side” installation, allowing you to run multiple applications using different versions of the database on the same machine. This eliminates the need to re-qualify unrelated applications if an application is updated.

Makes it easy and cost effective to support multiple databases and database versions

One DataDirect provider supports simultaneous connections to Oracle 8i, 9i, 10g, and 11g, which significantly reduces the costs of deploying and testing applications against multiple versions of Oracle and its client libraries.

Enables single sign-on and end-to-end data encryption

DataDirect providers include advanced, industry-standard security mechanisms:

  • SSL data encryption to secure the integrity of your data and provide client/server authentication
  • Operating system authentication via Kerberos, allowing you to include database access in a Single Sign-On environment

In addition, 100% managed code ensures no reliance on components outside the .NET managed environment, allowing the application to take full advantage of the security controls in .NET.

Guarantees reliability for demanding production environments

DataDirect providers are quality tested and certified using our extensive ADO.NET Verification Suite (ADOVS), verifying all supported Windows platforms and Oracle database versions. We also test ADO.NET conformance using the Microsoft LTM (Local Test Manager). This comprehensive testing ensures that you can develop the most robust Oracle .NET application.

Offers 100% specification compliance and robust functionality

DataDirect providers are certified for use with .NET Framework versions 2.0, 3.0 and 3.5 (32-bit and 64-bit), are fully compliant with ADO.NET 2.0, and offer advanced functionality such as:

Reduces total cost of ownership through superior technical support

Focused on database connectivity, our award-winning support includes 24x7 phone, web, email, forum, fax, and an extensive knowledgebase. Superior technical support is essential to resolve data connectivity issues quickly, thereby reducing the total cost of ownership of software.

Additional DataDirect Data Provider Features for Oracle:

  • Broad support for Oracle data types: all timestamp data types, NChar, NVarchar, NClob, ROWID, Binary Float, Binary Double
  • Oracle RAC support
  • TNSNAMES.ORA support
  • Tunable and fine-grained control of meta-data schema options
  • Support for Oracle-style REF Cursors – support for Oracle style REF Cursor support allows developers to use overloaded stored procedure using REF Cursors. This allows Oracle-based applications to more easily migrate to DataDirect Connect for ADO.NET.
  • Support for Oracle data types: Timestamp, Timestamp with Local Time Zone, Timestamp with Time Zone (all Timestamp data types are supported in Oracle 9i or higher only), NChar, NVarchar, NClob, and ROWID
  • Supports Oracle 10g Binary Float and Binary Double Data types
  • Ability to execute PL/SQL upon connection
  • Ability to use native Named Parameter format in stored procedure calls
  • Support for PL/SQL Associative Arrays (Table type) as input parameters to Stored Procedures
  • Support for multiple TNS Names files for failover purposes
  • Supports the ability to execute a single SQL statement using multiple rows of values
  • Tuning options to control the amount of data that is returned across the network on single roundtrips from the Oracle server
  • Asynchronous Commit Functionality – Control whether aspects of a commit operation are performed synchronously or asynchronously. This capability provides better control so the developer can make trade-offs between transaction control and application response time.
  • SYSDBA / SYSOPER login support – Associates the SYSDBA and / or SYSOPER role with a user. This is necessary since some database operations require privileged access.
  • "Support Links" support – Designates whether a data source can be enlisted in a distributed transaction. The developer can now specify this enabling better control over distributed transactions and offers the potential for computer resource savings.
  • Expired password support – To better support situations where a password is expired, you can provide an alternate password as part of the connection string. If the primary password has been expired, the provider will attempt to connect using the alternate password.
  • TCPS support for TNSNAMES.ora
  • Support for statement caching for increased efficiency between Oracle database and .NET application
  • Additional connection tuning options – Array Send Size, Socket Send Buffer Size, Socket Receive Buffer Size
  • Connection Statistics and Client Monitoring Information
  • Server-side result set caching to boost performance for specific application operations connecting to Oracle 11g without changes to the application code
  • Transparent Data and Tablespace Encryption support
  • SECUREFILE LOB Storage support
  • Transaction Timeout – Configure a specific transaction timeout time without changes to the application code
Next Steps

What’s New

Release 3.3:
ADO.NET Entity Framework Support, Application Context Awareness, and more

ADO.NET Entity Framework:
Now available for Oracle

Oracle Success Stories

European Bank for Fund Services
Security and application performance

Entrieva
Out-of-the-box connectivity