Replacement for SQL Server CE for ClickOnce applications.

Question

I have come to the conclusion that SQL Server CE isn't a viable product. Between the versionsing issues and the impossibility of a non-administrator install it just doesn't work at my company.

Off hand I'm thinking about Jet, Oracle Berkeley, and SQLite. Given that I'm using .NET with ClickOnce, what embedded database would you recommend and why?

Answer 1

Hands down, SQLite - so long as your data entities can fit within its capabilities. Check out the various providers available and see what works for you. This one has worked well for me.

Answer 2

SQLite is something you should consider. It has a .net data provide, is fast and probably provides everything you need.

http://sqlite.phxsoftware.com/

Answer 3

I haven't tried but you could use the DeveelDB, is written in C#: http://db.deveel.com/Main_Page