App without remote database

Question

If I want to create .NET app that needs database functionalities, but I do not want to use remote database, what should I use instead?

For example, 1) web app which needs to store data in some kind of database 2) desktop app which need to store data in some kind of database

Answer 1

You can use SQL CE or SQLite.

Answer 2

Use SQLite. Here is an ADO.Net provider with EF support: System.Data.SQLite

Answer 3

There's quite a big list of embedded databases for .NET on Wikipedia (http://en.wikipedia.org/wiki/Embedded_database). Personally I'd go for SQLite.