Alternative of SQL as client side Storage

Question

i am making a client side project on Winform 4.0 or WPF, the problem is how can i store my data at client side having no SQL server installation. I will provide a setup of my application which will be run by my client. Client cant install SQL server. Is there database avaiable in .net that doesn't required sql installation or any other way?

SQLite is a recommended for client side data storage. – Jawahar Nov 20 '13 at 11:44 — Jawahar, Nov 20 '13 at 11:44
Also, Microsoft SQL Compact Edition is free – Colin Steel Nov 20 '13 at 13:19 — Colin Steel, Nov 20 '13 at 13:19
[linqdb](https://github.com/ren85/linqdb) – ren Sep 16 '16 at 13:46 — ren, Sep 16 '16 at 13:46

score 3 · Answer 1 · answered Nov 20 '13 at 11:45

3

You can use SQLite, which requires no installation. There are some ORMs out there that support SQLite, for example Dapper (which is used by StackOverflow as well.)

answered Nov 20 '13 at 11:45

krizz

412
3
5

score 3 · Answer 2 · answered Nov 20 '13 at 11:45

If you have to do with just simple data you can use SQL Server CE or SQLite. Both will store data as files that you can create and access from code. To do this you'll just need some dlls in your project, no installation. But be sure to analyse the limitations - some data types are not supported by these simple data bases etc.

score 2 · Answer 3 · answered Nov 20 '13 at 11:53

2

Have a look at RavenDb

You can have it embedded in your app. Fast and elegant

answered Nov 20 '13 at 11:53

lboshuizen

2,746
17
20

score 2 · Answer 4 · answered Nov 20 '13 at 11:58

2

Something not mentionned yet: ManagedEsent. Simple to use and fast. For simple persitence, there is a PersistentDictionary class.

answered Nov 20 '13 at 11:58

David Brabant

41,623
16
83
111

score 1 · Answer 5 · edited May 23 '17 at 12:00

1

You could use a SQLite database, for this.

If you only want to store small things, like settings, I would recommend you the following link Build-in Settings, this is easier in use, than selecting, updating, inserting and deleting from a SQLite database. Another Pro is, that no dlls are required.

edited May 23 '17 at 12:00

Community

1
1

answered Nov 20 '13 at 13:14

Max

12,622
16
73
101

score 0 · Answer 6 · answered May 28 '18 at 23:16

0

EntityWorker.Core new ORM and similar to entityframwork

answered May 28 '18 at 23:16

Alen.Toma

4,684
2
14
31

Alternative of SQL as client side Storage

6 Answers6