SQL CE with ASP .NET Application

Use the below code snippet to make SQL CE it work with ASP .NET application

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(0).Take(100).Select(o => o);

}

<assemblies&gt

<add assembly="System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"&gt

</assemblies &gt