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 t开发者_如何学Che 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.

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.