CODEWITHSUNDEEP
silverlight-3.0sql-server-ceofflineoffline-mode
Richard B
Richard B

Reputation: 1581

Offline database access under Silverlight-3

As the Silverlight team worked through the betas, one glaring pain point that is existing in the realm of Silverlight 3 is the ability to have an offline database, so that you can right-click on the SL application, install it locally, and then be able to manipulate data in a local setting, without the Internet.

I've read a few articles where items such as Google Gears with SQLite had been used, but so far, no one has come up with a decent method by which someone can do the same thing with a SQL CE database.

I'm theorizing, and wanted to gain feedback... So many times, with LOB applications, you have the need for installing a "driver" into your system, which winds up being some sort of data access component or other monitoring device used by the LOB application. What I'm thinking about is to use a ClickOnce strategy and build a driver that would get installed on the local machine, and then make a "local" webservice for when the user is offline.

Has anyone tried this scenario, and if so, what were the pros/cons of the method? If you didn't finalize on this method, then what was your final decision based on experience, and what would you advise going forward for someone trying to crack this nut for their project?

Upvotes: 1

Views: 2024

Answers (3)

Richard B
Richard B

Reputation: 1581

Thanks to Jeremy Likeness, there seems to be a great open-source project that he developed which may indeed solve most of my problems... just need to figure out how to render reports without a callback to the server, and then I'm golden, when it's time to revive this project (if all goes well, that'll be sometime in 2012)

Upvotes: 0

James Cadd
James Cadd

Reputation: 12216

Here's the best I could find for a SQLite-ish experience:

http://silverdb.codeplex.com/

Upvotes: 1

Michael Sync
Michael Sync

Reputation: 5004

I've been trying for supporting the direct database access in Silverlight since five or six months back. After exploring quite a few different to port the database to Silverlight, we got one POC working with one object database but it's a bit far for us to release it... I may probably write about this in my blog soon.

I dont think that making a "local" webservice is a good idea since the clients may not have any web service installed on their machine.

Upvotes: 0

Related Questions