Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).

Caché Managed Provider Classes: Part 2

The following table lists the principal Caché Managed Provider classes, provides a brief description of each, and lists some of their important properties and methods:

Class Description Important Properties\Methods
CacheConnection Represents the physical connection between an application and a data source. Instantiate the connection using a connection string. Use CacheConnection to represent a connection between Caché and ADO.NET. Methods include:
  • Open — Opens a connection.
  • Close — Closes a connection.
  • Connection(string connectString) — Constructor. Instantiates a connection using a connection string containing port, address, namespace, user name, and password information.
Represents a command, for example an SQL command, that can be executed against the database.
Methods include:
  • Command(string "SQL") — Constructor. Instantiates a representation of an SQL command.
  • Execute — Executes the command and returns data.
  • ExecuteNonQuery — Executes a non-query, for example an INSERT.
Mediates between the DataSet object and the data source. Decouples them so that a DataSet can be filled with data from multiple data sources.
Methods include:
  • Fill — Fills a DataSet with data from the data source.
  • Update — Resolves any changes made in a DataSet back to the data source or sources.
Used only for very efficient retrieval of a read-only stream of data. Supports only forward movement through the data stream. Results are retrieved as the query executes and stored in network cache.
Methods include:
  • Read — Retrieves a a single row of the query result table from the network cache.
  • GetInt, GetString, and so on — Retrieves data from the current row using either the column name or number.
FeedbackOpens in a new window