Programming Remote Data Access

In the preceding sample, you saw how to create a local SQL Server CE database in code, and then used it with some of the SqlServerCe objects. However, in practice many applications will require you to load data from a central database, make changes or additions locally, and then send your changes back to the central SQL Server database so that other users can see them. RDA is the first of two techniques this chapter covers for loading and updating a central SQL Server database (the second is covered later, in the section "Using Merge Replication"). Table 17-7 lists the platforms for SQL Server CE devices that support RDA.

Table 17-7. SQL Server CE Devices That Support RDA

Platform

Version

Handheld PC Pro

2.11 or ...

Get Microsoft® .NET Compact Framework (Core Reference) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.