Can A Silverlight Client Access A Local Sql Compact Database That Is Stored In Isolated Storage

Does the silverlight clr support access to a sql compact database placed in the silverlight application's isolated storage? If so, any pointers to code samples. I would like to cac

Solution 1:

Even if it was stored in Isolated Storage, there is no Silverlight library to read in SQL Server Compact Edition. Perhaps in a future version. I have heard of a couple of open source projects that are trying to do this but there are not any that have releases yet. I tried to wrap the Google Gears DB in Beta 2 to no success.

Solution 2:

There is no SQL client for silverlight. Also the user can delete your data from Isolated storage - right-click the running silverlight app and go to the "Application storage" tab. So just use it for user settings and for cached data that the app can work without, even if it is slower.

If you need to cache data locally, your best bet is to store it as XML in the isolated storage, reading and writing it using LINQ to XML.

If there's too much data for this, or the data is too complex to make this easy, then keep the data on your server and the silverlight client should then just access it over the net.

Solution 3:

It's probably worth mentioning that this is now possible using Silverlight 4's COM capability but only when running Out Of Browser.

Solution 4:

I have a sample here, using SQL Server Compact and Silverlight (OOB and elevated and on Windows only) - http://erikej.blogspot.com/2010/02/access-local-sql-compact-database-from.html