Text file , CVS xml or what are my options ?

Question

I want to develop an app for Windows 7 phone. It will be a GRE vocab app. i dont want to use SQL CE, my app will have 3 tables conceptually. I will be using Linq to SQL to querying data. Now i am confuse how should i store data so it is easy for retrival and update.

XML , CSV , XML or any other format ?

Answer 1

You could use the Isolated Storage or ready to use implementations.

Answer 2

You can use Perst as a data store. I also know that SQLite also works, but I also hear that it's painfully slow.

Answer 3

For such a simple database, I'd go with either XML or SQLite. Both are queryable from code.

If you want to update external to the application, i.e. if you don't want to write an interface to update the vocabulary words, but would rather just open a file and update it manually, then XML is the way to go.

SQLite may be faster than querying XML (can't speak to this with certainty, but SQLite uses a binary format, which is generally faster), but you'd need to write all the screens to add words, update definitions, etc.