Which is the best Portable database for .NET

Question

2.50/5 (2 votes)

See more:

Hi,

I am planning to make a distributable software in .NET which has lots of data stored in tables. But, I don't want to use any server database. It should be a file database, which can be installed with the setup. But, I don't want to use access database that doesn't give flexibility to me.
How is the perfomance of SQLLite with .NET ?
Is there any database like SQLLite that has built in support with .NET ?

Posted 24-Jul-14 8:27am

Yesudass Moses

Add a Solution

5 solutions

Solution 2

If your T-SQL is good go for SqlCE or Access. SqlCE does not support stored procedures but is less prone to corruption than MS Access which corrupts easily when the file gets large.Also access does not support the full T-SQL instruction set (dont think SqlCE does either but I think it supports more). SQL Lite has a small footprint but I have always stayed away from it because of lack of support for the date/datetime datatype. If you are going to work the dates I recommend SqlCE.

Posted 6-Aug-14 12:06pm

codejet

Solution 3

Everything has pros and cons,
please read http://stackoverflow.com/questions/4618673/sqlite-or-sql-server-compact-for-net-project[^]

Posted 6-Aug-14 18:01pm

Sibeesh Venu

Solution 4

1.I strongly suggest you to use SqLite. I am also using it successfully in some projects for my customers.

2.Regarding the performance of SqLite It is very fast on simple operation like: INSERT, DELETE, UPDATE, but is a little slow on complex query that use multiple JOIN.

Posted 6-Aug-14 19:57pm

Raul Iloc

Solution 5

SQL Server Compact Edition
SQLite
MS Access
Mongo DB

Posted 7-Aug-14 23:31pm

guardj

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-07-24T09:00:00

Solution 1

You have three choices really:

SqLite
SqlCE
Access

They are all similar, but Access has been a PITA since I first met it and it still isn't perfect. Works though.

SQLCE is a bit limited compared to the other two, but has a very small footprint.

I'd probably go with SqLite.

Posted 24-Jul-14 9:00am

OriginalGriff

Comments

Maciej Los 24-Jul-14 16:07pm

Short and to the point!
+5!