ADO.NET SQLite Data Provider
Version 1.0.89.0 September XX, 2013 (release scheduled)
Using SQLite 3.8.1
Originally written by Robert Simpson
Released to the public domain, use at your own risk!
Official provider website: http://system.data.sqlite.org/
Legacy versions: http://sqlite.phxsoftware.com/

The current development version can be downloaded from http://system.data.sqlite.org/index.html/timeline?y=ci

Features

Design-Time Support

Download and run one of the setup packages and then select the "Install the designer components for Visual Studio 20XX." option when prompted.

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, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
        </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

On the desktop, 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.  For the Compact Framework, you will have to distribute both the CF version of System.Data.SQLite.DLL, as well as the SQLite.Interop.XXX.DLL.  This is a breaking change as of 1.0.59.0.  Recent Windows Mobile frameworks are not supporting the mixed CF assembly I was building prior to this version.

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.89.0 - September XX, 2013 (release scheduled)

1.0.88.0 - August 7, 2013

1.0.87.0 - July 8, 2013

1.0.86.0 - May 23, 2013

1.0.85.0 - April 18, 2013

1.0.84.0 - January 9, 2013

1.0.83.0 - December 29, 2012

1.0.82.0 - September 3, 2012

1.0.81.0 - May 27, 2012

1.0.80.0 - April 1, 2012

1.0.79.0 - January 28, 2012

1.0.78.0 - January 27, 2012

1.0.77.0 - November 28, 2011

1.0.76.0 - October 4, 2011

1.0.75.0 - October 3, 2011

1.0.74.0 - July 4, 2011

1.0.73.0 - June 2, 2011

1.0.72.0 - May 1, 2011

1.0.71.0 - April 27, 2011

1.0.70.0 - April 22, 2011

1.0.69.0 - April 12, 2011

1.0.68.0 - February 2011

1.0.67.0 - January 3, 2011

1.0.66.1 - August 1, 2010

1.0.66.0 - April 18, 2010

1.0.65.0 - July 26, 2009

1.0.64.0 - July 9, 2009

1.0.63.0 - June 29, 2009

1.0.62.0 - June 19, 2009

1.0.61.0 - April 28, 2009

1.0.60.0 - October 3, 2008

1.0.59.0 - September 22, 2008

1.0.58.0 - August 30, 2008

1.0.57.0 - August 29, 2008

1.0.56.0 - August 11, 2008

1.0.55.0 - August 6, 2008

1.0.54.0 - July 25, 2008

1.0.53.0 - July 24, 2008

1.0.52.0 - July 16, 2008

1.0.51.0 - July 1, 2008

1.0.50.0 - June 27, 2008

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