System.Data.SQLite
Check-in [a9cc9e2eba]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:1.0.39.0
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: a9cc9e2eba2fe3d397be118352866a3adcf85afe
User & Date: rmsimpson 2007-01-10 18:58:10
Context
2007-01-10
19:14
1.0.39.0 check-in: 89d321e778 user: rmsimpson tags: sourceforge
18:58
1.0.39.0 check-in: a9cc9e2eba user: rmsimpson tags: sourceforge
18:50
Temporary fix for CE check-in: cb13e676d0 user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/dbfactorysupport.html.

    93     93   <configuration>
    94     94     <system.data>
    95     95       <DbProviderFactories>
    96     96         <remove invariant="System.Data.SQLite"/>
    97     97         <add name="SQLite Data Provider" invariant="System.Data.SQLite" 
    98     98              description=".Net Framework Data Provider for SQLite"
    99     99              type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite,
   100         -                 Version=1.0.38.0, Culture=neutral,
          100  +                 Version=1.0.39.0, Culture=neutral,
   101    101                    PublicKeyToken=db937bc2d44ff139"/>
   102    102       </DbProviderFactories>
   103    103     </system.data>
   104    104   </configuration>
   105    105   </pre>
   106    106         </div>
   107    107         <p>

Changes to Doc/Extra/version.html.

    52     52           </tr>
    53     53         </table>
    54     54       </div>
    55     55       <div id="mainSection">
    56     56       <div id="mainBody">
    57     57   
    58     58         <h1 class="heading">Version History</h1>
           59  +    <p><b>1.0.39.0 - January 10, 2007</b></p>
           60  +    <ul>
           61  +    <li>Code merge with SQLite 3.3.10</li>
           62  +      <li>Fixed a multi-threaded race condition bug in the garbage collector when commands
           63  +        and/or connections are not properly disposed by the user.</li>
           64  +      <li>Switched the encryption's internal deallocation code to use sqlite's built-in
           65  +        aux functions instead of modifying the pager.c source to free the crypt block.&nbsp;
           66  +        This eliminates the last of the code changes the provider makes to the original
           67  +        sqlite engine sources.&nbsp; Props to Ralf Junker for pointing that out.</li>
           68  +    </ul>
    59     69       <p><b>1.0.38.0 - November 22, 2006</b></p>
    60     70       <ul>
    61     71       <li>Fixed a bug when using CommandBehavior.KeyInfo whereby integer primary key columns may be duplicated in the results. </li>
    62     72         <li>Enhanced the CommandBuilder so that update/delete statements are optimized when the affected table contains unique constraints and
    63     73         a primary key is present.</li>
    64     74         <li>Fixed a bug in the DataReader when used in conjunction with CommandBehavior.CloseConnection.</li></ul>
    65     75       <p><b>1.0.37.0 - November 19, 2006</b></p>

Changes to Doc/SQLite.NET.chm.

cannot compute difference between binary files

Changes to SQLite.Interop/SQLite.Interop.vcproj.

    31     31   			ConfigurationType="2"
    32     32   			CharacterSet="2"
    33     33   			ManagedExtensions="0"
    34     34   			WholeProgramOptimization="1"
    35     35   			>
    36     36   			<Tool
    37     37   				Name="VCPreBuildEventTool"
    38         -				Description="Fixing sources ..."
    39         -				CommandLine="CScript //nologo fixsource.vbs&#x0D;&#x0A;rem cd ..\System.Data.SQLite&#x0D;&#x0A;rem resgen /compile SR.resx&#x0D;&#x0A;rem csc /target:module /out:..\SQLite.Interop\SQlite.netmodule /debug- /o+  SQLite3.cs SQLite3_UTF16.cs SQLiteBase.cs SQLiteCommand.cs SQLiteCommandBuilder.cs SQLiteConnection.cs SQLiteConnectionStringBuilder.cs SQLiteConvert.cs SQLiteDataAdapter.cs SQLiteDataReader.cs SQLiteException.cs SQLiteFactory.cs SQLiteFunction.cs SQLiteFunctionAttribute.cs SQLiteParameter.cs SQLiteParameterCollection.cs SQLiteStatement.cs SQLiteTransaction.cs UnsafeNativeMethods.cs AssemblyInfo.cs SR.Designer.cs&#x0D;&#x0A;rem cd ..\SQLite.Interop&#x0D;&#x0A;"
           38  +				CommandLine=""
    40     39   			/>
    41     40   			<Tool
    42     41   				Name="VCCustomBuildTool"
    43     42   			/>
    44     43   			<Tool
    45     44   				Name="VCXMLDataGeneratorTool"
    46     45   			/>
