Stand alone database for Windows Application (WPF) [closed]

Question

I have created a simple (commercial) WPF application and want to distribute it with a database that can be installed on the local machine of a customer.

What database is the best to use ?

I was considering SQL Server Epress Edition 2008. I know the limitations of 10 GB, but that's more than enough and is no issue.

The only thing I'm not choosing 100% for Express is that I don't know how to let my customer backup the database.

My collegues keep telling me to use MS Access, but I don't know if that's a good option because I want to use stored procedures and views.

Please let me know what you are using or you can advise me...

Answer 1

SQLite is a great alternative. There is an ADO.NET provider developed by System.Data.SQLite

And there is a decent, free, editor for SQLite as well: SQLite Administrator

Backing up is as easy as copying the SQLite db file. Really.