With the current release of Sync Services for Devices, all the SQL Compact 3.5 SP1 downloads are now available here.
Tuesday, September 16, 2008
The Sync Services for devices runtime has now been released to web, including an updated sample application. Sync Services requires SQL Compact 3.5 SP1 to be installed on the device. There have been some issues with performance during sync, that have not yet been solved properly, so beware. (RDA and Merge has proprietary support for compression). I have updated my SQL Compact feature matrix accordingly.
Friday, September 12, 2008
Matt Manela has posted some good advice on how to avoid a performance penalty when using SQL Compact with LINQ to SQL. SQL Compact works best if there is a initial open connection to the database file available for the lifetime of the application, and Matt's code implements this concept.