................................................................................
   119    118   			IntermediateDirectory="Pocket PC 2003 (ARMV4)\$(ConfigurationName)"
   120    119   			ConfigurationType="2"
   121    120   			CharacterSet="1"
   122    121   			WholeProgramOptimization="0"
   123    122   			>
   124    123   			<Tool
   125    124   				Name="VCPreBuildEventTool"
   126         -				Description="Preparing build ..."
   127         -				CommandLine="CScript //nologo fixsource.vbs&#x0D;&#x0A;"
          125  +				CommandLine=""
   128    126   			/>
   129    127   			<Tool
   130    128   				Name="VCCustomBuildTool"
   131    129   			/>
   132    130   			<Tool
   133    131   				Name="VCXMLDataGeneratorTool"
   134    132   			/>
................................................................................
   137    135   			/>
   138    136   			<Tool
   139    137   				Name="VCMIDLTool"
   140    138   			/>
   141    139   			<Tool
   142    140   				Name="VCCLCompilerTool"
   143    141   				ExecutionBucket="7"
          142  +				InlineFunctionExpansion="1"
   144    143   				PreprocessorDefinitions="_WIN32_WCE=$(CEVER);UNDER_CE=$(CEVER);WINCE;$(PLATFORMDEFINES);NDEBUG;_WINDOWS;_USRDLL;CPPSMART_EXPORTS;$(ARCHFAM);$(_ARCHFAM_);UNICODE;_UNICODE;SQLITE_HAS_CODEC;SQLITE_ENABLE_COLUMN_METADATA;SQLITE_ENABLE_FTS1"
   145    144   				StringPooling="true"
   146    145   				ExceptionHandling="0"
   147    146   				BufferSecurityCheck="false"
          147  +				EnableFunctionLevelLinking="true"
   148    148   			/>
   149    149   			<Tool
   150    150   				Name="VCManagedResourceCompilerTool"
   151    151   			/>
   152    152   			<Tool
   153    153   				Name="VCResourceCompilerTool"
   154    154   				PreprocessorDefinitions="NDEBUG;_UNICODE;UNICODE;_WIN32_WCE;UNDER_CE"
................................................................................
   204    204   			ConfigurationType="2"
   205    205   			CharacterSet="2"
   206    206   			ManagedExtensions="0"
   207    207   			WholeProgramOptimization="1"
   208    208   			>
   209    209   			<Tool
   210    210   				Name="VCPreBuildEventTool"
   211         -				Description="Fixing sources ..."
   212         -				CommandLine="CScript //nologo fixsource.vbs&#x0D;&#x0A;rem cd ..\System.Data.SQLite&#x0D;&#x0A;rem resgen /compile SR.resx&#x0D;&#x0A;rem csc /target:module /out:..\SQLite.Interop\SQlite.netmodule /debug- /o+  SQLite3.cs SQLite3_UTF16.cs SQLiteBase.cs SQLiteCommand.cs SQLiteCommandBuilder.cs SQLiteConnection.cs SQLiteConnectionStringBuilder.cs SQLiteConvert.cs SQLiteDataAdapter.cs SQLiteDataReader.cs SQLiteException.cs SQLiteFactory.cs SQLiteFunction.cs SQLiteFunctionAttribute.cs SQLiteParameter.cs SQLiteParameterCollection.cs SQLiteStatement.cs SQLiteTransaction.cs UnsafeNativeMethods.cs AssemblyInfo.cs SR.Designer.cs&#x0D;&#x0A;rem cd ..\SQLite.Interop&#x0D;&#x0A;"
          211  +				CommandLine=""
   213    212   			/>
   214    213   			<Tool
   215    214   				Name="VCCustomBuildTool"
   216    215   			/>
   217    216   			<Tool
   218    217   				Name="VCXMLDataGeneratorTool"
   219    218   			/>
