Recommended database and orm for a "Windows Store" app
We are having an internal debate on our team on whether SQLite is the
right database to go with for our "Windows Store" application. My team
members claim that SQLite is not threadsafe and that our app will perform
poorly and be problematic.
Scouring the net I see lots of references to SQLite and I don't see anyone
complaining about threading issues even though by nature SQLite is not
thread safe. I don't read anyone recommending other types of databases
outside of SQLite.
In addition, I'm looking for recommendations for a ORM since Microsoft
does not offer Entity Framework for "Windows Store" applications. How are
others getting around this problem where they need to keep excessive
amounts of data in a local database on a device where a database is needed
which means that an ORM would be beneficial.
Also, since SQLite is not thread safe, what is the recommended pattern to
creating a stable data access design?
No comments:
Post a Comment