ADOCE and ADOXCE

< BACK  NEXT >

[oR]

Windows CE supports OLEDB and OLEDB providers for different databases, and these databases can be accessed through the OLEDB interface. However, it is generally easier and more convenient to use ActiveX Data Objects (ADO) to access data in databases, and ADOXCE to manipulate the database objects, such as tables and columns. ADO and ADOCE are COM interfaces and components that can be accessed using smart pointers (Chapter 14).

A Connection interface is used by ADOCE to connect to the data source. The Recordset interface is the cornerstone of ADOCE programming. A recordset is a virtual database table whose fields and rows correspond to a subset of the fields (columns) and rows in an actual database table or tables. When you change data in the recordset, the recordset stores the changes in memory, enabling you to cancel the changes before the underlying database is updated. While ADOCE is designed for single-user access, recordsets do manage concurrency to ensure correct data updating if two recordsets are created on the same table. A Fields collection contains Field objects that represent the data in a record in the recordset.

In ADOXCE a Catalog interface manages access to the objects in a database (which is also known as a catalog). The Catalog can return a Tables collection, and each Table interface in this collection represents a single table in the database. New tables can be created, the fields defined, and indexes added.

< BACK  NEXT >