Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

Caché Managed Provider: Relational Interface

Part III of this tutorial focuses on using the relational interface to the Caché Managed Provider (CMP) together with ADO.NET in .NET client applications.

After completing this part of the tutorial, you will be able to:

  • Describe the difference between Direct and Disconnected data access as supported by ADO.NET and the CMP.

  • List the principal classes of the relational interface to the CMP and describe their roles.

  • List the principal ADO.NET classes and describe their roles.

  • Use the CMP to execute SQL SELECT commands and access the data they return.

  • Use the CMP to execute SQL INSERT commands.

  • Use the CMP transaction API to wrap SQL commands in transactions.

  • Use the CMP to create an ADO.NET data set and fill it with data.

  • Use the CMP to manipulate the data in an ADO.NET data set and save any updates to Caché.

The tutorial includes a project. This project consists of a set of instructions and exercises that guide you through the creation of a .NET– Caché application. To assist with this project, the tutorial includes a skeleton solution that you can use to complete the instructions and exercises. The tutorial also provides a complete solution that you can install and execute. For instructions on locating and configuring these files, see the Note below.

Note:

Read Example and Exercise Files for the location of the tutorial files and instructions for installing and executing them.

Note:

Click here to begin.

Feedback