Mobile DB Data Persistence

Topics: CAB & Smart Client Software Factory
Apr 26, 2006 at 1:02 PM
originally posted by: afida

We are implementing a mobile (disconnected) component of our enterprise application. This mobile version is for field data collection purposes. It intends to use a mobile DB (SQLCE, DB2e, OracleLite, etc) to store that data locally on the device until user synchronizes data with the back-end.

Interaction with the mobile DB will be via ADO.NET provider for Compact Framework 2.0. Are there any patterns or guidance for data persistence (insert, update, delete, select) via ADO.NET to mobile DB (for only a single user and likely a single thread). Can the similar data persistence patterns for non-mobile database can be applied in our case?