CODEWITHSUNDEEP
.netdatabase
Lancelot
Lancelot

Reputation: 2427

standalone database

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?

Upvotes: 10

Views: 7863

Answers (6)

Sam Saffron
Sam Saffron

Reputation: 131112

Your options are:

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.

Upvotes: 20

jle
jle

Reputation: 9489

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

Upvotes: 1

Rony
Rony

Reputation: 9511

VistaDb is another one

Upvotes: 2

Matthew Flaschen
Matthew Flaschen

Reputation: 284786

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

Upvotes: 2

Alex Martelli
Alex Martelli

Reputation: 881585

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

Upvotes: 1

Instance Hunter
Instance Hunter

Reputation: 7925

SQLite! This is exactly what it was made for.

http://www.sqlite.org/

http://sqlite.phxsoftware.com/

Upvotes: 9

Related Questions