What is a good lightweight database that can be used for an ASP.NET MVC application?

Question

I need lightweight database for an ASP.NET MVC application.

• would prefer not to install anything additional on the host box
• would also prefer being a little more robust than XML
• would like to use activerecord or entity frameworks

Answer 1

You can check sqlite

Answer 2

• Sqlite http://www.sqlite.org/
• visadb http://www.vistadb.net/

Answer 3

SQL Server Compact Edition claims to have an "XCopy" installation (copy and run), and it would have the fewest integration headaches.

Answer 4

Firebird can do the job well

The embedded version is an amazing variation of the server. It is a fully featured Firebird server packed in just a few files. It is very easy to deploy, since there is no need to install the server.