Programming a SQL Server CE Application
There are three distinct phases to programming with SQL Server CE: creating the local SQL Server CE database, updating the local data, and merging the locally changed data back to a central database. This section examines the creation of a local SQL Server CE database in code and updating the database from a smart device application programmed using the .NET Compact Framework.
The sample application is designed to help several car-parking attendants record the position and length of stay of vehicles using a smart device application. In this first part, the sample simply records the registration plate and description of the position of a vehicle, as shown in Figure 17-3.
Figure 17-3. UsingSQLCESample application—Add ...
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.
