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: |
6d3877ca4db5ad27f8ad7dcad5acf914 |
| 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
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 -> 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: Enabling Design-Time support for SQLite causes the SQLite 96 - Provider to be registered in your machine.config.</STRONG> 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> 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. 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><configuration> 110 89 <system.data> 111 90 <DbProviderFactories> 112 - <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" /> 91 + <remove invariant="System.Data.SQLite"/> 92 + <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" /> 113 93 </DbProviderFactories> 114 94 </system.data> 115 95 </configuration> 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. 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. <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> See the <STRONG>testce</STRONG> ................................................................................ 140 119 folder must be distributed with your application(s). They contain the 141 120 managed wrapper and the native SQLite3 codebase respectively. 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. 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. 152 - Specifically, all the implicit casts throughout the core codebase must be 153 - modified. 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>. 142 + Scroll down the <b>select.c</b> file to around line <b>822</b>. 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. 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. 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) which were brought to 191 174 light by recent changes in the SQLite engine.