Recommendations for single user access Database

I am writing a desktop utility application to manage a small set of data. This application will be used by a singular person so I’d like to keep the database as simple as possible. I am considering XML or SQL Server Compact 3.5 (SQL CE). I am leaning towards SQL CE because it will probably be easier/quicker to develop than XML. Are there any other worthwhile solutions worth considering? Is SQL CE the way to go?

Edit – Here are some more specifics on the data:

  • Maybe a half a dozen tables
  • No more than 5000 records
  • Mostly CRUD operations
  • Basic reporting/exporting to excel
Asked on April 7, 2016 in C#.
Add Comment
1 Answer(s)

SQLite would be my choice.

Answered on April 7, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.