System.Data.SQLite
Check-in [6d3877ca4d]
Not logged in

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

Overview
Comment:1.0.21 RTM
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: 6d3877ca4db5ad27f8ad7dcad5acf914ede6aeaa
User & Date: rmsimpson 2005-11-03 20:25:58
Context
2005-11-03
20:30
no message check-in: 6748d3069f user: rmsimpson tags: sourceforge
20:25
1.0.21 RTM check-in: 6d3877ca4d user: rmsimpson tags: sourceforge
2005-10-19
17:34
1.0.20 check-in: e9a77782dc user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to SQLite.NET.sln.

     8      8   EndProject
     9      9   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "test", "test\test.csproj", "{E27B1B1E-19C0-45E8-AA74-B6E1C041A130}"
    10     10   	ProjectSection(ProjectDependencies) = postProject
    11     11   		{10B51CE8-A838-44DE-BD82-B658F0296F80} = {10B51CE8-A838-44DE-BD82-B658F0296F80}
    12     12   	EndProjectSection
    13     13   EndProject
    14     14   Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{39A3B743-1EBD-4CC0-8E37-ACE3DD38B1C0}"
    15         -	ProjectSection(SolutionItems) = postProject
           15  +	ProjectSection(SolutionItems) = preProject
    16     16   		readme.htm = readme.htm
    17     17   	EndProjectSection
    18     18   EndProject
    19     19   Project("{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}") = "SQLite.Interop", "SQLite.Interop\SQLite.Interop.vcproj", "{10B51CE8-A838-44DE-BD82-B658F0296F80}"
    20     20   EndProject
    21     21   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "testce", "testce\testce.csproj", "{B86CE504-C4E4-496F-A0F0-E613BCFD3DF7}"
           22  +	ProjectSection(ProjectDependencies) = postProject
           23  +		{AC139951-261A-4463-B6FA-AEBC25283A66} = {AC139951-261A-4463-B6FA-AEBC25283A66}
           24  +	EndProjectSection
    22     25   EndProject
    23     26   Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLite.Designer", "SQLite.Designer\SQLite.Designer.csproj", "{9B4A5CF6-5BE5-4926-ACC7-B729A8C05198}"
    24     27   EndProject
    25     28   Global
    26     29   	GlobalSection(SolutionConfigurationPlatforms) = preSolution
    27     30   		Debug|Compact Framework = Debug|Compact Framework
    28     31   		Debug|Itanium = Debug|Itanium

Changes to bin/CompactFramework/SQLite.Interop.dll.

cannot compute difference between binary files

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

cannot compute difference between binary files

Changes to bin/CompactFramework/testce.exe.

cannot compute difference between binary files

Changes to bin/Designer/Install.cmd.

    20     20   GOTO ParseCmdLine
    21     21   
    22     22   :Main
    23     23   
    24     24   ECHO Installing DDEX Data Provider for SQLite
    25     25   ECHO   VS Registry Root: %REGROOT%
    26     26   ECHO   XML File Path:    %XMLPATH%
           27  +ECHO   SQLite.DLL Path:  %MYDIR%..\
    27     28   
    28     29   IF NOT EXIST "%XMLPATH%\SQLiteDataViewSupport.xml" ECHO The data view support XML file was not found.& GOTO End
    29     30   IF NOT EXIST "%XMLPATH%\SQLiteDataObjectSupport.xml" ECHO The data object support XML file was not found.& GOTO End
           31  +IF NOT EXIST "..\System.Data.SQLite.DLL" ECHO The ..\System.Data.SQLite.DLL could not be found.& GOTO End
    30     32   
    31     33   CScript "%MYDIR%\Install.vbs" //NoLogo "%REGROOT%" "%XMLPATH%"
    32     34   
    33     35   GOTO End
    34     36   
    35     37   :Help
    36     38   

Changes to bin/Designer/SQLite.Designer.dll.

cannot compute difference between binary files

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

cannot compute difference between binary files

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

cannot compute difference between binary files

Changes to bin/test.exe.

cannot compute difference between binary files

Changes to bin/test.exe.config.

     1      1   <configuration>
     2      2     <system.data>
     3      3       <DbProviderFactories>
            4  +      <remove invariant="System.Data.SQLite"/>
     4      5         <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
     5      6       </DbProviderFactories>
     6      7     </system.data>
     7      8   </configuration>

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

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.20 - Oct 19, 2005<br>
            8  +    Version 1.0.21- Nov 4, 2005<br>
     9      9       Interop using SQLite 3.2.7<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       <br>
    13         -    This provider was written and tested using the Visual Studio 2005 Team System 
    14         -    Release Candidate<br>
    15         -    VS2005 Beta 2 users should continue using the 1.0.18.1 release.<br>
    16         -    <br>
    17     13       The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2">
    18     14         here</a>
    19     15       <br>
    20     16       <br>
    21     17       <b></b>
    22     18       <h2>
    23     19         <b>Features:</b><br>
