The goal of ADO is to gain access to, edit, and update data sources, and the programming model embodies the sequence of activities necessary to accomplish this goal. ADO provides classes and objects to perform each of the following activities:
Make a connection to a data source (Connection). Optionally, begin a transaction.
Optionally, create an object to represent an SQL command (Command).
Optionally, specify columns, tables, and values in the SQL command as variable parameters (Parameter).
Execute the command (Command, Connection, or Recordset).
If the command is row-returning, store the rows in a cache (Recordset).
Optionally, create a view of the cache so you can sort, filter, and navigate the data (Recordset).
Edit the data, by either adding, deleting, or changing rows and columns (Recordset).
If appropriate, update the data source with changes from the cache (Recordset).
If a transaction was used, accept or reject the changes made during the transaction. End the transaction (Connection).