Tuesday, September 16, 2008

All SQL Compact 3.5 SP1 downloads now available

With the current release of Sync Services for Devices, all the SQL Compact 3.5 SP1 downloads are now available here.

Sync Services for Devices released to web

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

SQL Compact and LINQ to SQL performance advise

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.