SQLite is a small database engine that has become very popular. The database is stored as a local file, and you can embed the SQLite engine with your app using one of the libraries below.
Here are three different libraries you can use to access SQLite databases from .NET or Mono:
- The SQLite.NET wrapper works with Windows .NET, however it does not follow the standard ADO.NET api.
See this tutorial on using SQLite from a .NET app.
Here is a sample using Mono's SQLite interface. It is a boo port of the Mono SQLite test case. Note, this code has not been tested, it may contain syntax errors. It is for illustration purposes only. Also, the DataAdapter section at the bottom will not work anyway.