Out of browser silverlight 4 application with local database that will run and install on windows or mac?

Question

I am researching using silverlight 4 to develop a desktop application that can be installed from a browser window, now the tricky part is that I want a lightweight database embedded into the application. The database should install with the rest of the application and it should ideally work on both windows and mac systems. Originally I was thinking sqlite would be suitable for this but I have learned that it is not compatible with silverlight. Does anyone know of a solution for this?

Answer 1

There are some available silverlight databases such as:

1. siaqodb - uses LINQ, available for WP7 - commercial.
2. effiproz - available for WP7 - commercial.
3. Perst - open source.

These utilizes silverlight local storage, comes with their own database engine.

Answer 2

While not exactly a database, the upcoming release of the Sync Framework will support offline caching for Silverlight 4 on the desktop/browser, and Silverlight on Windows Phone 7. As Liam Cavanagh mentions in this blog post before TechEd:

I have a TechEd session this week where I will be demonstrating all of this as well as how we will be extending the capabilities of the sync framework for creating offline applications, specifically allowing Silverlight, Windows Phone 7 and even non-MSFT platforms to be used for the clients.

http://blogs.msdn.com/b/sync/archive/2010/06/07/introducing-data-sync-service-for-sql-azure.aspx