SQL CE 3.5 with LINQ to SQL

Using LINQ to SQL with SQL CE 3.5 can be a bit of a challenge.  First off, the LINQ to SQL Visual Studio designer doesn't support SQL CE so you need to run sqlmetal from the command line to create the object model (or write it by hand).  Once you get past this point then you can use LINQ to SQL the same way you would for SQL Sever BUT there is a catch.

 

Continue reading →