Name	Description
Force_SQLiteLog	If this environment variable is set [to anything], the SQLite + logging subsystem may be initialized in a non-default application + domain. By default, this is not allowed due to the potential for + application domain unloading issues.
No_PreLoadSQLite	If this environment variable is set [to anything], the native + library pre-loading functionality will be disabled. By default, + the native library pre-loading will attempt to load the native + SQLite library from architecture-specific (e.g. "Win32") or + platform-specific (e.g. "x86", "amd64", "x64") directories that + reside underneath the application base directory.
PreLoadSQLite_BaseDirectory	If this environment variable is set [to anything], it will be + used instead of the application base directory by the native + library pre-loader.
PreLoadSQLite_ProcessorArchitecture	If this environment variable is set [to anything], it will be + used instead of the processor architecture value contained in the + PROCESSOR_ARCHITECTURE environment variable to help build the path + of the native library to pre-load.
PROCESSOR_ARCHITECTURE	This environment variable is normally set by the operating + system itself and should reflect the native processor architecture + of the current process (e.g. a 32-bit x86 application running on a + 64-bit x64 operating system should have the value "x86"). +

Version History

1.0.80.0 - April XX, 2012

1.0.82.0 - September XX, 2012

Updated to SQLite 3.7.14.
The primary NuGet package now supports x86 / x64 and the .NET Framework 2.0 / 4.0 (i.e. in a single package).
Change the default value for the Synchronous connection string property to Full to match the default used by the SQLite core library itself. ** Potentially Incompatible Change **
Add the ability to skip applying default connection settings to opened databases via the new SetDefaults connection string property.
Fix the database cleanup ordering in the tests for ticket [343d392b51].
Add support for the sqlite3_close_v2 function from the SQLite core library.
Add support for URI file names via the new FullUri connection string property.
Improve support for the standard SQLite core library in the LINQ assembly and the test suite.
Add SetMemoryStatus static method to the SQLiteConnection class.
Improve threaded handling of the delegate used by the SQLiteLog class.
Add define constants to support enabling or disabling individual groups of trace statements.

1.0.81.0 - May 27, 2012

Updated to SQLite 3.7.12.1.
Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.
Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.
Add release archive verification tool to the release automation.
Fix NullReferenceException when calling the SQLiteDataAdapter.FillSchema method on a query that returns multiple result sets. Fix for [3aa50d8413].
Fix subtle race condition between threads fetching connection handles from the connection pool any garbage collection (GC) threads that may be running. Fix for [996d13cd87].
Add missing call to SetTimeout in the SQLite3_UTF16.Open method.
Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.
Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.
Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.
Revise CriticalHandle derived classes to make them more thread-safe.
Add connection pool related diagnostic messages when compiled with the DEBUG define constant.
Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.
Rename internal SQLiteLastError methods to GetLastError.
Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.

1.0.80.0 - April 1, 2012

Updated to SQLite 3.7.11.
In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].
Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.
Add Visual Studio 2005 support to the redesigned designer support installer.
Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.
Add support for the native SQLite Online Backup API. Fix for [c71846ed57].
Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].
Support tracing of all parameter binding activity and use the connection flags to control what is traced.
When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.
Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.
Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.
In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.
Write warning message to the active trace listners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].
When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case.
For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa.
Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools.
Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it.
Add missing CheckDisposed calls to the SQLiteConnection class.

About SQLite.NET

This class library is an ADO.NET wrapper around the popular (and free!) - SQLite database engine. For information on SQL syntax, features of SQLite and a - good understanding of how it works and what it does, I highly recommend heading - over to sqlite.org and +

This class library is an ADO.NET wrapper around the popular (and free!) + SQLite database engine. For information on SQL syntax, features of SQLite and a + good understanding of how it works and what it does, I highly recommend heading + over to sqlite.org and reading the documentation there.

The C# provider, the very minor C code modifications to SQLite, documentation and - etc were written by Robert +

The C# provider, the very minor C code modifications to SQLite, documentation and + etc were written by Robert Simpson, and the SourceForge project page can be found here.

The System.Data.SQLite project is currently maintained by the + SQLite Development Team and + the latest source code and project information can be found + here.

What's New?

Click here to see the version history of this SQLite.NET +

Click here to see the version history of this SQLite.NET provider

Using this library

The following are links to information on various aspects of the library and +

The following are links to information on various aspects of the library and how to use it in your application(s)

How to install Visual Studio Design-Time Support

How to configure and enumerate SQLite.NET +

How to configure and enumerate SQLite.NET through the DbProviderFactories object

