Sometimes it's necessary to use SQL CE database in ASP.NET site. In one of our projects we decided to do so but we got exception - "sql server compact is not intended for asp.net development". The workaround is quite simple - just add one line of code into Application_Start, like this:
protected void Application_Start(object sender, EventArgs e)
{
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
}
Happy coding!
