ADO.NET 2.0 SQLite Data Provider
Version 1.0.49.0 May 28, 2008
Using SQLite 3.5.9
Written by Robert Simpson (robert@blackcastlesoft.com)
Released to the public domain, use at your own risk!
Official provider website:  http://sqlite.phxsoftware.com

The latest version can be downloaded here

Features:

Design-Time Support

In Windows Explorer, navigate to the SQLite.NET\bin\Designer folder and execute the INSTALL.EXE file.  The program will automatically detect what version(s) of Visual Studio 2005/2008 are installed and allow you to selectively install and uninstall the designer for each edition.

DbFactory Support (Non-Compact Framework)

In order to use the SQLiteFactory and have the SQLite data provider enumerated in the DbProviderFactories methods, you must add the following segment into your application's app.config file:

<configuration>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite"/>
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"
type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /> </DbProviderFactories> </system.data> </configuration>

See the help documentation for further details on implementing both version-specific (GAC enabled) and version independent DBProviderFactories support.

Compiling for the Compact Framework

Just change the target platform from Win32 to Compact Framework and recompile.  The Compact Framework has no support for enumerating attributes in an assembly, therefore all user-defined collating sequences and functions must be explicitly registered.  See the testce sample application for an example of how to explicitly register user-defined collating sequences and functions.

Distributing The SQLite Engine and ADO.NET Assembly

Only the System.Data.SQLite.DLL file needs to be distributed with your application(s).  This DLL contains both the managed wrapper and the native SQLite3 codebase.

Development Notes Regarding the SQLite 3 Source Code

The core sqlite engine is compiled directly from the unmodified source code available at the sqlite.org website.  Several additional pieces are compiled on top of it to extend its functionality, but the core engine's source is not changed.

Version History

1.0.49.0 - May 28, 2008

1.0.48.0 - December 28, 2007

1.0.47.2 - December 10, 2007

1.0.47.1 - December 5, 2007

1.0.47.0 - December 4, 2007

1.0.46.0 - September 30, 2007

1.0.45.0 - September 25, 2007

1.0.44.0 - July 21, 2007

1.0.43.0 - June 21, 2007

1.0.42.0 - June 1, 2007

1.0.41.0 - April 23, 2007

1.0.40.0 - January 31, 2007

1.0.39.1 - January 11, 2007

1.0.39.0 - January 10, 2007

1.0.38.0 - November 22, 2006

1.0.37.0 - November 19, 2006

1.0.36.1 - October 25, 2006

1.0.36.0 - October 23, 2006

1.0.35.1 - September 12, 2006

1.0.35.0 - September 10, 2006

1.0.34.0 - September 4, 2006

1.0.33.0 - August 21, 2006

1.0.32.0 - August 6, 2006

1.0.31.0 - July 16, 2006

1.0.30.1 - July 2, 2006

1.0.29.0 - May 16, 2006

1.0.28.0 - April 14, 2006

1.0.27.1 - February 28, 2006

1.0.27.0 - February 27, 2006

1.0.26.2 - February 15, 2006

1.0.26.1 - February 14, 2006

1.0.26.0 - February 11, 2006

1.0.25.0 - January 31, 2006

1.0.24.6 beta - January 23, 2006

1.0.24.5 beta - January 20, 2006

1.0.24.4 beta - January 16, 2006

1.0.24.3 beta - January 10, 2006

1.0.24.2 - December 30, 2005

1.0.24.1 - December 19, 2005

1.0.24 - December 9, 2005

1.0.23 - November 21, 2005

1.0.22 - November 11, 2005

1.0.21 - November 4, 2005

1.0.20 - October 19, 2005

1.0.19 - October 5, 2005

1.0.18.1 - September 19, 2005

1.0.18 - September 1, 2005

1.0.17 - August 26, 2005

1.0.16 - August 24, 2005

1.0.15 - August 22, 2005

1.0.14 - August 16, 2005

1.0.13 - August 8, 2005

1.0.12 - August 5, 2005

1.0.11 - August 1, 2005

1.0.10 - June 10, 2005

1.0.09a - May 25, 2005

1.0.09 - May 24, 2005

1.0.08 Refresh - Mar 24, 2005

1.0.08 - Mar 11, 2005

1.0.07 - Mar 5, 2005

1.0.06 - Mar 1, 2005

1.0.05 - Feb 25, 2005

1.0.04 - Feb 24, 2005

1.0.03 - Feb 23, 2005

1.0.02 - Feb 21, 2005