With VS2010 sp1, we added SQL CE 4.0 support. You can view more information about SQL CE 4.0 from the following sites: http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx http://blogs.msdn.com/b/webdevtools/archive/2011/01/06/how-to-bin-deploy-sql-compact-edition-4-0-and-razor-web-projects.aspx http://www.microsoft.com/downloads/en/details.aspx?FamilyID=033cfb76-5382-44fb-bc7e-b3c8174832e2 Here is a walk through of how to deploy a SQL CE database to SQL Server database using web application publish. 1. Create a web application 2. Add a SQL CE 4.0 database via "Add New item": 3. In server explorer, under the SQL CE database, add a table "Customer", with 2 columns "ID" and "Name". Use...(read more)
Go to the complete details ...