Uda Wiki Web

Introduction to Data Access

ADO.NET

About ADO.NET

How ADO.NET Works

OpenLink's ADO.NET providers use a variety of means to provide ADO.NET data access. The Multi-Tier ADO.NET provides "managed" ADO.NET data access through a bridge to a Multi-Tier Request Broker and Database Agent. The Multi-Tier ADO.NET provider can establish ADO.NET connections to any database for which an OpenLink Database Agent exists. The Multi-Tier client and ODBC Driver Manager are not involved.

OpenLink's Single-Tier ADO.NET providers for Sybase/SQLServer, PostgreSQL, and MySQL connect directly to the target database. They are "managed" wire protocol products that do not require an additional data access layer or components to connect. OpenLink's ODBC.NET Provider for ODBC is a Single-Tier ADO.NET provider that does not connect directly to the target database. Instead, this provider connects to an ODBC Driver Manager which loads an ODBC Driver which connects to the backend database. This latter product is an "unmanaged" provider.

What You Can Do With ADO.NET

OpenLink's ADO.NET providers use a variety of means to provide ADO.NET data access to relational databases. These ADO.NET providers come in both Single-Tier and Multi-Tier formats and they exist for Windows and Mono platforms. At the time of writing, Mono is available for Linux, Solaris, Mac OS X, and Windows.

Finding Further Information About ADO.NET & Utilities