................................................................................
    76     72           your commercial project, please read the previous sentence again -- only slower 
    77     73           and sound out the words this time.
    78     74         </LI>
    79     75       </UL>
    80     76       <strong></strong>
    81     77       <h2>
    82     78         <strong>Design-Time Support (new as of 1.0.14)</strong></h2>
    83         -    <P>Until an installer is created, the steps for registering the provider for 
    84         -      design-time support are:</P>
    85         -    <OL>
    86         -      <LI>
    87         -        Register the <STRONG>System.Data.SQLite.DLL</STRONG> in the Global Assembly 
    88         -        Cache either by using the .Net 2.0 version of GACUTIL, or through <STRONG>Administrative 
    89         -          Tools -&gt; Microsoft .NET Framework 2.0 Configuration</STRONG>.
    90         -      <LI>
    91         -        Through a command-prompt or Windows Explorer, navigate to the <STRONG>SQLite.NET\bin\Designer</STRONG>
           79  +    <P>Until an installer is created, through a command-prompt or Windows Explorer, navigate to the <STRONG>SQLite.NET\bin\Designer</STRONG>
    92     80           folder and execute the <STRONG>INSTALL.CMD</STRONG>
    93         -      file.
    94         -      <LI>
    95         -        <STRONG>NOTE:&nbsp; Enabling Design-Time support for SQLite causes the SQLite 
    96         -          Provider to be registered in your machine.config.</STRONG>&nbsp;&nbsp; If you 
    97         -        have already added the XML shown below to your <STRONG>app.config</STRONG> in 
    98         -        your applications, <STRONG>you need to remove it.</STRONG>&nbsp; If you 
    99         -      don't, it will cause a unique constraint violation when you run your program.
   100         -      <LI>
   101         -        Delete the <STRONG>test.exe.config</STRONG> file from the <STRONG>SQLite.NET\bin</STRONG>
   102         -        folder -- it is no longer necessary.</LI></OL>
           81  +      file.&nbsp; The script and
           82  +      batch file will register the System.Data.SQLite DLL in the Global Assembly Cache,
           83  +      and modify the machine.config file to add SQLite to the list of default data providers.</P>
   103     84       <H2><STRONG>DbFactory Support (Non-Compact Framework)</STRONG></H2>
   104     85       In order to use the SQLiteFactory and have the SQLite data provider enumerated 
   105         -    in the DbProviderFactories methods, you must add the following segment into 
   106         -    either your application's app.config or the system's machine.config located in 
   107         -    the %SystemRoot%\Microsoft.Net\Framework\v2.xxxx\Config folder:<br>
           86  +    in the DbProviderFactories methods, you must add the following segment into your application's app.config file:<br>
   108     87       <br>
   109     88       <pre>&lt;configuration&gt;
   110     89     &lt;system.data&gt;
   111     90       &lt;DbProviderFactories&gt;
   112         -      &lt;add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"<BR > type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.19.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /&gt;
           91  +      &lt;remove invariant="System.Data.SQLite"/&gt;
           92  +      &lt;add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite"<BR > type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /&gt;
   113     93       &lt;/DbProviderFactories&gt;
   114     94     &lt;/system.data&gt;
   115     95   &lt;/configuration&gt;
   116     96   </pre>
   117         -    <P>If you choose to install the Visual Studio Design-Time support for SQLite, you 
   118         -      must not add the above XML to your app.config.&nbsp; The installer will have 
   119         -      already added it to your machine's machine.config file.</P>
           97  +    <p>See the help documentation for further details on implementing both version-specific (GAC enabled) and version independent DBProviderFactories support.
           98  +      </p>
   120     99       <h3>
   121    100         Compiling for the Compact Framework</h3>
   122    101       <p>
   123    102         Just change the target platform from Win32 to Compact Framework and 
   124    103         recompile.&nbsp; <STRONG>The Compact Framework has no support for enumerating 
   125    104           attributes in an assembly, therefore all user-defined collating sequences and 
   126    105           functions must be explicitly registered.</STRONG>&nbsp; See the <STRONG>testce</STRONG>
