Overview: DataDirect Connect for ADO.NET

View PDF

DataDirect Connect for ADO.NET is the industry's only suite of ADO.NET data providers with a 100% managed architecture, eliminating the need for database clients, boosting performance and delivering a flexible, secure connection to Oracle, DB2, Microsoft SQL Server, and Sybase.

Note: The current product release (DataDirect Connect for ADO.NET, Release 3.1 SP2) supports the Microsoft .NET Framework versions 2.0, 3.0, and 3.5. DataDirect will continue to provide support for the 1.x Framework through Release 2.2 of DataDirect Connect for .NET.

Ready to try DataDirect Connect for ADO.NET?

Download | Learn More

Select from the topics below to learn more about DataDirect ADO.NET providers:

100% Managed Code for Better Security, Performance and Flexibility

DataDirect Connect for ADO.NET is the only product to bring the power, performance and security of 100% managed code to ADO.NET data connectivity. Because it runs entirely within the protected environment of the .NET Framework, your applications can take advantage of the built-in reliability, security and management capabilities of the .NET Framework.

As a 100% managed code provider, DataDirect Connect for ADO.NET eliminates the need for database client libraries such as Oracle Net for Oracle 10g. This not only improves performance, it enables applications to utilize different versions of the data providers in a shared environment. This architecture also reduces rollout time and maintenance costs, as it can be easily deployed through the ClickOnce deployment method.

DataDirect Connect for ADO.NET providers are rigorously tested against DataDirect Technologies proprietary test suites under production simulation conditions to ensure a superior quality product.

DataDirect ADO.NET Provider Architecture Diagram


Click graphic for a full-size image
DataDirect ADO.NET Architecture

Advanced Features and Functionality

DataDirect Connect for ADO.NET supports the latest database versions and features, as well as advanced functionality across all major databases. Our ADO.NET providers support distributed transactions, connection pooling, operating system authentication, application failover and client-side load balancing.

SSL Encryption and OS Authentication

DataDirect Connect for ADO.NET offers advanced security features such as SSL encryption to protect critical data transmitted between the application and the database server, as well as operating system (OS) authentication. OS authentication allows organizations to create a Single Sign-On environment that bolsters security, eliminates the need for users to log in separately for each application, and reduces the costs associated with managing user accounts.

(See our Security Support Matrix for complete information on the type of security features supported for each of the major databases and how these features are supported.)

DataDirect Bulk Load

A persistent data connectivity challenge is the need to load very large amounts of data into relational databases as fast as possible. DataDirect Bulk Load is the first independent, standards-based implementation of bulk load functionality that provides consistent semantics across all supported databases—Oracle, DB2, Sybase, and SQL Server.

Performance Tuning Options

With DataDirect ADO.NET providers, your applications can immediately benefit from a wealth of performance tuning options without requiring changes to application code.

See the release highlights for a more detailed description of DataDirect Bulk Load and new performance tuning options.

Maximizes Interoperability across Databases

DataDirect Connect for ADO.NET enables applications to access multiple databases with fewer lines of code and less maintenance, ensuring consistent functionality and performance, regardless of the database. Interoperability features include:

  • Common code base across all providers reduces the amount of code necessary to access multiple databases, while providing consistent functionality
  • Standard "escape" syntax support for stored procedures, outer joins, scalar functions, date, time and timestamps for all databases
  • Standard error code mappings (SQLStates)
  • Standardized parameter markers ("?") across all databases

Visual Studio Developer Tools

DataDirect provides visual development aids that are seamlessly integrated into Visual Studio 2008 to assist in developing interoperable database code. This provides a consistent level of functionality across different databases, such as:

  • View of meta-data across multiple data sources is consistent (collections).
  • Manipulation of connection properties (user name, port, host) and advanced properties is consistent across data sources.
  • Output of performance wizards can be leveraged in a consistent fashion across data source types.

A visual drag-and-drop metaphor is leveraged that includes support for Server Explorer, Code Generation Wizards, Query Builder, and Schema Viewer. All these features provide a more robust development environment when you use DataDirect Connect for ADO.NET.

.NET Framework versions 2.0, 3.0, and 3.5

DataDirect Connect for ADO.NET data providers support versions 2.0, 3.0, and 3.5 of the Microsoft .NET Framework, leveraging the latest ADO.NET 2.0 functionality, and allowing your applications to use the latest innovations in performance, security, and deployment.

ADO.NET 2.0 Conformance

The ADO.NET 2.0 specification provides support for a Common Programming Model that supports a provider- and data source-independent programming model. In the Microsoft .NET Framework 1.x, ADO.NET 1.0 connection objects were required to be explicitly stated and are designed to be specific to the individual database type. This made it impossible to write interoperable code for the various database providers—SQL Server, Oracle, DB2, and Sybase.

In ADO.NET 2.0, a collection of related classes that provide common operations allow the developer to code to generic interfaces, which allows a database call to be made without knowing in advance the target database.

ADO.NET Provider Features

  • Eliminates the need for client libraries. This enables faster performance, speedier deployment, and reduced maintenance, while ensuring support for multiple versions of a database with a single provider
  • Supports operating system authentication, which allows organizations to create a Single Sign-On environment.
  • Supports SSL encryption to protect critical data.
  • Provides a consistent way to perform “bulk load” operations in .NET across all supported databases via DataDirect Bulk Load
  • Provides performance features such as statement caching and connection tuning options that significantly increase efficiency without changes to the application code.
  • Supports Oracle 10g Float and Double Data types and supports Oracle RAC.
  • Offers application failover support and client-side load balancing for all databases.
  • Provides distributed transaction support using Microsoft Distributed Transaction Coordinator (DTC) for all providers. Also supports System.Transactions, which is included in the 2.0 Framework to consolidate all transaction capabilities into a single interface.
  • Supports Microsoft-compatible Connection Pooling and Windows authentication for Microsoft SQL Server.
  • Includes support for Command Builders and includes built-in debugging tools and tracing capabilities for faster development.
  • Supports Schema Metadata included in ADO.NET 2.0 which makes it easier to ascertain information about the database schema.
Ready to try DataDirect Connect for ADO.NET?