Windows Phone/universal local database that can handle relations?

I am really disappointed by a number of possible database choices for Windows applications. Few weeks ago I got a task to port Android application (uses ActiveAndroid ORM for SQLite) to WP. I naturally went with SQLite expecting it to work fine – wrong! It was such a pain in the ass to set up and costed me a few days. ORM's are really terrible and don't support relations without external extensions that work partially. How come there is absolutely no good local database choice for Windows apps…?

What would you recommend for a local database choice considering the following requirements:

  • ORM support
  • Supports relations (Absolute must!)
  • (Optional) Compatible with Xamarin for Android/iOS

by Millkovic via /r/csharp

Leave a Reply