Search code examples
databasesqlitesilverlight-4.0expression-blend

Silverlight 4 with SQLite or alternative

I am making a Silverlight app and what I considered something straight-forward really isn't.

I am in need to create a application where a local database is stored on the web server where the Silverlight application can connect to and whenever a user goes on the application will allow sql queries to be carried out. Main use is Registration, login and event registration.

I have tried the Community SQLite: http://code.google.com/p/csharp-sqlite/

But had trouble getting it to work with Silverlight, my guess is due to poor documentation. I already have made a project containing a lot of work so I just want to implement my SQLite code into that.

Can anyone help

Thanks.

Solution

  • If you want your Silverlight application to have a LOCAL storage database, check out Sterling.

    If you want your Silverlight application to query a centralized, server-side database, then you need to expose your database via WCF. RIA services is probably the easiest implementation.