SQLLite or MSAccess, Which is better with .net

Question

4.00/5 (1 vote)

See more:

.NET4.5

Currently I am working on a Window based application using .net and C#.
This application is for a single user, It has 5-6 Tables and approx 10-20 rows will be added daily in Two or Three table and rest are master Tables.
Previously i have worked on SQL Server but for this project I think SQL Server will not be good for this project as it is too heavy and slows down user's system.
So basically, I want to ask which database will be better for my project
(I am considering SQLlite and MSAccess but not sure which one should I choose.)

Posted 9-Mar-14 2:21am

Vishal Pand3y

Add a Solution

3 solutions

Solution 3

For .NET, SQL Server Compact[^] or Microsoft Access[^] is better option, reason is simple both these databases & .NET are Microsoft products so there're many advantages using over other databases.

But SQLite[^] is nice option, cross platform & many people do use on Mobile development.

Posted 9-Mar-14 23:06pm

thatraja

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)

Kornfeld Eliyahu Peter · Accepted Answer · 2014-03-09T02:25:00

Solution 1

There is no real difference between the two...In fact I can't see why not use MSSQL as embedded into the application. I can't see how it will slow down your app...
You may read here: http://social.technet.microsoft.com/wiki/contents/articles/940.how-to-embed-sql-server-express-in-an-application.aspx[^]

Posted 9-Mar-14 2:25am

Kornfeld Eliyahu Peter

Comments

agent_kruger 9-Mar-14 8:40am

+5 vote, sir, i agree i have used the MSSQL and is quite efficient.

Kornfeld Eliyahu Peter 9-Mar-14 8:57am

Thank you...
OT - Can I ask you a favor, stop call me Mr and sir. It makes me feel in the wrong place... :-)

agent_kruger 9-Mar-14 12:27pm

so, what should i call my seniors? "teachers" i guess :)

Kornfeld Eliyahu Peter 9-Mar-14 14:07pm

If, and when I will be your senior, I will let you know...

agent_kruger 10-Mar-14 4:36am

ok my dear friend.

agent_kruger · Accepted Answer · 2014-03-09T02:43:00

Solution 2

I think "Mr.Kornfeld Eliyahu Peter" is right. I am using MSSQL for 3 years now and found it better than any existing database. Still a link for "SQLLite V/S MSAccess".

http://db-engines.com/en/system/Microsoft+Access%3BSQLite[^]

Posted 9-Mar-14 2:43am

agent_kruger