SQLServer Compact Edition in Asp.Net

[Paul S]

Hi

I have a web application that shows events on a screen in a showroom so
there's only one user.
I thought the easiest way to implement a datastore for the events was to use
a
SqlServer Compact Edition database. I now ended up with this problem

'Unable to find the requested .Net Framework Data Provider. It may not be
installed. '

Searching the internet I found this piece of code to add to my application:


AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting",
true);

I put this in my Application_Start method in the global.asax file, but I
still have the problem

Any ideas

Thanks Paul S

 

[Juan T. Llibre]

See if these links help you :

http://blogs.msdn.com/stevelasker/a...pact-edition-database-and-schema-in-code.aspx

http://blogs.msdn.com/sqlservercomp...y-first-entity-application-against-sqlce.aspx

http://support.microsoft.com/kb/920700

http://www.microsoft.com/sql/editions/compact/default.mspx

SQL Server Compact Edition is not designed for sending data to web browsers.
It's designed for sending data to mobile devices.

Also, you might want to post your questions about SQL Server CE at :
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1