standalone database

Question

Hi,

I'm currently designing a small application in .Net and in the past I've been using MSAccess as standalone database that I can ship with the program. But I was wondering if in this day and age there wasn't alternative solutions, as easy to integrate in a .Net app., as transparent for the user and maybe better performance with large amount of data?

Cheers!

Answer 1

SQLite! This is exactly what it was made for.

http://www.sqlite.org/

http://sqlite.phxsoftware.com/

Answer 2

SQLite appears to match your needs -- see here for more.

Answer 3

Yes. I would recommend System.Data.SQLite, which is a ADO.NET wrapper around SQLite, a popular embedded database written in C.

Answer 4

Your options are:

• Sqlite - www.sqlite.org - http://sqlite.phxsoftware.com/
• Firebird - http://www.firebirdsql.org/
• Sql Server CE - http://www.microsoft.com/Sqlserver/2008/en/us/compact.aspx
• VistaDB - http://www.vistadb.net/ (commercial)
• ESE - Which is hard to integrate with .Net

SQL CE and Firebird are a lot faster when you need multithreaded writes, sqlite is king for single threaded access, or multithreaded reads. VistaDb is 100% managed so you can ship it on embedded devices.

These DBs in general will give you better reliability and performance to access. I would strongly recommend against using any of these dbs over a network share.

Answer 5

VistaDb is another one

Answer 6

There is always SQL Server CE... but I have found SQLite to be much easier to work with, especially with System.Data.Sqlite

Answer 7

You can take a look at siaqodb - link text

You can save objects with one line of code and retrieve back via LINQ

Answer 8

Try C#-SQLite - an independent reimplementation of the SQLite:

csharp-sqlite

Translated from C to C#. Pure managed code. No mixed-mode netmodule.