ADO.NET SQLite Data Provider
Version 1.0.93.0 June XX, 2014 (release scheduled)
Using SQLite 3.8.4.3
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 (Desktop 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.93.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 .NET 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 or Deploying System.Data.SQLite

On the desktop, when using the statically linked mixed-mode assembly, only the System.Data.SQLite.dll file needs to be distributed with your application(s). This dynamic link library contains both the managed provider and the SQLite native library. For other build configurations, including those for the .NET Compact Framework, you will need to distribute both the managed provider System.Data.SQLite.dll, as well as the associated native library SQLite.Interop.dll (or SQLite.Interop.XXX.dll for the .NET Compact Framework). For the .NET Compact Framework edition, this is a breaking change as of 1.0.59.0. The recent versions of the .NET Compact Framework do not appear to properly support mixed-mode assemblies. All builds of System.Data.SQLite, except those explicitly marked as "static" in their package name, will also require the associated Microsoft Visual C++ Runtime Library to be installed on the target machine. For further details on distributing and/or deploying System.Data.SQLite, please refer to the System.Data.SQLite Downloads web page.

Development Notes Regarding the SQLite Native Library Source Code

The included SQLite native library is compiled directly from the official source code releases available from the sqlite.org website.

In addition, there are several relatively small extensions included within the System.Data.SQLite "interop assembly" and some of these extensions are specific to the System.Data.SQLite project itself; however, the included SQLite native library source code itself is compiled verbatim, using a set of fully supported compile-time options designed for robustness and maximum backward compatibility with previously released versions of System.Data.SQLite.

Version History

1.0.93.0 - June XX, 2014 (release scheduled)

1.0.92.0 - March 19, 2014

1.0.91.0 - February 12, 2014

1.0.90.0 - December 23, 2013

1.0.89.0 - October 28, 2013

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