Deploying SqlServer CE4 in ASP.NET MVC-Collection of common programming errors

Hi,

Please refer to the first known issue in the SQL Server Compact 4.0 CTP1 from the blog:  http://blogs.msdn.com/b/sqlservercompact/archive/2010/07/07/introducing-sql-server-compact-4-0-the-next-gen-embedded-database-from-microsoft.aspx
The native DLLs of SQL Server Compact 4.0 CTP1 need the Microsoft Visual C++ 2008 Runtime Libraries (x86, IA64 and x64), Service Pack 1. Installing the SQL Server Compact 4.0 CTP1 using the Windows Installer (.exe) file, also installs the Visual C++ 2008 Runtime Libraries SP1. If SQL Server Compact 4.0 CTP1 is deployed privately in the application’s folder the following have to be present on the machine for SQL Server Compact to function properly: a.      Installing the .NET Framework 3.5 SP1 also installs the Visual C++ 2008 Runtime Libraries SP1.

b.      Visual C++ 2008 Runtime Libraries SP1 can be downloaded and installed from the location given below:

http://go.microsoft.com/fwlink/?LinkId=194827
Note that installing .NET Framework 2.0 or 3.0 or 4 does not install the Visual C++ 2008 Runtime Libraries SP1.

In addition, you could refer to “To deploy a SQL Server Compact 3.5 database by using private file–based deployment” the section from http://technet.microsoft.com/en-us/library/aa983326.aspx to deploy a SQL Server Compact 4.0 database.

If you have any more questions, please let me know.
Thanks.