................................................................................
   292    291   			ConfigurationType="2"
   293    292   			CharacterSet="2"
   294    293   			ManagedExtensions="0"
   295    294   			WholeProgramOptimization="1"
   296    295   			>
   297    296   			<Tool
   298    297   				Name="VCPreBuildEventTool"
   299         -				Description="Fixing sources ..."
   300         -				CommandLine="CScript //nologo fixsource.vbs&#x0D;&#x0A;rem cd ..\System.Data.SQLite&#x0D;&#x0A;rem resgen /compile SR.resx&#x0D;&#x0A;rem csc /target:module /out:..\SQLite.Interop\SQlite.netmodule /debug- /o+  SQLite3.cs SQLite3_UTF16.cs SQLiteBase.cs SQLiteCommand.cs SQLiteCommandBuilder.cs SQLiteConnection.cs SQLiteConnectionStringBuilder.cs SQLiteConvert.cs SQLiteDataAdapter.cs SQLiteDataReader.cs SQLiteException.cs SQLiteFactory.cs SQLiteFunction.cs SQLiteFunctionAttribute.cs SQLiteParameter.cs SQLiteParameterCollection.cs SQLiteStatement.cs SQLiteTransaction.cs UnsafeNativeMethods.cs AssemblyInfo.cs SR.Designer.cs&#x0D;&#x0A;rem cd ..\SQLite.Interop&#x0D;&#x0A;"
          298  +				CommandLine=""
   301    299   			/>
   302    300   			<Tool
   303    301   				Name="VCCustomBuildTool"
   304    302   			/>
   305    303   			<Tool
   306    304   				Name="VCXMLDataGeneratorTool"
   307    305   			/>
................................................................................
   380    378   			ConfigurationType="2"
   381    379   			CharacterSet="2"
   382    380   			ManagedExtensions="0"
   383    381   			WholeProgramOptimization="0"
   384    382   			>
   385    383   			<Tool
   386    384   				Name="VCPreBuildEventTool"
   387         -				Description="Fixing up sources ..."
   388         -				CommandLine="CScript //nologo fixsource.vbs"
          385  +				CommandLine=""
   389    386   			/>
   390    387   			<Tool
   391    388   				Name="VCCustomBuildTool"
   392    389   			/>
   393    390   			<Tool
   394    391   				Name="VCXMLDataGeneratorTool"
   395    392   			/>
................................................................................
   462    459   			IntermediateDirectory="Pocket PC 2003 (ARMV4)\$(ConfigurationName)"
   463    460   			ConfigurationType="2"
   464    461   			CharacterSet="1"
   465    462   			WholeProgramOptimization="0"
   466    463   			>
   467    464   			<Tool
   468    465   				Name="VCPreBuildEventTool"
   469         -				Description="Fixing up sources ..."
   470         -				CommandLine="CScript //nologo fixsource.vbs"
          466  +				CommandLine=""
   471    467   			/>
   472    468   			<Tool
   473    469   				Name="VCCustomBuildTool"
   474    470   			/>
   475    471   			<Tool
   476    472   				Name="VCXMLDataGeneratorTool"
   477    473   			/>
................................................................................
   548    544   			ConfigurationType="2"
   549    545   			CharacterSet="2"
   550    546   			ManagedExtensions="0"
   551    547   			WholeProgramOptimization="0"
   552    548   			>
   553    549   			<Tool
   554    550   				Name="VCPreBuildEventTool"
   555         -				Description="Fixing up sources ..."
   556         -				CommandLine="CScript //nologo fixsource.vbs"
          551  +				CommandLine=""
   557    552   			/>
   558    553   			<Tool
   559    554   				Name="VCCustomBuildTool"
   560    555   			/>
   561    556   			<Tool
   562    557   				Name="VCXMLDataGeneratorTool"
   563    558   			/>
................................................................................
   631    626   			ConfigurationType="2"
   632    627   			CharacterSet="2"
   633    628   			ManagedExtensions="0"
   634    629   			WholeProgramOptimization="0"
   635    630   			>
   636    631   			<Tool
   637    632   				Name="VCPreBuildEventTool"
   638         -				Description="Fixing up sources ..."
   639         -				CommandLine="CScript //nologo fixsource.vbs"
          633  +				CommandLine=""
   640    634   			/>
   641    635   			<Tool
   642    636   				Name="VCCustomBuildTool"
   643    637   			/>
   644    638   			<Tool
   645    639   				Name="VCXMLDataGeneratorTool"
   646    640   			/>