Getting the best performance out of SQLite

Limitations of the SQLite.NET provider and the SQLite +

Limitations of the SQLite.NET provider and the SQLite engine (compared to other providers and engines)

SQLite.NET Provider Features

This SQLite provider implements every feature of the underlying SQLite +

This SQLite provider implements every feature of the underlying SQLite database engine without omission. Here's a brief summary:

Written from scratch on Visual Studio 2008 specifically for ADO.NET, implenting all the base classes and features recently introduced in the framework, including automatic transaction enlistment.
Supports the Full and Compact .NET Framework, as well as native C/C++ development. 100% binary compatible with the original sqlite3.dll.
Full support for Mono via a "managed only" provider that runs against the +
Full support for Mono via a "managed only" provider that runs against the official SQLite 3.6.1 or higher library.
Full Entity Framework support (ADO.NET 3.5 SP1)
On the Compact Framework, it is faster than Sql Server Mobile. SQLite's installed size is a fraction of Sql Mobile's. It uses less memory at runtime, runs queries faster, and has a smaller database file size as well.
Encrypted database support. Encrypted databases are fully encrypted and support both binary and cleartext password types.
Visual Studio 2005/2008/2010 Design-Time Support. You can add a SQLite - database to the Servers list, design queries with the Query Designer, +
Visual Studio 2005/2008/2010 Design-Time Support. You can add a SQLite + database to the Servers list, design queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc.
Full SQLite schema editing inside Visual Studio. You can create/edit +
Full SQLite schema editing inside Visual Studio. You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
- Available as a single file redistributable (except Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper + Available as a single file redistributable (except Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper are combined into one multi-module assembly.
Also available as separate native and managed assemblies and optionally with the Visual C++ Runtime statically linked.
Binaries included for Itanium, x64, x86 and ARM processors.
@@ -108,37 +112,37 @@
DbProviderFactory support.
Full support for ATTACH'ed databases. Exposed as Catalogs - in the schema. When cloning a connection, all attached databases are + in the schema. When cloning a connection, all attached databases are automatically re-attached to the new connection.
DbConnection.GetSchema(...) support includes the MetaDataCollections, DataSourceInformation, Columns, Tables, Views, ViewColumns, - Catalogs, Indexes, + Catalogs, Indexes, IndexColumns, ForeignKeys and Triggers.

- Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace + Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace and detailed schema information even for complex queries.

Named and unnamed parameters.

- Full UTF-8 and UTF-16 support, each with optimized pipelines into the native + Full UTF-8 and UTF-16 support, each with optimized pipelines into the native database core.

Multiple simultaneous DataReaders (one DataReader per Command however).

- Full support for user-defined scalar and aggregate functions, encapsulated into - an easy-to-use base class in which only a couple of overrides are necessary to + Full support for user-defined scalar and aggregate functions, encapsulated into + an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions.

- Full support for user-defined collating sequences, every bit as simple to + Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class.

- Full source for the entire engine and wrapper. No copyrights. + Full source for the entire engine and wrapper. No copyrights. Public Domain. 100% free for commercial and non-commercial use.

Distributing the Binaries (Desktop)

When using the mixed-mode assembly, the System.Data.SQLite.DLL file @@ -154,11 +158,11 @@

Distributing the Binaries (Compact Framework)

Both the System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL files must be deployed on the Compact Framework. The XXX is the build number of - the System.Data.SQLite library (e.g. "080"). The + the System.Data.SQLite library (e.g. "082"). The SQLite.Interop.XXX.DLL file is a fully native assembly compiled for the ARM processor, and System.Data.SQLite is the fully-managed Compact Framework assembly.

Index: Doc/SQLite.NET.chm ================================================================== --- Doc/SQLite.NET.chm +++ Doc/SQLite.NET.chm cannot compute difference between binary files Index: Doc/SQLite.NET.hhc ================================================================== --- Doc/SQLite.NET.hhc +++ Doc/SQLite.NET.hhc @@ -16,10 +16,14 @@
+

	- sqlite-netFx-source-1.0.79.0.zip + sqlite-netFx-source-1.0.81.0.zip - (2.62 MiB) + (2.72 MiB)	This ZIP archive contains all current source code for System.Data.SQLite - 1.0.79.0 (3.7.10) combined into a single archive file. + 1.0.81.0 (3.7.12.1) combined into a single archive file. - (sha1: 634b93112cd3bd093933760944aa3bf8740a455a) + (sha1: e707a73f56acb32c3c5f529cfd90353b4ef5894b)
@@ -32,40 +32,43 @@
	- sqlite-netFx35-setup-bundle-x86-2008-1.0.79.0.exe + sqlite-netFx35-setup-bundle-x86-2008-1.0.81.0.exe - (6.02 MiB) + (6.06 MiB)	This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 + the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 is included. The .NET Framework 3.5 SP1 is required. - (sha1: 5a6de51b4d2c06629b7070c2c147f6a6eb8ce043) + This setup package is capable of installing the design-time + components for Visual Studio 2005 and/or Visual Studio 2008. + + (sha1: 059367ac0cd76d22268ff44086fded56e751b6d0)
	- sqlite-netFx35-setup-x86-2008-1.0.79.0.exe + sqlite-netFx35-setup-x86-2008-1.0.81.0.exe - (6.02 MiB) + (6.05 MiB)	This setup package will install all the necessary runtime components and - dependencies for the x86 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2008 SP1 runtime for x86 is included. + dependencies for the x86 version of the System.Data.SQLite 1.0.81.0 + (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 is included. The .NET Framework 3.5 SP1 is required. - (sha1: 2208f5903ed522aa6b5718fcce5f22b528c62640) + (sha1: ff4757af2b0c4e04267dc884444f4dd6b957e567)
@@ -74,40 +77,40 @@
	- sqlite-netFx35-setup-bundle-x64-2008-1.0.79.0.exe + sqlite-netFx35-setup-bundle-x64-2008-1.0.81.0.exe - (6.76 MiB) + (6.79 MiB)	This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x64 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 + the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 is included. The .NET Framework 3.5 SP1 is required. - (sha1: 3b5febbc8915fd353ce9cbf28228635edf78d8c4) + (sha1: 0723b63013ef0cd76fad819321117f9e329ecec5)
	- sqlite-netFx35-setup-x64-2008-1.0.79.0.exe + sqlite-netFx35-setup-x64-2008-1.0.81.0.exe - (6.75 MiB) + (6.79 MiB)	This setup package will install all the necessary runtime components and - dependencies for the x64 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2008 SP1 runtime for x64 is included. + dependencies for the x64 version of the System.Data.SQLite 1.0.81.0 + (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 is included. The .NET Framework 3.5 SP1 is required. - (sha1: e0845f081c19edb6c27878e33bc9e4c2f166220e) + (sha1: 55079690dcd5fca3647c1471c57fc6526bdd9575)
@@ -116,40 +119,43 @@
	- sqlite-netFx40-setup-bundle-x86-2010-1.0.79.0.exe + sqlite-netFx40-setup-bundle-x86-2010-1.0.81.0.exe - (10.35 MiB) + (10.38 MiB)	This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 + the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 is included. The .NET Framework 4.0 is required. - (sha1: 2f6f2b9d507a7c751b638f76a1e3b25bc2322b76) + This setup package is capable of installing the design-time + components for Visual Studio 2010. + + (sha1: dc699f17300f8e7cfd3491be93c8c49952465229)
	- sqlite-netFx40-setup-x86-2010-1.0.79.0.exe + sqlite-netFx40-setup-x86-2010-1.0.81.0.exe - (10.34 MiB) + (10.38 MiB)	This setup package will install all the necessary runtime components and - dependencies for the x86 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2010 SP1 runtime for x86 is included. + dependencies for the x86 version of the System.Data.SQLite 1.0.81.0 + (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 is included. The .NET Framework 4.0 is required. - (sha1: b60fb8a586118182a3bee8dcbf77433ca651feec) + (sha1: 677f0cbb8ece0f28f173e35a7de38985c5fbd2ce)
@@ -158,40 +164,40 @@
	- sqlite-netFx40-setup-bundle-x64-2010-1.0.79.0.exe + sqlite-netFx40-setup-bundle-x64-2010-1.0.81.0.exe - (11.60 MiB) + (11.63 MiB)	This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x64 version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 + the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 is included. The .NET Framework 4.0 is required. - (sha1: 48ad9c2d7413cbdd80ff53597601e65e572d3369) + (sha1: 6c9672f3378d0d4e7a2d85e26acc8d65f4eaec1a)
	- sqlite-netFx40-setup-x64-2010-1.0.79.0.exe + sqlite-netFx40-setup-x64-2010-1.0.81.0.exe - (11.59 MiB) + (11.63 MiB)	This setup package will install all the necessary runtime components and - dependencies for the x64 version of the System.Data.SQLite 1.0.79.0 - (3.7.10) package. The Visual C++ 2010 SP1 runtime for x64 is included. + dependencies for the x64 version of the System.Data.SQLite 1.0.81.0 + (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 is included. The .NET Framework 4.0 is required. - (sha1: 4a8abad785ff31495e8fb137ec7fa4d9dca14062) + (sha1: 11fd00c4e4a6f607da5aee8714543deaa3db2fec)
@@ -200,39 +206,39 @@
	- sqlite-netFx35-binary-bundle-Win32-2008-1.0.79.0.zip + sqlite-netFx35-binary-bundle-Win32-2008-1.0.81.0.zip - (1.61 MiB) + (1.64 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 and the .NET Framework 3.5 SP1 are required. - (sha1: 28bb5a9d453571060c608ccc158819d6c51e52af) + (sha1: 55a6e00da4774e356bf2a1bb7f741ebef0568b2b)
	- sqlite-netFx35-binary-Win32-2008-1.0.79.0.zip + sqlite-netFx35-binary-Win32-2008-1.0.81.0.zip - (1.60 MiB) + (1.64 MiB)	This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 and the .NET Framework 3.5 SP1 are required. - (sha1: ba5309ecd3d68de8e1c6d64c0c5e1ee8521c5892) + (sha1: b0032d4cda03d0464a78727f969d65224ebbf5ff)
@@ -241,39 +247,39 @@
	- sqlite-netFx35-binary-bundle-x64-2008-1.0.79.0.zip + sqlite-netFx35-binary-bundle-x64-2008-1.0.81.0.zip - (1.67 MiB) + (1.71 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 and the .NET Framework 3.5 SP1 are required. - (sha1: e5d595ca4d0af4a8a79866cd0899d783d3c2955f) + (sha1: 10ca964f144fe1db2d78f6ec7dbee6a56e94cd83)
	- sqlite-netFx35-binary-x64-2008-1.0.79.0.zip + sqlite-netFx35-binary-x64-2008-1.0.81.0.zip - (1.67 MiB) + (1.71 MiB)	This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 and the .NET Framework 3.5 SP1 are required. - (sha1: da7a355d19b7649cd8804fff1b83397f29cef15a) + (sha1: 116af57ee95dc6c2b51caa5cd4c6cd30955ba89f)
@@ -282,39 +288,39 @@
	- sqlite-netFx40-binary-bundle-Win32-2010-1.0.79.0.zip + sqlite-netFx40-binary-bundle-Win32-2010-1.0.81.0.zip - (1.65 MiB) + (1.69 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 and the .NET Framework 4.0 are required. - (sha1: c6076691c1ab4f98f363afe980e3c19b3e143557) + (sha1: e932c5b064ec4a47d3a3ca2d64090c2ace3b8e4a)
	- sqlite-netFx40-binary-Win32-2010-1.0.79.0.zip + sqlite-netFx40-binary-Win32-2010-1.0.81.0.zip - (1.64 MiB) + (1.69 MiB)	This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 and the .NET Framework 4.0 are required. - (sha1: 779f3857ec43f6d67f0744363d090114236aa4aa) + (sha1: 152414d5582c946cbfb1f8f3dd85c77aaeec777f)
@@ -323,39 +329,39 @@
	- sqlite-netFx40-binary-bundle-x64-2010-1.0.79.0.zip + sqlite-netFx40-binary-bundle-x64-2010-1.0.81.0.zip - (1.68 MiB) + (1.71 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 and the .NET Framework 4.0 are required. - (sha1: da37bb787291e6b9d14f2f80bfe85539d9ff2864) + (sha1: d7fe6c3d7791a912a0eaca5d2a3b00471345fe43)
	- sqlite-netFx40-binary-x64-2010-1.0.79.0.zip + sqlite-netFx40-binary-x64-2010-1.0.81.0.zip - (1.67 MiB) + (1.71 MiB)	This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 and the .NET Framework 4.0 are required. - (sha1: e24444efe5ff214bf9a82a1ce0056193cea2d1c0) + (sha1: caf1744a2233f1d70bdae3064fef4c4d1f9d5d68)
@@ -364,40 +370,40 @@
	- sqlite-netFx35-static-binary-bundle-Win32-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-bundle-Win32-2008-1.0.81.0.zip - (1.82 MiB) + (1.90 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 is statically linked. The .NET Framework 3.5 SP1 is required. - (sha1: 3b86995edf96216f496ee9800cb7c6a9ae435f8f) + (sha1: f94134a17e8501cbb84bcb6c4dfffe45777ca438)
	- sqlite-netFx35-static-binary-Win32-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-Win32-2008-1.0.81.0.zip - (1.82 MiB) + (1.86 MiB)	This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x86 is statically linked. The .NET Framework 3.5 SP1 is required. - (sha1: b450fdfe98591c2ba590207cdb802a552c57f4a6) + (sha1: f6c51694379964271b5e2dbfe2121c38b9a1d3e6)
@@ -406,40 +412,40 @@
	- sqlite-netFx35-static-binary-bundle-x64-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-bundle-x64-2008-1.0.81.0.zip - (1.85 MiB) + (1.91 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 is statically linked. The .NET Framework 3.5 SP1 is required. - (sha1: e0d696f9f18a1993b796d3572372c84fee543300) + (sha1: c8c20f63a54bc9f2e4aab8e90ba455706d80b14b)
	- sqlite-netFx35-static-binary-x64-2008-1.0.79.0.zip + sqlite-netFx35-static-binary-x64-2008-1.0.81.0.zip - (1.84 MiB) + (1.89 MiB)	This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2008 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2008 SP1 runtime for x64 is statically linked. The .NET Framework 3.5 SP1 is required. - (sha1: 032185157560dc169036f58d9f2975471548cfd9) + (sha1: a2f82ec951ee52adbdc00449f438ec5f6272fd0d)
@@ -448,39 +454,39 @@
	- sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.81.0.zip - (1.87 MiB) + (1.89 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x86 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x86 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 is statically linked. The .NET Framework 4.0 is required. - (sha1: 04e6b299f802de1520ccbfafc4a67ce1862e2fc3) + (sha1: f83d8c8fdb6eab711e5b232d537272f57153c7b9)
	- sqlite-netFx40-static-binary-Win32-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-Win32-2010-1.0.81.0.zip - (1.86 MiB) + (1.90 MiB)	This binary package contains all the binaries for the x86 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x86 is statically linked. The .NET Framework 4.0 is required. - (sha1: 2b76be35643b92128f67b2b02c8b4d0ef78aa7da) + (sha1: b3235d3600816c98f61f03a7376471a00b86dd3f)
@@ -489,39 +495,39 @@
	- sqlite-netFx40-static-binary-bundle-x64-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-bundle-x64-2010-1.0.81.0.zip - (1.87 MiB) + (1.91 MiB)	This binary package features the mixed-mode assembly and contains all the - binaries for the x64 version of the System.Data.SQLite 1.0.79.0 (3.7.10) + binaries for the x64 version of the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required. - (sha1: f4d904accd7412f0980b2bcac9576a3af4c63930) + (sha1: 31b6f322462a5ca7575567b631f15bcdf7ec41b8)
	- sqlite-netFx40-static-binary-x64-2010-1.0.79.0.zip + sqlite-netFx40-static-binary-x64-2010-1.0.81.0.zip (1.86 MiB)	This binary package contains all the binaries for the x64 version of the - System.Data.SQLite 1.0.79.0 (3.7.10) package. The Visual C++ 2010 SP1 + System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The Visual C++ 2010 SP1 runtime for x64 is statically linked. The .NET Framework 4.0 is required. - (sha1: a04f7718eb947d40f1201ac8bee3433a38dd6d08) + (sha1: 22abaf4a909784a60649edf949ebaf77bb56dfc5)
@@ -530,21 +536,21 @@
	- sqlite-netFx35-binary-PocketPC-2008-1.0.79.0.zip + sqlite-netFx35-binary-PocketPC-2008-1.0.81.0.zip - (0.81 MiB) + (0.84 MiB)	This binary package contains all the binaries for the PocketPC version of - the System.Data.SQLite 1.0.79.0 (3.7.10) package. The .NET Compact + the System.Data.SQLite 1.0.81.0 (3.7.12.1) package. The .NET Compact Framework 3.5 is required. - (sha1: 8b0517a3468099bcdeb8bdb6de1395c4b5dfae43) + (sha1: 9d72313897010adff5cf6c52fd857f9aef509eaa)
@@ -560,12 +566,12 @@ (3.2 MiB)			Legacy versions, as well as the original support forums, may still be - found at [http://sqlite.phxsoftware.com/], though there have been no updates - to this version since April of 2010. + found at [http://sqlite.phxsoftware.com/], though there have been no + updates to this version since April of 2010.

Version History

About SQLite.NET

What's New?

Using this library

SQLite.NET Provider Features

Distributing the Binaries (Desktop)

Distributing the Binaries (Compact Framework)

Version History

Build Product Names

Canonical Source Code

Verify All Release Packages

Update Downloads Page