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