................................................................................
   987    981   			<File
   988    982   				RelativePath=".\src\utf.c"
   989    983   				>
   990    984   			</File>
   991    985   			<File
   992    986   				RelativePath=".\src\util.c"
   993    987   				>
          988  +				<FileConfiguration
          989  +					Name="Release|Pocket PC 2003 (ARMV4)"
          990  +					>
          991  +					<Tool
          992  +						Name="VCCLCompilerTool"
          993  +						Optimization="0"
          994  +					/>
          995  +				</FileConfiguration>
   994    996   			</File>
   995    997   			<File
   996    998   				RelativePath=".\src\vacuum.c"
   997    999   				>
   998   1000   			</File>
   999   1001   			<File
  1000   1002   				RelativePath=".\src\vdbe.c"

Changes to SQLite.Interop/merge.h.

     1      1   // This code was automatically generated from assembly
     2      2   // C:\Src\SQLite.NET\System.Data.SQLite\bin\CompactFramework\System.Data.SQLite.dll
     3      3   
     4      4   #include <windef.h>
     5      5   
     6      6   #pragma data_seg(".clr")
     7      7   #pragma comment(linker, "/SECTION:.clr,ER")
     8         -  char __ph[128212] = {0}; // The number of bytes to reserve
            8  +  char __ph[128492] = {0}; // The number of bytes to reserve
     9      9   #pragma data_seg()
    10     10   
    11     11   typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
    12     12   typedef struct EXTRA_STUFF
    13     13   {
    14     14     DWORD dwNativeEntryPoint;
    15     15   } EXTRA_STUFF, *LPEXTRA_STUFF;

Changes to SQLite.Interop/merge_full.h.

     1      1   // This code was automatically generated from assembly
     2      2   // C:\Src\SQLite.NET\System.Data.SQLite\bin\System.Data.SQLite.dll
     3      3   
     4      4   #include <windef.h>
     5      5   
     6      6   #pragma data_seg(".clr")
     7      7   #pragma comment(linker, "/SECTION:.clr,ER")
     8         -  char __ph[137404] = {0}; // The number of bytes to reserve
            8  +  char __ph[137688] = {0}; // The number of bytes to reserve
     9      9   #pragma data_seg()
    10     10   
    11     11   typedef BOOL (WINAPI *DLLMAIN)(HANDLE, DWORD, LPVOID);
    12     12   typedef struct EXTRA_STUFF
    13     13   {
    14     14     DWORD dwNativeEntryPoint;
    15     15   } EXTRA_STUFF, *LPEXTRA_STUFF;

Changes to System.Data.SQLite/AssemblyInfo.cs.

    44     44   //      Major Version
    45     45   //      Minor Version 
    46     46   //      Build Number
    47     47   //      Revision
    48     48   //
    49     49   // You can specify all the values or you can default the Revision and Build Numbers 
    50     50   // by using the '*' as shown below:
    51         -[assembly: AssemblyVersion("1.0.38.0")]
           51  +[assembly: AssemblyVersion("1.0.39.0")]
    52     52   #if !PLATFORM_COMPACTFRAMEWORK
    53         -[assembly: AssemblyFileVersion("1.0.38.0")]
           53  +[assembly: AssemblyFileVersion("1.0.39.0")]
    54     54   #endif

Changes to bin/CompactFramework/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to bin/CompactFramework/System.Data.SQLite.lib.

cannot compute difference between binary files

Changes to bin/CompactFramework/testce.exe.

cannot compute difference between binary files

Changes to bin/System.Data.SQLite.dll.

cannot compute difference between binary files

Changes to bin/System.Data.SQLite.lib.

cannot compute difference between binary files

Changes to bin/itanium/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to bin/itanium/System.Data.SQLite.lib.

cannot compute difference between binary files

Changes to bin/test.exe.

cannot compute difference between binary files

Changes to bin/x64/System.Data.SQLite.DLL.

cannot compute difference between binary files

Changes to bin/x64/System.Data.SQLite.lib.

cannot compute difference between binary files