................................................................................
   140    119         folder must be distributed with your application(s).&nbsp; They contain the 
   141    120         managed wrapper and the native SQLite3 codebase respectively.&nbsp; The Compact 
   142    121         Framework does not currently support managed C++, thus the reason for two 
   143    122         files.</P>
   144    123       <H2><B>Development Notes Regarding the SQLite 3 Source Code</B></H2>
   145    124       <p></p>
   146    125       <p>
   147         -      Steps for merging the sqlite3 core codebase:</p>
   148         -    <p>
   149         -      <strong>This section is obsolete, but remains for historical purposes.&nbsp; The 
   150         -        1.0.11+ versions of the ADO.NET 2.0 SQLite provider make significant changes to 
   151         -        the core sqlite3 codebase in order to support C++ /clr compiling.&nbsp; 
   152         -        Specifically, all the implicit casts throughout the core codebase must be 
   153         -        modified.&nbsp; There are several hundred of these casts and they must be fixed 
   154         -        up every time a new sqlite version is released.</strong></p>
          126  +      Steps for merging the sqlite3 core codebase (without Compact Framework support --
          127  +      that's another story):</p>
   155    128       <ol>
   156    129         <li>
   157         -        <FONT color="silver">Download the latest sqlite3 source from </FONT><a href="http://www.sqlite.org/download.html">
   158         -          <FONT color="silver">http://www.sqlite.org/download.html</FONT></a><FONT color="silver">
   159         -        </FONT>
          130  +        Download the latest sqlite3 source from <a href="http://www.sqlite.org/download.html">
          131  +          http://www.sqlite.org/download.html</a>
          132  +        
   160    133         <li>
   161         -        <FONT color="silver">Extract the source code to the <b>SQLite.Interop\src</b> directory 
   162         -          of this project </FONT>
          134  +        Extract the source code to the <b>SQLite.Interop\src</b> directory 
          135  +          of this project 
   163    136         <li>
   164         -        <FONT color="silver">Open the <b>src\select.c</b> file. </FONT>
          137  +        Open the <b>src\select.c</b> file. 
   165    138         <li>
   166         -        <FONT color="silver">Add <b>#include "../interop.h" </b>to the top of the file 
   167         -          where the other include's are. </FONT>
          139  +        Add <b>#include "../interop.h" </b>to the top of the file 
          140  +          where the other include's are. 
   168    141         <li>
   169         -        <FONT color="silver">Scroll down the <b>select.c</b> file to around line <b>748</b>.&nbsp; 
          142  +        Scroll down the <b>select.c</b> file to around line <b>822</b>.&nbsp; 
   170    143             Change the name of the function <b>static void generateColumnNames </b>to <b>static 
   171    144               void _generateColumnNames</b> (<i>note the underscore in front of the name</i>).
   172         -        </FONT>
          145  +        
   173    146         <li>
   174         -        <FONT color="silver">Compile it. </FONT>
          147  +        Compile it. 
   175    148         </li>
   176    149       </ol>
   177    150       <b></b>
   178    151       <h2>
   179    152         <b>Version History</b></h2>
          153  +    <p><b>1.0.21 - November 4, 2005</b></p>
          154  +    <UL>
          155  +      <li>Fixed a designer bug when creating typed datasets with parameterized queries.</li>
          156  +      <li>The above fix then exposed another bug in the datareader's ability to query schema
          157  +        information on parameterized commands, which was also fixed.</li>
          158  +      <li>Compiled against the RTM version of VS2005.</li>
          159  +      <li>Rewrote the design-time install script to use the XML DOM objects when writing
          160  +        to the machine.config and to automatically register the DLL in the GAC.</li><li>Made changes to the app.config descriptions and help file to improve version-independent
          161  +        factory support.</li></UL>
   180    162       <p><b>1.0.20 - October 19, 2005</b></p>
   181    163       <UL>
   182    164         <li>
   183         -      Fixed a shortcut in SQLiteBase.GetValue which was insufficient for international
   184         -      environments.&nbsp; The shortcut was removed and the "proper" procedure put in.</UL>
          165  +        Fixed a shortcut in SQLiteBase.GetValue which was insufficient for 
          166  +        international environments.&nbsp; The shortcut was removed and the "proper" 
          167  +        procedure put in.</li></UL>
   185    168       <p><b>1.0.19 - October 5, 2005</b></p>
   186    169       <UL>
   187    170         <li>
   188    171         Code merge with SQLite 3.2.7
   189    172         <LI>
   190    173         Fixed bugs in the CE port code (os_wince.c)&nbsp;which were brought to 
   191    174         light&nbsp;by&nbsp;recent changes in the SQLite engine.