When I was trying to connect to SQL Server CE from my ASP.NET website, I was getting following error.
SQL Server Compact is not intended for ASP.NET development.
To solve this problem, I found that I need to add following to my global.asax file.
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
}
Hope this will help someone.
Thanks