SQL Compact Edition and ASP.NET

By default SQL CE doesn’t run under IIS. The original plan was for the license to disallow this. There has been quite a bit of discussion about this restriction and it look like the powers that be listened. While still not fully supported there is at least a step in the right direction by enabling the product to run, previously it actively prevented you from doing so.
By doing an: AppDomain.CurrentDomain.SetData(“SQLServerEverywhereUnderWebHosting”, true)
the product will work. As it still is a single user database there are some things to watch out for but if you are in a position to do so this might be jus what the doctor ordered 🙂
See Steve Laskers blog post for the full story.

One thought on “SQL Compact Edition and ASP.NET

Leave a Reply

Your email address will not be published. Required fields are marked *