Changes to readme.htm.

     1      1   <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
     2      2   <html>
     3      3     <head>
     4      4       <title></title>
     5      5     </head>
     6      6     <body>
     7      7       ADO.NET 2.0 SQLite Data Provider<br>
     8         -    Version 1.0.38.0 November 22, 2006<br>
     9         -    Using SQLite 3.3.8<br>
            8  +    Version 1.0.39.0 January 10, 2007<br>
            9  +    Using SQLite 3.3.10<br>
    10     10       Written by Robert Simpson (<a href="mailto:robert@blackcastlesoft.com">robert@blackcastlesoft.com</a>)<br>
    11     11       Released to the public domain, use at your own risk!<br>
    12     12       Official provider website:&nbsp; <a href="http://sqlite.phxsoftware.com">http://sqlite.phxsoftware.com</a><br />
    13     13       <br>
    14     14       The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2">
    15     15         here</a>
    16     16       <br>
................................................................................
    70     70         Full support for user-defined collating sequences, every bit as simple to 
    71     71         implement as user-defined functions and uses the same base class.
    72     72         <LI>
    73     73           Full source for the entire engine and wrapper.&nbsp; No copyrights.&nbsp; 
    74     74           Public Domain.&nbsp; 100% free for commercial and non-commercial use.&nbsp;</LI></UL>
    75     75       <strong></strong>
    76     76       <h2>
    77         -      <strong>Design-Time Support (new as of 1.0.14)</strong></h2>
           77  +      <strong>Design-Time Support</strong></h2>
    78     78       <P>
    79     79         In Windows Explorer, navigate to the <STRONG>SQLite.NET\bin\Designer</STRONG>
    80     80           folder and execute the <STRONG>INSTALL.EXE</STRONG>
    81     81         file.&nbsp; The program will
    82     82         automatically detect what version(s) of Visual Studio 2005 are installed and allow
    83     83         you to selectively install and uninstall the designer for each edition.</P>
    84     84       <H2><STRONG>DbFactory Support (Non-Compact Framework)</STRONG></H2>
................................................................................
   109    109         <b><A name="redist"></A>Distributing The SQLite Engine and ADO.NET Assembly</b></h2>
   110    110       <P>
   111    111         Only the <STRONG>System.Data.SQLite.DLL</STRONG> file needs to be distributed with your 
   112    112         application(s).&nbsp; This DLL contains both the managed wrapper and the native 
   113    113         SQLite3 codebase.</P>
   114    114       <H2><B>Development Notes Regarding the SQLite 3 Source Code</B></H2>
   115    115       <p>
   116         -      The SQLite3 source code is compiled directly from the SQLite.org release
   117         -      sources.&nbsp; All builds of sqlite after 3.2.8 have included support for Windows CE.&nbsp; Additionally,
   118         -      just one minor modification is made to pager.c, that modification is made automatically by the fixsource.vbs file
   119         -      when the VS2005 solution is compiled.</p>
          116  +      The core sqlite engine is compiled directly from the unmodified source code available
          117  +      at the sqlite.org website.&nbsp; Several additional pieces are compiled on top of
          118  +      it to extend its functionality, but the core engine's source is not changed.</p>
   120    119       <p></p>
   121    120       <p>
   122    121         <b>Version History</b></p>
          122  +    <p><b>1.0.39.0 - January 10, 2007</b></p>
          123  +    <ul>
          124  +    <li>Code merge with SQLite 3.3.10</li>
          125  +      <li>Fixed a multi-threaded race condition bug in the garbage collector when commands
          126  +        and/or connections are not properly disposed by the user. </li>
          127  +      <li>Switched the encryption's internal deallocation code to use sqlite's built-in
          128  +        aux functions instead of modifying the pager.c source to free the crypt block.&nbsp;
          129  +        This eliminates the last of the code changes the provider makes to the original
          130  +        sqlite engine sources.&nbsp; Props to Ralf Junker for pointing that out.</li>
          131  +    </ul>
   123    132       <p><b>1.0.38.0 - November 22, 2006</b></p>
   124    133       <ul>
   125    134       <li>Fixed a bug when using CommandBehavior.KeyInfo whereby integer primary key columns may be duplicated in the results. </li>
   126    135         <li>Enhanced the CommandBuilder so that update/delete statements are optimized when the affected table contains unique constraints and
   127    136         a primary key is present.</li>
   128    137         <li>Fixed a bug in the DataReader when used in conjunction with CommandBehavior.CloseConnection.</li></ul>
   129    138       <p><b>1.0.37.0 - November 19, 2006</b></p>