Skip to main content

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 tab