Skip to end of metadata
Go to start of metadata

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.

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.

  • No labels

4 Comments

  1. I added that one, thanks.

  2. It's not in Managed C++, though. The release notes for version 0.17(current is 0.21) reads:

    Version 0.17 (June 24, 2004)

    • C++ sources are converted to C#. Now SQLite.NET requires the presense of the native sqlite.dll. SQLite.NET.dll became completely managed.
  3. This wiki page currently (2010-10-30) recommends

        http://sourceforge.net/projects/adodotnetsqlite

    but that sourceforge page indicates that the project is dead and in turn recommends

        http://sourceforge.net/projects/sqlite-dotnet2/

    cm