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:
- Mono includes a SQLite interface, but it does not yet support ADO.NET's DataAdapter class.
- The SQLite.NET wrapper works with Windows .NET, however it does not follow the standard ADO.NET api.
- (recommended) The Finisar ADO.NET Provider for SQLite complies with the ADO.NET API.
See this tutorial on using SQLite from a .NET app.
Sample Code
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.