Use the below code snippet to make SQL CE it work with ASP .NET application [C#] protected void Page_Load(object sender, EventArgs e) { AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true); string connectionString = @"Data Source=|DataDirectory|\Northwind.sdf"; Northwind nw = new Northwind(connectionString); var DataSource = nw.Orders.Skip(

I hope this would be useful for porting a MDF Sql db to CE Sql db. we all very much familiar with ADO.NET the namespaces available for SQL server data provider are System.Data and System.Data.SqlClient similarly in ADOCE.NET for SQL CE data provider are System.