Windows Phone 7 access database

What would be the most effecient and effective way to access database from WP7? I was 开发者_开发技巧trying WCF Ria service, but it is such a pain to have initial setup.

---

RIA Services isn't supported on the platform as yet.

I would recommend checking out Rob Tiffany's database series of posts on his blog and presentations from Mix and later talks at Tech Ed.

Windows Phone 7 Line of Business App Dev Overview Video | Rob Tiffany

Windows Phone 7 Line of Business App Dev :: Working with an In-Memory Database | Rob Tiffany

You could look at any of the many 3rd party database sources also, but be mindful of your memory footprint.

It's also quite straight forward to work directly with XML files and LINQ in isolated storage.

---

I assume you mean a remote database. Exposing your database via OData may be a good option. There is an OData client for WP7. Here's an example I wrote up, there are many others.