When/why to use sqlite with asp.net MVC/Webfoms?

Question

I really dont know why people use sqlite. As i just gone through some Top voted sqlite question i can't get the point. So can someone suggest the point When/why to use sqlite with asp.net MVC/Webfoms?

EDIT:

Any good sample asp.net web application that uses sqlite for getting started?

Jarrett Meyer · Accepted Answer · 2010-09-29 10:30:02Z

3

Free. Lightweight. Local DB storage in file. Great for testing (in memory DB FTW). If you're using NHibernate, it's completely interchangeable with anything else (with a few exceptions that I've found). Using a local SQL Express DB requires all of the necessary SQL Express stuff to be installed on the server and be running as services. SQLite has no services that run.

If it meets your needs, go for it. If you need more horsepower, use something bigger.

answered Sep 29, 2010 at 10:30

Jarrett Meyer

19.6k6 gold badges61 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jakub Konecki · Accepted Answer · 2010-09-29 10:23:10Z

2

So you do not pay for SQL Server licence or don't have to cope with any deployment issues. All you need is a reference to one dll and a write access to one folder where your database file will be stored. The footprint is tiny: compare < 1MB with SQL Server Express installation.

answered Sep 29, 2010 at 10:23

Jakub Konecki

46.1k8 gold badges92 silver badges128 bronze badges

Collectives™ on Stack Overflow

When/why to use sqlite with asp.net MVC/Webfoms?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related