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

views:

657

answers:

+7 Q:

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

Hello,

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#.

Thanks.

+8 A:

SQLite with C# wrapper

BioBuckyBall 2010-09-03 22:01:01

+5 A:

You can use SQL CE or SQLite.

SLaks 2010-09-03 22:01:44

+4 A:

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

luke 2010-09-03 22:01:46

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.

Andrew Lewis 2010-09-03 22:09:04

+1 A:

For an object-oriented embedded database, check out Perst from McObject. Perst is open source/dual-licensed and you can download complete source code:

http://www.mcobject.com/perst

Ted Kenney 2010-09-03 22:10:36

+18 A:

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

Hugues Van Landeghem 2010-09-07 17:33:53

Firebird is wonderful for server installations or single user installations.It has an embedded version that is suitable for single user scenarios and you do not have to install anything.It uses the same database file for both server and embedded database so you can easy go from single user to multi user and vice versa.

Yiannis Mpourkelis 2010-09-08 20:40:21

Also supports triggers, stored procedures, etc. And you can upgrade to enterprise grade just installing the c/s version and backing up/restoring the database to the new server. The dll is the client lib and also acts like the server, all in just one dll.

José Romero 2010-09-08 23:24:24

Here are the reasons Firebird is preferred over SQL Server and Oracle Express : No license fees and is Limitless (No matter how large is the machine CPUs+ Memory or how big is your database :Terabytes) , Start small grow large and still no fee to payand you can use the same database file :example.fdb in both embedded and in SuperServer version (client server model) after application requires external connection (Did i mentioned that is multi threaded and lockless if you compare it with sqlite )http://blog.cincura.net/231742-firebird-embedded-in-comparison-to-sql-server-compact-edition-4/

Mariuz 2010-09-09 09:48:50

Another option on the object database camp is db4o which supports java/.net natively.

Best

Vagaus 2010-09-14 14:09:36

ansaurus

tags:

views:

answers:

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

related questions