What is a good embedded database to use with C#? [

Question

With the demise of VistaDB (vistadb.net), I am on the look out for a good embedded database to use for my C# programming.

Does anyone have any suggestions for something to use that it is simple to install along with my application? VistaDB was simple because I only had to copy 1 DLL file along with my app to get it to work.

I am looking for something like that but with good documentation/samples for C#.

Answer 1

You can take a look at Firebird which have very good dot net drivers

http://www.firebirdsql.org/manual/ufb-cs-embedded.html

Another useful link here

Answer 2

SQLite with the official ADO.NET adapter.

Answer 3

try SQLite. its small fast and well maintained. here is another SO Question discussing C# wrappers. it looks like the one they describe there (http://sqlite.phxsoftware.com/) should suit your needs

Answer 4

You can use SQL CE or SQLite.

Answer 5

SQL CE 4.0 + EF4 is awesome.

The only problem is the lack of information on how to deploy it, since it's still in CTP.