Skip to main content

Relational Interface

The Caché Managed Provider for .NET (CMP) also provides a relational interface that provides complete relational access to Caché data through the ADO.NET API.

ADO.NET provides two different styles of data access. The Caché Managed Provider (CMP) fully supports both styles.

  1. Direct — Using the CacheCommand and CacheDataReader classes, the application opens a connection to Caché and execute queries and stored procedures on the data source. The CacheDataReader supports efficient retrieval of a read-only data stream. It supports only forward movement through the stream.

  2. Disconnected — Create a DataSet object constituting an in memory cache of data. Use CacheDataAdapter objects to fill the DataSet. The data can be drawn from a variety of sources, including databases, web services, text, and XML files. The application manipulates the data in the DataSet. The DataSet uses the CacheDataAdapter objects to migrate any updates back to the data sources.

This tutorial provides examples of both styles of data access.


For more information on ADO.NET data access and a discussion of when to use Direct and Disconnected access, see ADO.NET ArchitectureOpens in a new tab in the .NET Framework Developer's Guide.

For more in depth information on the CMP relational interface, read Using Caché ADO Provider Classes in Using the Caché Managed Provider for .NET.

FeedbackOpens in a new tab