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.

 

Enjoy!

 


One thought on “SQL Compact Edition and ASP.NET

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>