Could not load file or assembly 'System.Data.SqlServerCe'

Have you installed the Microsoft® Visual Studio Team System 2008 Database Edition GDR August CTP so that you can target SQL Server 2008 with your Database Projects and found this error message when you create a new project?

Microsoft Visual Studio
Could not load file or assembly 'System.Data.SqlServerCe, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Yes? Well, like me you should read the installation instructions (am I allowed to say RTFM here?)

As per Gert's blog you need to install the Microsoft SQL Server Compact Edition 3.5 SP1 as well as VS2008 SP1.

Get that badboy installed and it'll fix it right up for you.