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.
Direct Using the CacheCommand
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.
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.
© 1997-2019 InterSystems Corporation, Cambridge, MA