For some time I am consulting one of my customers with the creation of WPF application which uses a Sql Server Compact edition DB. We quickly used Linq to SQL as our DAL and created our data model (using SqlMetal as so far even after SP1 no IDE support for SqlCE, drop me a comment if you don’t know how...
So you have decided that you want to incorporate SQL server CE into your application. I found out that almost every Smart Client or Desktop based Rich application need a way to cache data and Sql Server CE is a great tool to do just that. Sql Compact Edition has a few advantages that might sway you if...
Prologue I am using Vista, Yes I am, defying and ignoring all those saying "Wait till SP1" or "What's wrong with XP?" guys, I'm sure you all know those and can relate. My main excuse was that I need to program WPF apps, and in vista it will look much better, oh well, whatever. Anyway I was and still...