ADO Programming Model with Objects
The goal of ADO is to gain access to, edit, and update data sources. 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 a command, for example, 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 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).
Next ADO Object Model Summary.