Top

Chapter6.OpenLink ADO.NET Data Providers

Abstract

ADO.NET is the new feature-rich, data access Model used within the Microsoft.NET framework. It supports the data access requirements of the loosely coupled, multi-tier Web and Web services based applications of today. ADO.NET relies on the services of .NET Data Providers. These provide access to the underlying data source through four key objects: Connection, Command, DataReader, and DataAdapter.

The OpenLink .Net Data Providers are available as a suite of Managed and Unmanaged Data Providers providing a natural extension of our Universal Data Access Driver Suite. Thus providing .Net connectivity to the full range of Databases support in our Universal Data Access Driver suite. Two generic .Net Data Providers are available each exposing a common namespace/interface for accessing remote data sources as explained in the component architecture section below.

Table of Contents

6.1. Architecture
6.1.1. Managed Data Provider
6.1.2. Unmanaged Data Provider
6.2. Developing .NET Data Provider Application
6.3. OpenLink .NET Data Providers Connect String Attributes
6.3.1. Managed Generic Multi-Tier .NET Data Provider (OpenLink.Data.GenericClient)
6.3.2. Managed Microsoft SQLServer .NET Data Provider (OpenLink.Data.SQLServer)
6.3.3. Managed Sybase .NET Data Provider (OpenLink.Data.Sybase)
6.3.4. Unmanaged .NET Data Provider (OpenLink.Data.OdbcClient)
6.4. OpenLink .NET Data Providers Class Implementation
6.5. OpenLink.Data Namespace
6.5.1. OPLCommand
6.5.2. OPLCommandBuilder
6.5.3. OPLConnect
6.5.4. OPLDataAdapter
6.5.5. OPLDataReader
6.5.6. OPLError
6.5.7. OPLErrorCollection
6.5.8. OPLException
6.5.9. OPLParameter
6.5.10. OPLParameterCollection
6.5.11. OPLRowUpdatedEventArgs
6.5.12. OPLRowUpdatedEventHandler
6.5.13. OPLRowUpdatingEventArgs
6.5.14. OPLRowUpdatingEventHandler
6.5.15. OPLTransaction
6.6. Known Issues
6.6.1. Unsigned Type Handling
6.6.2. Timestamp Precision
6.7. .Net Provider Test Program
6.8. New Features
Prev Up Next
5.6.Oracle Connection Pooling Support Home|ToC 6.1.Architecture