LINQ 2 SQL - SQL Server Compact Edition 3.5 - Provider Not Found

If you are working on a 64 bit machine and get the error message

Provider 'System.Data.SqlServerCe.3.5' not installed.

when you attempt to connect to your database, open your project properties and on the build tab, change your target platform to x86 and you should be back in business.

-ec