SQL Server Compact

The easiest way to install SQL Server Compact is through Microsoft's Web Platform Installer. This will include all dependencies and give you the latest version of the database engine.

What's new in SQL Server Compact 4.0 (link). Entity Framework now supports SQL Compact.

Code-First Development can be used with SQL Compact databases.

ASP.NET MVC Application Using Entity Framework Code First (link).

Connection string samples.

SQL Compact Tools

• SQL Server Compact Toolbox for Visual Studio (link)
• SQL To Compact Copy (link)
• ExportSQLCE (link)