Version History

1.0.39.0 - January 10, 2007

Code merge with SQLite 3.3.10
Fixed a multi-threaded race condition bug in the garbage collector when commands + and/or connections are not properly disposed by the user.
Switched the encryption's internal deallocation code to use sqlite's built-in + aux functions instead of modifying the pager.c source to free the crypt block. + This eliminates the last of the code changes the provider makes to the original + sqlite engine sources. Props to Ralf Junker for pointing that out.

1.0.38.0 - November 22, 2006

Fixed a bug when using CommandBehavior.KeyInfo whereby integer primary key columns may be duplicated in the results.
Enhanced the CommandBuilder so that update/delete statements are optimized when the affected table contains unique constraints and a primary key is present.

+ + + Index: SQLite.Interop/merge.h ================================================================== --- SQLite.Interop/merge.h +++ SQLite.Interop/merge.h @@ -3,11 +3,11 @@ #include #pragma data_seg(".clr") #pragma comment(linker, "/SECTION:.clr,ER") - char __ph[128212] = {0}; // The number of bytes to reserve + char __ph[128492] = {0}; // The number of bytes to reserve #pragma data_seg() typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID); typedef struct EXTRA_STUFF { Index: SQLite.Interop/merge_full.h ================================================================== --- SQLite.Interop/merge_full.h +++ SQLite.Interop/merge_full.h @@ -3,11 +3,11 @@ #include #pragma data_seg(".clr") #pragma comment(linker, "/SECTION:.clr,ER") - char __ph[137404] = {0}; // The number of bytes to reserve + char __ph[137688] = {0}; // The number of bytes to reserve #pragma data_seg() typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID); typedef struct EXTRA_STUFF { Index: System.Data.SQLite/AssemblyInfo.cs ================================================================== --- System.Data.SQLite/AssemblyInfo.cs +++ System.Data.SQLite/AssemblyInfo.cs @@ -46,9 +46,9 @@ // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: -[assembly: AssemblyVersion("1.0.38.0")] +[assembly: AssemblyVersion("1.0.39.0")] #if !PLATFORM_COMPACTFRAMEWORK -[assembly: AssemblyFileVersion("1.0.38.0")] +[assembly: AssemblyFileVersion("1.0.39.0")] #endif Index: bin/CompactFramework/System.Data.SQLite.DLL ================================================================== --- bin/CompactFramework/System.Data.SQLite.DLL +++ bin/CompactFramework/System.Data.SQLite.DLL cannot compute difference between binary files Index: bin/CompactFramework/System.Data.SQLite.lib ================================================================== --- bin/CompactFramework/System.Data.SQLite.lib +++ bin/CompactFramework/System.Data.SQLite.lib cannot compute difference between binary files Index: bin/CompactFramework/testce.exe ================================================================== --- bin/CompactFramework/testce.exe +++ bin/CompactFramework/testce.exe cannot compute difference between binary files Index: bin/System.Data.SQLite.dll ================================================================== --- bin/System.Data.SQLite.dll +++ bin/System.Data.SQLite.dll cannot compute difference between binary files Index: bin/System.Data.SQLite.lib ================================================================== --- bin/System.Data.SQLite.lib +++ bin/System.Data.SQLite.lib cannot compute difference between binary files Index: bin/itanium/System.Data.SQLite.DLL ================================================================== --- bin/itanium/System.Data.SQLite.DLL +++ bin/itanium/System.Data.SQLite.DLL cannot compute difference between binary files Index: bin/itanium/System.Data.SQLite.lib ================================================================== --- bin/itanium/System.Data.SQLite.lib +++ bin/itanium/System.Data.SQLite.lib cannot compute difference between binary files Index: bin/test.exe ================================================================== --- bin/test.exe +++ bin/test.exe cannot compute difference between binary files Index: bin/x64/System.Data.SQLite.DLL ================================================================== --- bin/x64/System.Data.SQLite.DLL +++ bin/x64/System.Data.SQLite.DLL cannot compute difference between binary files Index: bin/x64/System.Data.SQLite.lib ================================================================== --- bin/x64/System.Data.SQLite.lib +++ bin/x64/System.Data.SQLite.lib cannot compute difference between binary files Index: readme.htm ================================================================== --- readme.htm +++ readme.htm @@ -3,12 +3,12 @@ ADO.NET 2.0 SQLite Data Provider
- Version 1.0.38.0 November 22, 2006
- Using SQLite 3.3.8
+ Version 1.0.39.0 January 10, 2007
+ Using SQLite 3.3.10
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 @@ -72,11 +72,11 @@

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

- Design-Time Support (new as of 1.0.14)

+ 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 are installed and allow @@ -111,17 +111,26 @@ 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 SQLite3 source code is compiled directly from the SQLite.org release - sources. All builds of sqlite after 3.2.8 have included support for Windows CE. Additionally, - just one minor modification is made to pager.c, that modification is made automatically by the fixsource.vbs file - when the VS2005 solution is compiled.

+ 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.39.0 - January 10, 2007

Code merge with SQLite 3.3.10
Fixed a multi-threaded race condition bug in the garbage collector when commands + and/or connections are not properly disposed by the user.
Switched the encryption's internal deallocation code to use sqlite's built-in + aux functions instead of modifying the pager.c source to free the crypt block. + This eliminates the last of the code changes the provider makes to the original + sqlite engine sources. Props to Ralf Junker for pointing that out.

1.0.38.0 - November 22, 2006

Fixed a bug when using CommandBehavior.KeyInfo whereby integer primary key columns may be duplicated in the results.
Enhanced the CommandBuilder so that update/delete statements are optimized when the affected table contains unique constraints and a primary key is present.