Muito bom esse video para quem pretende trabalhar com SQL Server Compact Database.
MSDN Video: How Do I: Efficiently Query a SQL Server Compact Database Using LINQ? (Level 200)
Take advantage of the benefits of LINQ to access Microsoft SQL Server Compact databases while minimizing your application’s resource consumption and maintaining a small memory footprint. Jim Wilson demonstrates how.
Abraço, Rodrigo