Preparing a CacheDataAdapter: Overview

A CacheDataAdapter connects a DataSet with a data source. To initialize a CacheDataAdapter you must do the following:

• Initialize the adapter with the SQL SELECT command. The adapter fills the data set based on this command.

• Create CacheCommand objects for each of the SQL commands that the adapter supports. In this case, the adapter supports INSERT, UPDATE, and DELETE.

• For each CacheCommand object, create CacheParameter objects to represent the parameters in its SQL. Add the CacheParameter objects to the CacheCommand objects.