These environment variables are used to control several features of - the System.Data.SQLite library. All of these environment variables - are optional. -

- - None of these environment variables are supported by the Compact - Framework builds of System.Data.SQLite, due to limitations imposed - by the platform itself. - -

- - - - - - - - - - - - - - - - - - - - - - - - - -

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.82.0 - September XX, 2012

Updated to SQLite 3.7.14.
Properly handle quoted data source values in the connection string. Fix for [8c3bee31c8].
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.
Add the ability to skip expanding data source file names to their fully qualified paths via the new ToFullPath 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.

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. "082"). The + the System.Data.SQLite library (e.g. "081"). 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.hhc ================================================================== --- Doc/SQLite.NET.hhc +++ Doc/SQLite.NET.hhc @@ -16,14 +16,10 @@

- Official NuGet Packages -
	- System.Data.SQLite.1.0.81.1.nupkg - - (2.80 MiB) -	- This NuGet package contains all the binaries for both the x86 and x64 - versions of System.Data.SQLite 1.0.81.0 (3.7.12.1). The .NET Framework - 3.5 SP1 or 4.0 is required. For the included native binaries, the version - of the Visual C++ runtime corresponding to the .NET Framework used by the - associated managed assembly is statically linked. - - (sha1: c9caf814f914231f18ec61214245b49f5a07731d) -
	- System.Data.SQLite.MSIL.1.0.81.0.nupkg - - (267 KiB) -	- This NuGet package contains the managed binaries for System.Data.SQLite - 1.0.81.0. The .NET Framework 3.5 SP1 or 4.0 is required. - - This NuGet package does not include any code from the native - SQLite core library and will not work properly without the native assembly - "SQLite.Interop.dll" compiled for the processor architecture of - the parent process being present in a directory in the native library - search path. - - (sha1: e018c036ca199fab0f382150dff09cc78b0c054e) -
	- System.Data.SQLite.x86.1.0.81.0.nupkg - - (1.45 MiB) -	- This NuGet package contains all the binaries for the x86 version of - System.Data.SQLite 1.0.81.0 (3.7.12.1). The .NET Framework 3.5 SP1 or 4.0 - is required. For the included native binaries, the version of the Visual - C++ runtime corresponding to the .NET Framework used by the associated - managed assembly is statically linked. - - (sha1: dffd9693454e6e466490ee21f6d693891663eb40) -
	- System.Data.SQLite.x64.1.0.81.0.nupkg - - (1.65 MiB) -	- This NuGet package contains all the binaries for the x64 version of - System.Data.SQLite 1.0.81.0 (3.7.12.1). The .NET Framework 3.5 SP1 or 4.0 - is required. For the included native binaries, the version of the Visual - C++ runtime corresponding to the .NET Framework used by the associated - managed assembly is statically linked. - - (sha1: 0ab4adad078a1bab25bb9369a2303d19251bb3e1) -
Legacy Versions