Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch httpsLinks Excluding Merge-Ins
This is equivalent to a diff from ee4f54fca8 to 192aebcb1d
2015-02-09
| ||
21:56 | Change links to HTTPS, where applicable. check-in: 2683c27f12 user: mistachkin tags: trunk | |
21:53 | Document an additional requirement for using Entity Framework 6 design-time integration on the download page. check-in: 4130454d42 user: mistachkin tags: trunk | |
21:20 | Change links to HTTPS, where applicable. Closed-Leaf check-in: 192aebcb1d user: mistachkin tags: httpsLinks | |
2015-02-07
| ||
02:48 | Merge updates from trunk. check-in: d345593dba user: mistachkin tags: preRelease | |
01:14 | Switch to Visual C++ Redistributable for Visual Studio 2012 Update 4. Update the master release archive manifest. check-in: ee4f54fca8 user: mistachkin tags: trunk | |
2015-02-06
| ||
23:06 | Modify the XDT transform used by the EF6 NuGet packages to omit removal of the EF6 provider itself. check-in: 7737ecc51b user: mistachkin tags: trunk | |
Changes to Doc/Extra/Provider/optimizing.html.
︙ | ︙ | |||
43 44 45 46 47 48 49 | <div id="mainSection"> <div id="mainBody"> <h1 class="heading">Tips on Optimizing Your Queries</h1> <p>The next few paragraphs will attempt to give you a few rudimentary rules for speeding up your queries in general, and especially how SQLite is adversely affected by the kinds of SQL behaviors you may have taken for granted in other providers. It is by no means a complete optimization guide. For even more | | | 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | <div id="mainSection"> <div id="mainBody"> <h1 class="heading">Tips on Optimizing Your Queries</h1> <p>The next few paragraphs will attempt to give you a few rudimentary rules for speeding up your queries in general, and especially how SQLite is adversely affected by the kinds of SQL behaviors you may have taken for granted in other providers. It is by no means a complete optimization guide. For even more details on optimizing your queries, visit <a href="https://www.sqlite.org">sqlite.org</a>.</p> <h4 class="subHeading">The Importance of Transactions</h4> <p>If you are inserting data in SQLite without first starting a transaction: <b>DO NOT PASS GO! Call BeginTransaction() right now, and finish with Commit()!</b> If you think I'm kidding, think again. SQLite's A.C.I.D. design means that every single time you insert any data outside a transaction, an implicit transaction is constructed, the insert made, and the transaction destructed. <b>EVERY TIME.</b> If you're wondering why in the world your inserts are taking 100x |
︙ | ︙ |
Changes to Doc/Extra/Provider/version.html.
︙ | ︙ | |||
41 42 43 44 45 46 47 | </table> </div> <div id="mainSection"> <div id="mainBody"> <h1 class="heading">Version History</h1> <p><b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b></p> <ul> | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 | </table> </div> <div id="mainSection"> <div id="mainBody"> <h1 class="heading">Version History</h1> <p><b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li> <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li> <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for <a href="https://system.data.sqlite.org/index.html/info/56f511d268">[56f511d268]</a>.</li> <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for <a href="https://system.data.sqlite.org/index.html/info/85b824b736">[85b824b736]</a>.</li> <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e122d26e70">[e122d26e70]</a>.</li> <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for <a href="https://system.data.sqlite.org/index.html/info/daeaf3150a">[daeaf3150a]</a>.</li> <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for <a href="https://system.data.sqlite.org/index.html/info/0a32885109">[0a32885109]</a>.</li> <li>In the SQLiteDataReader.VerifyType method, remove duplicate "if" statement for the DbType.SByte value and move the remaining "if" to the Int64 affinity. Fix for <a href="https://system.data.sqlite.org/index.html/info/c5cc2fb334">[c5cc2fb334]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for <a href="https://system.data.sqlite.org/index.html/info/3e783eecbe">[3e783eecbe]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for <a href="https://system.data.sqlite.org/index.html/info/e796ac82c1">[e796ac82c1]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied before the PostBuildEvent. Fix for <a href="https://system.data.sqlite.org/index.html/info/f16c93a932">[f16c93a932]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for <a href="https://system.data.sqlite.org/index.html/info/47c6fa04d3">[47c6fa04d3]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li> <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li> <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for <a href="https://system.data.sqlite.org/index.html/info/8d928c3e88">[8d928c3e88]</a>. <b>** Potentially Incompatible Change **</b></li> </ul> <p><b>1.0.94.0 - September 9, 2014</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li> <li>Refactor and simplify NuGet packages in order to support per-solution SQLite interop assembly files. <b>** Potentially Incompatible Change **</b></li> <li>Add RefreshFlags method to the SQLiteDataReader class to forcibly refresh its connection flags.</li> <li>Improve automatic detection and handling of the Entity Framework 6 assembly by the design-time components installer. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e634e330a6">[e634e330a6]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Improve SQLiteDataReader performance slightly by caching the connection flags. <b>** Potentially Incompatible Change **</b></li> <li>Add ClearCachedSettings method to the SQLiteConnection class.</li> <li>Add NoConvertSettings connection flag to disable querying of runtime configuration settings from within the SQLiteConvert class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/58ed318f2f">[58ed318f2f]</a>.</li> <li>Minimize usage of the "Use_SQLiteConvert_DefaultDbType" and "Use_SQLiteConvert_DefaultTypeName" settings. Fix for <a href="https://system.data.sqlite.org/index.html/info/58ed318f2f">[58ed318f2f]</a>. <b>** Potentially Incompatible Change **</b></li> </ul> <p><b>1.0.93.0 - June 23, 2014</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_5.html">SQLite 3.8.5</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1">Entity Framework 6.1</a>.</li> <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/56b42d99c1">[56b42d99c1]</a>.</li> <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/3c00ec5b52">[3c00ec5b52]</a>.</li> <li>Add DetectTextAffinity and DetectStringType connection flags to enable automatic detection of column types, when necessary. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/3c00ec5b52">[3c00ec5b52]</a>.</li> <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li> <li>Add SharedFlags static property to the SQLiteConnection class.</li> <li>Make the ISQLiteSchemaExtensions interface public. <b>** Potentially Incompatible Change **</b></li> <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li> <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li> <li>Fix DateTime constant handling in the LINQ assembly. Fix for <a href="https://system.data.sqlite.org/index.html/info/da9f18d039">[da9f18d039]</a>. <b>** Potentially Incompatible Change **</b></li> </ul> <p><b>1.0.92.0 - March 19, 2014</p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_4_1.html">SQLite 3.8.4.1</a>.</li> <li>Update the list of keywords returned by SQLiteConnection.GetSchema("ReservedWords"). <b>** Potentially Incompatible Change **</b></li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand or SQLiteDataReader object is closed or disposed.</li> <li>Add the SQLiteDataReader.StepCount property to return the number of rows seen so far.</li> <li>Add StickyHasRows connection flag to cause the SQLiteDataReader.HasRows property to return non-zero if there were ever any rows in the associated result sets.</li> <li>When the TraceWarning connection flag is set, issue warnings about possibly malformed UNC paths. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/283344397b">[283344397b]</a>.</li> <li>Convert the primary NuGet package, "System.Data.SQLite", into a meta-package.</li> <li>Enhancements to the NuGet packages, including the new "modular" packages.</li> </ul> <p><b>1.0.91.0 - February 12, 2014</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_3_1.html">SQLite 3.8.3.1</a>.</li> <li>Refresh all included SQLite core library documentation (e.g. SQL syntax).</li> <li>Add support for <a href="https://entityframework.codeplex.com/">Entity Framework 6</a>.</li> <li>Add support for per-connection mappings between type names and DbType values. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e87af1d06a">[e87af1d06a]</a>.</li> <li>Modify the namespace used for all internal classes in the System.Data.SQLite.Linq assembly. <b>** Potentially Incompatible Change **</b></li> <li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li> <li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li> <li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li> <li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/a47eff2c71">[a47eff2c71]</a>.</li> <li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to <a href="https://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>.</li> <li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li> <li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/f0246d1817">[f0246d1817]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for <a href="https://system.data.sqlite.org/index.html/info/0550f0326e">[0550f0326e]</a>.</li> </ul> <p><b>1.0.90.0 - December 23, 2013</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li> <li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2013 support to the redesigned designer support installer.</li> <li>Add support for Windows Embedded Compact 2013.</li> <li>Add experimental support for the native regexp extension.</li> <li>Never create a new connection wrapper in the SQLiteConnection.Shutdown method. <b>** Potentially Incompatible Change **</b></li> <li>Add experimental GetMemoryStatistics, ReleaseMemory, and Shutdown methods to the SQLiteConnection class.</li> <li>Add memory leak detection to the test project for the .NET Compact Framework.</li> <li>Add SQLITE_ENABLE_MEMORY_MANAGEMENT compile-time option to the interop assembly.</li> <li>Use current isolation level when enlisting into an existing transaction. Fix for <a href="https://system.data.sqlite.org/index.html/info/56b42d99c1">[56b42d99c1]</a>.</li> <li>Better handling of non-error log messages from the SQLite core library. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/44df10ea90">[44df10ea90]</a>.</li> <li>Add TraceWarning connection flag to enable tracing of type mapping failures and disable tracing of them by default. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/6d45c782e4">[6d45c782e4]</a>.</li> <li>Use 32-bit values to keep track of numeric precision and scale when building the schema table for a query. Fix for <a href="https://system.data.sqlite.org/index.html/info/ef2216192d">[ef2216192d]</a>.</li> </ul> <p><b>1.0.89.0 - October 28, 2013</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_1.html">SQLite 3.8.1</a>.</li> <li>Add AutoCommit property to the SQLiteConnection class. Fix for <a href="https://system.data.sqlite.org/index.html/info/9ba9346f75">[9ba9346f75]</a>.</li> <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for <a href="https://system.data.sqlite.org/index.html/info/3113734605">[3113734605]</a>.</li> <li>Check the result of sqlite3_column_name function against NULL.</li> <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for <a href="https://system.data.sqlite.org/index.html/info/aba4549801">[aba4549801]</a>.</li> <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li> <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the database cannot be changed by a query when the CommandBehavior.SchemaOnly flag is used. Fix for <a href="https://system.data.sqlite.org/index.html/info/f8dbab8baf">[f8dbab8baf]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Fix bug in <a href="http://sourceforge.net/projects/ndoc3/">NDoc3</a> that was preventing some of the MSDN documentation links from working.</li> <li>Include the XML documentation files in the NuGet packages. Fix for <a href="https://system.data.sqlite.org/index.html/info/5970d5b0a6">[5970d5b0a6]</a>.</li> <li>Add InteropVersion, InteropSourceId, ProviderVersion, and ProviderSourceId properties to the SQLiteConnection class.</li> <li>Add experimental support for interfacing with the authorizer callback in the SQLite core library.</li> <li>Add experimental support for the native totype extension.</li> </ul> <p><b>1.0.88.0 - August 7, 2013</b></p> <ul> <li>Various fixes to managed virtual table integration infrastructure.</li> <li>Implement workaround for an incorrect PROCESSOR_ARCHITECTURE being reported. Fix for <a href="https://system.data.sqlite.org/index.html/info/9ac9862611">[9ac9862611]</a>.</li> <li>Modify classes that implement the IDisposable pattern to set the disposed flag after their base classes have been disposed.</li> <li>When automatically registering custom functions, use the executing assembly (i.e. System.Data.SQLite) for reference detection. Fix for <a href="https://system.data.sqlite.org/index.html/info/4e49a58c4c">[4e49a58c4c]</a>.</li> </ul> <p><b>1.0.87.0 - July 8, 2013</b></p> <ul> <li>Add all the necessary infrastructure to allow virtual tables to be implemented in managed code. Fix for <a href="https://system.data.sqlite.org/index.html/info/9a544991be">[9a544991be]</a>.</li> <li>The DbType to type name translation needs to prioritize the Entity Framework type names. Fix for <a href="https://system.data.sqlite.org/index.html/info/47f4bac575">[47f4bac575]</a>.</li> <li>Add DateTimeFormatString connection string property to allow the DateTime format string used for all parsing and formatting to be overridden.</li> <li>Add NoFunctions connection flag to skip binding functions registered in the application domain.</li> <li>Add several data-types for compatibility purposes. Fix for <a href="https://system.data.sqlite.org/index.html/info/fe50b8c2e8">[fe50b8c2e8]</a>.</li> <li>Add SQLiteConnection.BindFunction method to facilitate adding custom functions on a per-connection basis.</li> <li>When reading a DateTime value, avoid unnecessary string conversions. Fix for <a href="https://system.data.sqlite.org/index.html/info/4d87fbc742">[4d87fbc742]</a>.</li> <li>Modify the index introspection code so that it does not treat PRAGMA table_info "pk" column values as boolean. Fix for <a href="https://system.data.sqlite.org/index.html/info/f2c47a01eb">[f2c47a01eb]</a>.</li> <li>Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/bbdda6eae2">[bbdda6eae2]</a>.</li> <li>Rename the ReturnCode property of the SQLiteException class to ResultCode. <b>** Potentially Incompatible Change **</b></li> </ul> <p><b>1.0.86.0 - May 23, 2013</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_17.html">SQLite 3.7.17</a>.</li> <li>Disable use of the AllowPartiallyTrustedCallers attribute when compiled for the .NET Framework 4.0/4.5. <b>** Potentially Incompatible Change **</b></li> <li>Allow semi-colons in the data source file name. Fix for <a href="https://system.data.sqlite.org/index.html/info/48a6b8e4ca">[e47b3d8346]</a>. <b>** Potentially Incompatible Change **</b></li> <li>NULL values should be reported as type "object", not "DBNull". Fix for <a href="https://system.data.sqlite.org/index.html/info/48a6b8e4ca">[48a6b8e4ca]</a>.</li> </ul> <p><b>1.0.85.0 - April 18, 2013</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_16_2.html">SQLite 3.7.16.2</a>.</li> <li>Properly handle embedded NUL characters in parameter and column values. Fix for <a href="https://system.data.sqlite.org/index.html/info/3567020edf">[3567020edf]</a>.</li> <li>Make use of the sqlite3_prepare_v2 function when applicable.</li> <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li> <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li> <li>Support automated testing when running on the .NET Compact Framework 2.0.</li> <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e4c8121f7b">[e4c8121f7b]</a>.</li> <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/1c456ae75f">[1c456ae75f]</a>.</li> <li>Add static Execute method to the SQLiteCommand class.</li> <li>Support custom connection pool implementations by adding the ISQLiteConnectionPool interface, the static SQLiteConnection.ConnectionPool property, and the static CreateHandle method in addition to modifying the SQLiteConnectionPool class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/393d954be0">[393d954be0]</a>.</li> <li>Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.</li> <li>When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.</li> <li>Support automatic value conversions for columns with a declared type of BIGUINT, INTEGER8, INTEGER16, INTEGER32, INTEGER64, SMALLUINT, TINYSINT, UNSIGNEDINTEGER, UNSIGNEDINTEGER8, UNSIGNEDINTEGER16, UNSIGNEDINTEGER32, UNSIGNEDINTEGER64, INT8, INT16, INT32, INT64, UINT, UINT8, UINT16, UINT32, UINT64, or ULONG.</li> <li>Add BindUInt32AsInt64 connection flag to force binding of UInt32 values as Int64 instead. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/c010fa6584">[c010fa6584]</a>.</li> <li>Add BindAllAsText and GetAllAsText connection flags to force binding and returning of all values as text.</li> <li>Remove AUTOINCREMENT from the column type name map. <b>** Potentially Incompatible Change **</b></li> <li>Avoid throwing overflow exceptions from the SQLite3.GetValue method for integral column types. Partial fix for <a href="https://system.data.sqlite.org/index.html/info/c010fa6584">[c010fa6584]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Use the legacy connection closing algorithm when built with the INTEROP_LEGACY_CLOSE compile-time option.</li> <li>Support using the directory containing the primary managed-only assembly as the basis for native library pre-loading.</li> <li>Still further enhancements to the build and test automation.</li> </ul> <p><b>1.0.84.0 - January 9, 2013</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_15_2.html">SQLite 3.7.15.2</a>.</li> <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for <a href="https://system.data.sqlite.org/index.html/info/6434e23a0f">[6434e23a0f]</a>.</li> <li>Add Cancel method to the SQLiteConnection class to interrupt a long running query.</li> <li>Improve thread safety of the SQLiteLog.LogMessage method.</li> </ul> <p><b>1.0.83.0 - December 29, 2012</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_15_1.html">SQLite 3.7.15.1</a>.</li> <li>Add Visual Studio 2012 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2012 support to the redesigned designer support installer.</li> <li>Allow opened connections to skip adding the extension functions included in the interop assembly via the new NoExtensionFunctions connection flag.</li> <li>Support loading of SQLite extensions via the new EnableExtensions and LoadExtension methods of the SQLiteConnection class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/17045010df">[17045010df]</a>.</li> <li>Remove one set of surrounding single or double quotes from property names and values parsed from the connection string. Fix for <a href="https://system.data.sqlite.org/index.html/info/b4cc611998">[b4cc611998]</a>.</li> <li>Modify parsing of connection strings to allow property names and values to be quoted. <b>** Potentially Incompatible Change **</b></li> <li>Add ParseViaFramework property to the SQLiteConnection class to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/b4cc611998">[b4cc611998]</a>.</li> <li>Add notifications before and after any connection is opened and closed, as well as other related notifications, via the new static Changed event.</li> <li>Add an overload of the SQLiteLog.LogMessage method that takes a single string parameter.</li> <li>Add an overload of the SQLiteConnection.LogMessage method that takes a SQLiteErrorCode parameter.</li> <li>All applicable calls into the SQLite core library now return a SQLiteErrorCode instead of an integer error code.</li> <li>Make sure the error code of the SQLiteException class gets serialized.</li> <li>Make the test project for the .NET Compact Framework more flexible.</li> <li>When available, the new sqlite3_errstr function from the core library is used to get the error message for a specific return code.</li> <li>The SetMemoryStatus, Shutdown, ResultCode, ExtendedResultCode, and SetAvRetry methods of the SQLiteConnection class now return a SQLiteErrorCode instead of an integer error code. <b>** Potentially Incompatible Change **</b></li> <li>The public constructor for the SQLiteException now takes a SQLiteErrorCode instead of an integer error code. <b>** Potentially Incompatible Change **</b></li> <li>The ErrorCode property of the SQLiteException is now an Int32, to allow the property inherited from the base class to be properly overridden. <b>** Potentially Incompatible Change **</b></li> <li>The ErrorCode field of the LogEventArgs is now an object instead of an integer. <b>** Potentially Incompatible Change **</b></li> <li>The names and messages associated with the SQLiteErrorCode enumeration values have been normalized to match those in the SQLite core library. <b>** Potentially Incompatible Change **</b></li> <li>Implement more robust locking semantics for the CriticalHandle derived classes when compiled for the .NET Compact Framework.</li> <li>Cache column indexes as they are looked up when using the SQLiteDataReader to improve performance.</li> <li>Prevent the SQLiteConnection.Close method from throwing non-fatal exceptions during its disposal.</li> <li>Rename the interop assembly functions sqlite3_cursor_rowid, sqlite3_context_collcompare, sqlite3_context_collseq, sqlite3_cursor_rowid, and sqlite3_table_cursor to include an "_interop" suffix. <b>** Potentially Incompatible Change **</b></li> <li>Prevent the LastInsertRowId, MemoryUsed, and MemoryHighwater connection properties from throwing NotSupportedException when running on the .NET Compact Framework. Fix for <a href="https://system.data.sqlite.org/index.html/info/dd45aba387">[dd45aba387]</a>.</li> <li>Improve automatic detection of the sqlite3_close_v2 function when compiled to use the standard SQLite library.</li> <li>Add protection against ThreadAbortException asynchronously interrupting native resource initialization and finalization.</li> <li>Add native logging callback for use with the sqlite3_log function to the interop assembly, enabled via the INTEROP_LOG preprocessor definition.</li> <li>Add various diagnostic messages to the interop assembly, enabled via flags in the INTEROP_DEBUG preprocessor definition.</li> <li>Further enhancements to the build and test automation.</li> <li>Add test automation for the Windows CE binaries.</li> </ul> <p><b>1.0.82.0 - September 3, 2012</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_14.html">SQLite 3.7.14</a>.</li> <li>Properly handle quoted data source values in the connection string. Fix for <a href="https://system.data.sqlite.org/index.html/info/8c3bee31c8">[8c3bee31c8]</a>.</li> <li>The <a href="https://www.nuget.org/packages/System.Data.SQLite">primary NuGet package</a> now supports x86 / x64 and the .NET Framework 2.0 / 4.0 (i.e. in a single package).</li> <li>Change the default value for the Synchronous connection string property to Full to match the default used by the SQLite core library itself. <b>** Potentially Incompatible Change **</b></li> <li>Add the ability to skip applying default connection settings to opened databases via the new SetDefaults connection string property.</li> <li>Add the ability to skip expanding data source file names to their fully qualified paths via the new ToFullPath connection string property.</li> <li>Fix the database cleanup ordering in the tests for ticket <a href="https://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li> <li>Add support for the sqlite3_close_v2 function from the SQLite core library.</li> <li>Add support for <a href="https://www.sqlite.org/uri.html">URI file names</a> via the new FullUri connection string property.</li> <li>Improve support for the standard SQLite core library in the LINQ assembly and the test suite.</li> <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li> <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li> <li>Add define constants to support enabling or disabling individual groups of trace statements.</li> </ul> <p><b>1.0.81.0 - May 27, 2012</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_12_1.html">SQLite 3.7.12.1</a>.</li> <li>Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.</li> <li>Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.</li> <li>Add release archive verification tool to the release automation.</li> <li>Fix NullReferenceException when calling the SQLiteDataAdapter.FillSchema method on a query that returns multiple result sets. Fix for <a href="https://system.data.sqlite.org/index.html/info/3aa50d8413">[3aa50d8413]</a>.</li> <li>Fix subtle race condition between threads fetching connection handles from the connection pool and any garbage collection (GC) threads that may be running. Fix for <a href="https://system.data.sqlite.org/index.html/info/996d13cd87">[996d13cd87]</a>.</li> <li>Add missing call to SetTimeout in the SQLite3_UTF16.Open method.</li> <li>Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.</li> <li>Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.</li> <li>Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.</li> <li>Revise CriticalHandle derived classes to make them more thread-safe.</li> <li>Add connection pool related diagnostic messages when compiled with the DEBUG define constant.</li> <li>Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.</li> <li>Rename internal SQLiteLastError methods to GetLastError.</li> <li>Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.</li> </ul> <p><b>1.0.80.0 - April 1, 2012</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_11.html">SQLite 3.7.11</a>.</li> <li>In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for <a href="https://system.data.sqlite.org/index.html/info/8a426d12eb">[8a426d12eb]</a>.</li> <li>Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2005 support to the redesigned designer support installer.</li> <li>Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.</li> <li>Add support for the native <a href="https://www.sqlite.org/backup.html">SQLite Online Backup API</a>. Fix for <a href="https://system.data.sqlite.org/index.html/info/c71846ed57">[c71846ed57]</a>.</li> <li>Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for <a href="https://system.data.sqlite.org/index.html/info/72905c9a77">[72905c9a77]</a>.</li> <li>Support tracing of all parameter binding activity and use the connection flags to control what is traced.</li> <li>When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.</li> <li>Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.</li> <li>Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.</li> <li>In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.</li> <li>Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See <a href="https://system.data.sqlite.org/index.html/info/4bbf851fa5">[4bbf851fa5]</a>.</li> <li>When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case.</li> <li>For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa.</li> <li>Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools.</li> <li>Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it.</li> <li>Add missing CheckDisposed calls to the SQLiteConnection class.</li> <li>Add missing throw statement to the SQLiteConnection class.</li> <li>Make sure the interop project uses /fp:precise for Windows CE.</li> <li>Regenerate package load key to support loading the designer package into Visual Studio 2008 without having the matching SDK installed.</li> <li>Modify transaction object disposal so that it can never cause an exception to be thrown.</li> </ul> <p><b>1.0.79.0 - January 28, 2012</b></p> <ul> <li>Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for <a href="https://system.data.sqlite.org/index.html/info/d8491abd0b">[d8491abd0b]</a>.</li> <li>Correct resource name used by the LINQ assembly to locate several key string resources. Fix for <a href="https://system.data.sqlite.org/index.html/info/fbebb30da9">[fbebb30da9]</a>.</li> </ul> <p><b>1.0.78.0 - January 27, 2012</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_10.html">SQLite 3.7.10</a>.</li> <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> <li>When emitting SQL for foreign keys in the VS designer, be sure to take all returned schema rows into account. Remainder of fix for <a href="https://system.data.sqlite.org/index.html/info/b226147b37">[b226147b37]</a>.</li> <li>Add Flags connection string property to control extra behavioral flags for the connection.</li> <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> <li>Even more enhancements to the build and test automation.</li> <li>Support parameter binding to more primitive types, including unsigned integer types.</li> <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for <a href="https://system.data.sqlite.org/index.html/info/bb4b04d457">[bb4b04d457]</a>.</li> <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for <a href="https://system.data.sqlite.org/index.html/info/3fc172d1be">[3fc172d1be]</a>.</li> <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for <a href="https://system.data.sqlite.org/index.html/info/f3ec1e0066">[f3ec1e0066]</a>.</li> <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for <a href="https://system.data.sqlite.org/index.html/info/4bbf851fa5">[4bbf851fa5]</a>. <b>** Potentially Incompatible Change **</b></li> </ul> <p><b>1.0.77.0 - November 28, 2011</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_9.html">SQLite 3.7.9</a>.</li> <li>More enhancements to the build and test automation.</li> <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> <li>The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer.</li> <li>When compiled with DEBUG defined, emit diagnostic information related to resource cleanup to any TraceListener objects that may be registered.</li> <li>Stop characterizing all log messages as errors. From now on, if the errorCode is zero, the message will not be considered an error.</li> <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for <a href="https://system.data.sqlite.org/index.html/info/2ce0870fad">[2ce0870fad]</a>.</li> <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for <a href="https://system.data.sqlite.org/index.html/info/566f1ad1e4">[566f1ad1e4]</a>.</li> <li>When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for <a href="https://system.data.sqlite.org/index.html/info/7e3fa93744">[7e3fa93744]</a>.</li> <li>When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for <a href="https://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li> <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li> <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li> <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for <a href="https://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>. <b>** Potentially Incompatible Change **</b></li> <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li> <li>Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for <a href="https://system.data.sqlite.org/index.html/info/737ca4ff74">[737ca4ff74]</a>.</li> <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for <a href="https://system.data.sqlite.org/index.html/info/544dba0a2f">[544dba0a2f]</a>.</li> <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for <a href="https://system.data.sqlite.org/index.html/info/84718e79fa">[84718e79fa]</a>.</li> </ul> <p><b>1.0.76.0 - October 4, 2011</b></p> <ul> <li>Prevent the domain unload event handler in SQLiteLog from being registered multiple times. Fix for <a href="https://system.data.sqlite.org/index.html/info/0d5b1ef362">[0d5b1ef362]</a>.</li> <li>Stop allowing non-default application domains to initialize the SQLiteLog class. Fix for <a href="https://system.data.sqlite.org/index.html/info/ac47dd230a">[ac47dd230a]</a>.</li> </ul> <p><b>1.0.75.0 - October 3, 2011</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_8.html">SQLite 3.7.8</a>.</li> <li>More enhancements to the build system.</li> <li>Add official <a href="https://www.nuget.org/">NuGet</a> packages for x86 and x64.</li> <li>Add Changes and LastInsertRowId properties to the connection class.</li> <li>Support more formats when converting data from/to the DateTime type.</li> <li>Make all the assembly versioning attributes consistent.</li> <li>Add unit testing infrastructure using <a href="http://eagle.to/">Eagle</a>.</li> <li>Integrate all legacy unit tests, including the "testlinq" project, into the new test suite.</li> <li>Add projects to build the interop assembly statically linked to the Visual C++ runtime. Fix for <a href="https://system.data.sqlite.org/index.html/info/53f0c5cbf6">[53f0c5cbf6]</a>.</li> <li>Add SQLITE_ENABLE_STAT2 compile-time option to the interop assembly. Fix for <a href="https://system.data.sqlite.org/index.html/info/74807fbf27">[74807fbf27]</a>.</li> <li>Fix mutex issues exposed when running the test suite with the debug version of SQLite.</li> <li>Fix transaction enlistment when repeated attempts are made to enlist in the same transaction. Fix for <a href="https://system.data.sqlite.org/index.html/info/ccfa69fc32">[ccfa69fc32]</a>.</li> <li>Support the SQLITE_FCNTL_WIN32_AV_RETRY file control to mitigate the impact of file sharing violations caused by external processes.</li> <li>Refactor the logging interface to be thread-safe and self-initializing.</li> <li>Shutdown the SQLite native interface when the AppDomain is being unloaded. Fix for <a href="https://system.data.sqlite.org/index.html/info/b4a7ddc83f">[b4a7ddc83f]</a>.</li> <li>Support Skip operation for LINQ using OFFSET. Fix for <a href="https://system.data.sqlite.org/index.html/info/8b7d179c3c">[8b7d179c3c]</a>.</li> <li>Support EndsWith operation for LINQ using SUBSTR. Fix for <a href="https://system.data.sqlite.org/index.html/info/59edc1018b">[59edc1018b]</a>.</li> <li>Support all SQLite journal modes. Fix for <a href="https://system.data.sqlite.org/index.html/info/448d663d11">[448d663d11]</a>.</li> <li>Do not throw exceptions when disposing SQLiteDataReader. Fix for <a href="https://system.data.sqlite.org/index.html/info/e1b2e0f769">[e1b2e0f769]</a>.</li> <li>The REAL type should be mapped to System.Double. Fix for <a href="https://system.data.sqlite.org/index.html/info/2c630bffa7">[2c630bffa7]</a> and <a href="https://system.data.sqlite.org/index.html/info/b0a5990f48">[b0a5990f48]</a>.</li> <li>Minor optimization to GetParamValueBytes(). Fix for <a href="https://system.data.sqlite.org/index.html/info/201128cc88">[201128cc88]</a>.</li> <li>Support the ON UPDATE, ON DELETE, and MATCH clause information when generating schema metadata for foreign keys. Partial fix for <a href="https://system.data.sqlite.org/index.html/info/b226147b37">[b226147b37]</a>. VS designer changes are not yet tested.</li> <li>Fix incorrect resource name for SR.resx in the mixed-mode assembly.</li> <li>Reduce the number of String.Compare() calls in the hot path for SQLiteCommand.ExecuteReader().</li> </ul> <p><b>1.0.74.0 - July 4, 2011</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_7_1.html">SQLite 3.7.7.1</a>.</li> <li>Fix incorrect hard-coded .NET Framework version information SQLiteFactory_Linq.cs that was causing IServiceProvider.GetService to fail when running against the .NET Framework 3.5.</li> <li>Fix all XML documentation warnings.</li> <li>Restore support for the mixed-mode assembly (i.e. the one that can be registered in the Global Assembly Cache).</li> <li>Restore support for the Compact Framework.</li> <li>Remove unused "using" statements from the System.Data.SQLite and System.Data.SQLite.Linq projects.</li> <li>Remove hard-coded System.Data.SQLite.Linq version from SQLiteFactory_Linq.cs</li> <li>Modify the setup to support bundled packages (i.e. with the mixed-mode assembly) and standard packages (i.e. with the managed assembly separate from the native interop library).</li> <li>Disable the ability to register with the Global Assembly Cache in the standard setup package (i.e. it is available in the bundled setup only).</li> <li>Remove PATH modification from the setup.</li> <li>Modify the naming scheme for the source, setup, and binary packages to allow for the necessary variants.</li> <li>In the build automation, attempt to automatically detect if Visual Studio 2008 and/or 2010 are installed and support building binaries for both at once, when available.</li> <li>Add release automation to build the source, setup, and binary packages in all supported build variants.</li> <li>Add the testlinq project to the new build system and make it work properly with Visual Studio 2008 and 2010.</li> </ul> <p><b>1.0.73.0 - June 2, 2011</b></p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_6_3.html">SQLite 3.7.6.3</a>.</li> <li>Minor optimization to GetBytes(). Fix for <a href="https://system.data.sqlite.org/index.html/info/8c1650482e">[8c1650482e]</a>.</li> <li>Update various assembly information settings.</li> <li>Correct System.Data.SQLite.Linq version and resource information. Fix for <a href="https://system.data.sqlite.org/index.html/info/6489c5a396">[6489c5a396]</a> and <a href="https://system.data.sqlite.org/index.html/info/133daf50d6">[133daf50d6]</a>.</li> <li>Moved log handler from SQLiteConnection object to SQLiteFactory object to prevent if from being prematurely GCed.</li> <li>We should block x64 installs on x86 and we should install native only if the setup package itself is native. Fix for <a href="https://system.data.sqlite.org/index.html/info/e058ce156e">[e058ce156e]</a>.</li> </ul> <p><b>1.0.72.0 - May 1, 2011</b></p> <ul> <li>Add the correct directory to the path. Fix for <a href="https://system.data.sqlite.org/index.html/info/50515a0c8e">[50515a0c8e]</a>.</li> </ul> <p><b>1.0.71.0 - April 27, 2011</b></p> <ul> <li>Updated to SQLite 3.7.6+ <a href="https://www.sqlite.org/src/info/1bd1484cd7">[1bd1484cd7]</a> to get additional Windows error logging.</li> <li>Updated setup to optionally add install directory to PATH if GAC option selected.</li> </ul> <p><b>1.0.70.0 - April 22, 2011</b></p> <ul> <li>Added support for sqlite3_extended_result_codes(), sqlite3_errcode(), and sqlite3_extended_errcode() via SetExtendedResultCodes(), ResultCode(), and ExtendedResultCode().</li> <li>Added support for SQLITE_CONFIG_LOG via SQLiteLogEventHandler().</li> </ul> <p><b>1.0.69.0 - April 12, 2011</b></p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_6.html">SQLite 3.7.6</a>.</li> <li>New VS2008 and VS2010 solution files.</li> <li>Build and packaging automation.</li> <li>New Inno Setup files.</li> <li>Designer support currently not ready for release.</li> </ul> <p><b>1.0.68.0 - February 2011</b></p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_5.html">SQLite 3.7.5</a>.</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> <p><b>1.0.67.0 - January 3, 2011</b></p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_4.html">SQLite 3.7.4</a>.</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> <p><b>1.0.66.1 - August 1, 2010</b></p> <ul> <li>Code merge with SQLite 3.7.0.1</li> <li>Re-enabled VS2005 designer support, broken in previous versions during the 2008 transition</li> <li>Implemented new forms of Take/Skip in the EF framework courtesy jlsantiago</li> |
︙ | ︙ | |||
444 445 446 447 448 449 450 | <li>Fixed an out of memory error in the trigger designer in cases where a WHEN clause is used in the trigger</li> </ul> <p><b>1.0.65.0 - July 26, 2009</b></p> <ul> <li>Fixed a bug in the encryption module to prevent a double free() when rekeying a database.</li> <li>Fixed a bug in the encryption module when ATTACHing an encrypted database.</li> <li>Incorporated the WinCE locking fix from ticket | | | 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 | <li>Fixed an out of memory error in the trigger designer in cases where a WHEN clause is used in the trigger</li> </ul> <p><b>1.0.65.0 - July 26, 2009</b></p> <ul> <li>Fixed a bug in the encryption module to prevent a double free() when rekeying a database.</li> <li>Fixed a bug in the encryption module when ATTACHing an encrypted database.</li> <li>Incorporated the WinCE locking fix from ticket <a href="https://www.sqlite.org/cvstrac/tktview?tn=3991">#3991</a></li> <li>Added "bigint" to the dropdown in the table designer, plus other minor table designer bugfixes.</li> </ul> <p><b>1.0.64.0 - July 9, 2009</b></p> <ul> <li>Fixed the missing resources problem from the 63 release.</li> <li>Added preliminary support for the Visual Studio 2010 beta.</li> |
︙ | ︙ | |||
501 502 503 504 505 506 507 | <ul> <li>Throw a NotSupported exception in the EF Sql Gen code instead of parsing illegal SQL during an update/insert/delete where no primary key is defined.</li> <li>Fixed the Compact Framework interop library. Since the linker flag /subsystem had no version specified, it was causing a problem for many CE-based platforms.</li> <li>Incorporated SQLite patch for ticket | | | 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 | <ul> <li>Throw a NotSupported exception in the EF Sql Gen code instead of parsing illegal SQL during an update/insert/delete where no primary key is defined.</li> <li>Fixed the Compact Framework interop library. Since the linker flag /subsystem had no version specified, it was causing a problem for many CE-based platforms.</li> <li>Incorporated SQLite patch for ticket <a href="https://www.sqlite.org/cvstrac/tktview?tn=3387">#3387</a> and reverted out the vfs override code I added in build 59 to work around this problem.</li> <li>Fixed a designer issue when creating a new table from the Server Explorer. After initially saving it, if you then continued to edit it and tried to save it again, it would generate the change SQL using the old temporary table name rather than the new name.</li> </ul> <p><b>1.0.59.0 - September 22, 2008</b></p> |
︙ | ︙ | |||
542 543 544 545 546 547 548 | relating to deeply-nested subqueries that the EF SqlGen creates.</li> <li>Fixed the Rollback SQLiteConnection event to not require a connection be opened first.</li> </ul> <p><b>1.0.57.0 - August 29, 2008</b></p> <ul> <li>Compiled against 3.6.1 with checkin | | | 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 | relating to deeply-nested subqueries that the EF SqlGen creates.</li> <li>Fixed the Rollback SQLiteConnection event to not require a connection be opened first.</li> </ul> <p><b>1.0.57.0 - August 29, 2008</b></p> <ul> <li>Compiled against 3.6.1 with checkin <a href="https://www.sqlite.org/cvstrac/tktview?tn=3300">#3300</a> resolved, which fixes an Entity Framework bug I was seeing. I currently have 3 other tickets out on the engine, which are not yet resolved and relate to EF.</li> <li>Fixed decimal types to store and fetch using InvariantCulture. If you're using decimal datatypes in your database and were affected by the 56 release, please issue an UPDATE <table> SET <column> = REPLACE(<column>, ',', '.'); to fix the decimal separators. Apologies for not testing that more thoroughly before releasing 56.</li> |
︙ | ︙ | |||
586 587 588 589 590 591 592 | <li>LINQ to Entities bits heavily updated and compiled against VS2008 SP1 RTM. SQLite LINQ support is still considered beta.</li> </ul> <p><b>1.0.55.0 - August 6, 2008</b></p> <ul> <li>Code merge with SQLite 3.6.1</li> <li>Added support for the user-contributed extension-functions at | | | 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 | <li>LINQ to Entities bits heavily updated and compiled against VS2008 SP1 RTM. SQLite LINQ support is still considered beta.</li> </ul> <p><b>1.0.55.0 - August 6, 2008</b></p> <ul> <li>Code merge with SQLite 3.6.1</li> <li>Added support for the user-contributed extension-functions at <a href="https://www.sqlite.org/contrib">https://www.sqlite.org/contrib</a>. Feel free to override any of them with your own implementation. The new functions are: <i>acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi, replicate, charindex, leftstr, rightstr, reverse, proper, padl, padr, padc, strfilter,</i> and aggregates <i>stdev, variance, mode, median, lower_quartile, upper_quartile.</i></li> <li>Moved the last_rows_affected() function to the C extension library.</li> |
︙ | ︙ |
Changes to Doc/Extra/Provider/welcome.html.
︙ | ︙ | |||
42 43 44 45 46 47 48 | </div> <div id="mainSection"> <div id="mainBody"> <h1 class="heading">About SQLite.NET</h1> <p>This class library is an ADO.NET wrapper around the popular (and free!) SQLite database engine. For information on SQL syntax, features of SQLite and a good understanding of how it works and what it does, I highly recommend heading | | | | | 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 | </div> <div id="mainSection"> <div id="mainBody"> <h1 class="heading">About SQLite.NET</h1> <p>This class library is an ADO.NET wrapper around the popular (and free!) SQLite database engine. For information on SQL syntax, features of SQLite and a good understanding of how it works and what it does, I highly recommend heading over to <a target="_blank" href="https://www.sqlite.org">sqlite.org</a> and reading the documentation there.</p> <P>The C# provider, the very minor C code modifications to SQLite, documentation and etc were written by <A href="mailto:robert@blackcastlesoft.com">Robert Simpson</A>, and the SourceForge project page can be found <A target="_blank" href="http://sourceforge.net/projects/sqlite-dotnet2"> here</A>.</P> <p>The System.Data.SQLite project is currently maintained by the <A target="_blank" href="https://www.sqlite.org/">SQLite Development Team</a> and the latest source code and project information can be found <A target="_blank" href="https://system.data.sqlite.org/">here</A>.</p> <DIV> <br> </DIV> <h1 class="heading">What's New?</h1> <p><a href="version.html">Click here to see the version history of this SQLite.NET provider</a></p> <DIV> |
︙ | ︙ |
Changes to NuGet/SQLite.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Beta</id> <title>System.Data.SQLite (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Beta</id> <title>System.Data.SQLite (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core.Beta</id> <title>System.Data.SQLite Core (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core.Beta</id> <title>System.Data.SQLite Core (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.MSIL.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core.MSIL.Beta</id> <title>System.Data.SQLite (MSIL) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core.MSIL.Beta</id> <title>System.Data.SQLite (MSIL) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.MSIL.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core.MSIL.Test</id> <title>System.Data.SQLite (MSIL) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core.MSIL.Test</id> <title>System.Data.SQLite (MSIL) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.MSIL.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core.MSIL</id> <title>System.Data.SQLite (MSIL)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core.MSIL</id> <title>System.Data.SQLite (MSIL)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core.Test</id> <title>System.Data.SQLite Core (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core.Test</id> <title>System.Data.SQLite Core (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.Core.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Core</id> <title>System.Data.SQLite Core (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Core</id> <title>System.Data.SQLite Core (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>The official SQLite database engine for both x86 and x64 along with the ADO.NET provider.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> </metadata> <files> <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" /> <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" /> <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" /> |
︙ | ︙ |
Changes to NuGet/SQLite.EF6.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.EF6.Beta</id> <title>System.Data.SQLite EF6 (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.EF6.Beta</id> <title>System.Data.SQLite EF6 (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.EF6.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.EF6.Test</id> <title>System.Data.SQLite EF6 (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.EF6.Test</id> <title>System.Data.SQLite EF6 (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.EF6.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.EF6</id> <title>System.Data.SQLite EF6 (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.EF6</id> <title>System.Data.SQLite EF6 (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>Support for Entity Framework 6 using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="System.Data.SQLite.Core" version="1.0.95.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.Linq.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Linq.Beta</id> <title>System.Data.SQLite LINQ (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Linq.Beta</id> <title>System.Data.SQLite LINQ (x86/x64) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.Linq.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Linq.Test</id> <title>System.Data.SQLite LINQ (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Linq.Test</id> <title>System.Data.SQLite LINQ (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.Linq.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Linq</id> <title>System.Data.SQLite LINQ (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Linq</id> <title>System.Data.SQLite LINQ (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>Support for LINQ using System.Data.SQLite.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.MSIL.Beta.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.MSIL.Beta</id> <title>System.Data.SQLite (MSIL) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. This is a legacy package; if possible, please use either the "System.Data.SQLite.Beta" or "System.Data.SQLite.Core.Beta" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.MSIL.Beta</id> <title>System.Data.SQLite (MSIL) Beta</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a "beta" package and is not intended for production use. This is a legacy package; if possible, please use either the "System.Data.SQLite.Beta" or "System.Data.SQLite.Core.Beta" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="EntityFramework" version="6.1.2.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.MSIL.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.MSIL.Test</id> <title>System.Data.SQLite (MSIL) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. This is a legacy package; if possible, please use either the "System.Data.SQLite.Test" or "System.Data.SQLite.Core.Test" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.MSIL.Test</id> <title>System.Data.SQLite (MSIL) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. This is a legacy package; if possible, please use either the "System.Data.SQLite.Test" or "System.Data.SQLite.Core.Test" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="EntityFramework" version="6.1.2.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.MSIL.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.MSIL</id> <title>System.Data.SQLite (MSIL)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.MSIL</id> <title>System.Data.SQLite (MSIL)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. An ADO.NET provider for SQLite (managed-only).</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="EntityFramework" version="6.1.2.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.Test.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite.Test</id> <title>System.Data.SQLite (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite.Test</id> <title>System.Data.SQLite (x86/x64) Test</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a pre-release package and is not intended for production use. The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.nuspec.
︙ | ︙ | |||
11 12 13 14 15 16 17 | <metadata> <id>System.Data.SQLite</id> <title>System.Data.SQLite (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> | | | | | 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <metadata> <id>System.Data.SQLite</id> <title>System.Data.SQLite (x86/x64)</title> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. This package includes support for LINQ and Entity Framework 6.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net20"> <dependency id="System.Data.SQLite.Core" version="1.0.95.0" /> </group> <group targetFramework="net40"> |
︙ | ︙ |
Changes to NuGet/SQLite.x64.nuspec.
︙ | ︙ | |||
10 11 12 13 14 15 16 | <package> <metadata> <id>System.Data.SQLite.x64</id> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x64.</description> <language>en-US</language> | | | | | 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <package> <metadata> <id>System.Data.SQLite.x64</id> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x64.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="EntityFramework" version="6.1.2.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to NuGet/SQLite.x86.nuspec.
︙ | ︙ | |||
10 11 12 13 14 15 16 | <package> <metadata> <id>System.Data.SQLite.x86</id> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x86.</description> <language>en-US</language> | | | | | 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <package> <metadata> <id>System.Data.SQLite.x86</id> <version>1.0.95.0</version> <authors>SQLite Development Team</authors> <description>This is a legacy package; if possible, please use either the "System.Data.SQLite" or "System.Data.SQLite.Core" package instead. The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x86.</description> <language>en-US</language> <projectUrl>https://system.data.sqlite.org/</projectUrl> <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl> <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl> <tags>sqlite database ado.net provider interop</tags> <copyright>Public Domain</copyright> <dependencies> <group targetFramework="net40"> <dependency id="EntityFramework" version="6.1.2.0" /> </group> <group targetFramework="net45"> |
︙ | ︙ |
Changes to SQLite.Designer/AssemblyInfo.cs.
︙ | ︙ | |||
12 13 14 15 16 17 18 | using System.Resources; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Designer")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | using System.Resources; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Designer")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to SQLite.Designer/VSPackage.Designer.cs.
︙ | ︙ | |||
64 65 66 67 68 69 70 | } set { resourceCulture = value; } } /// <summary> | | | 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | } set { resourceCulture = value; } } /// <summary> /// Looks up a localized string similar to PTA9I2P3DHDAHKKZHZHJMDEQCCPTQCRMDZC9DAARARZHZCHPDEPQZAJ0JZECKJQJJ0DCDDA3AEEPEHRJHMAIAPQHDEEHRCZQE2DHKKQTK0DTQ9C2E9C9R8ZCKPK3RRK2. /// </summary> internal static string _400 { get { return ResourceManager.GetString("400", resourceCulture); } } |
︙ | ︙ |
Changes to SQLite.Designer/VSPackage.resx.
︙ | ︙ | |||
123 124 125 126 127 128 129 | <data name="Encrypt" xml:space="preserve"> <value>The database and its metadata will be encrypted using the supplied password as a hash.</value> </data> <data name="ReEncrypt" xml:space="preserve"> <value>The database and its metadata will be re-encrypted using the supplied password as a hash.</value> </data> <data name="400" xml:space="preserve"> | | | 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 | <data name="Encrypt" xml:space="preserve"> <value>The database and its metadata will be encrypted using the supplied password as a hash.</value> </data> <data name="ReEncrypt" xml:space="preserve"> <value>The database and its metadata will be re-encrypted using the supplied password as a hash.</value> </data> <data name="400" xml:space="preserve"> <value>PTA9I2P3DHDAHKKZHZHJMDEQCCPTQCRMDZC9DAARARZHZCHPDEPQZAJ0JZECKJQJJ0DCDDA3AEEPEHRJHMAIAPQHDEEHRCZQE2DHKKQTK0DTQ9C2E9C9R8ZCKPK3RRK2</value> </data> <assembly alias="System.Windows.Forms" name="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <data name="info" type="System.Resources.ResXFileRef, System.Windows.Forms"> <value>Resources\info.png;System.Drawing.Bitmap, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</value> </data> <data name="ToolboxItems" type="System.Resources.ResXFileRef, System.Windows.Forms"> <value>Resources\ToolboxItems.txt;System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089;Windows-1252</value> |
︙ | ︙ |
Changes to SQLite.Designer/plk.txt.
1 2 | Package Load Key (PLK) | > > | > | > | > > > > > > > > | | > > > > | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | Package Load Key (PLK) PTA9I2P3DHDAHKKZHZHJMDEQCCPTQCRMDZC9DAARARZHZCHPDEPQZAJ0JZECKJQJ J0DCDDA3AEEPEHRJHMAIAPQHDEEHRCZQE2DHKKQTK0DTQ9C2E9C9R8ZCKPK3RRK2 Contact Email Address plk@system.data.sqlite.org Company Name https://system.data.sqlite.org/ Product Name System.Data.SQLite Key Type PLK Package Name System.Data.SQLite Designer Package Guid {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx} {dcbe6c8d-0e57-4099-a183-98ff74c64d9c} Package Version 1.0 Min Product Edition Standard Min Visual Studio Version Visual Studio 2005 |
Changes to SQLite.Designer/source.extension.vsixmanifest.
1 2 3 4 | <?xml version="1.0" encoding="utf-8"?> <Vsix Version="1.0.0" xmlns="http://schemas.microsoft.com/developer/vsx-schema/2010"> <Identifier Id="67b5f3a9-cde1-430f-a12b-af95bb064851"> <Name>System.Data.SQLite Designer</Name> | | | 1 2 3 4 5 6 7 8 9 10 11 12 | <?xml version="1.0" encoding="utf-8"?> <Vsix Version="1.0.0" xmlns="http://schemas.microsoft.com/developer/vsx-schema/2010"> <Identifier Id="67b5f3a9-cde1-430f-a12b-af95bb064851"> <Name>System.Data.SQLite Designer</Name> <Author>https://system.data.sqlite.org/</Author> <Version>1.0.95.0</Version> <Description>ADO.NET Data Designer for SQLite</Description> <Locale>1033</Locale> <InstalledByMsi>false</InstalledByMsi> <SupportedProducts> <VisualStudio Version="10.0"> <Edition>Pro</Edition> |
︙ | ︙ |
Changes to SQLite.Interop/src/contrib/extension-functions.c.
︙ | ︙ | |||
26 27 28 29 30 31 32 | -I /opt/local/include/ -L/opt/local/lib -lsqlite3 if your sqlite3 is installed from Mac ports, or -I /sw/include/ -L/sw/lib -lsqlite3 if installed with Fink.) 2) In your application, call sqlite3_enable_load_extension(db,1) to allow loading external libraries. Then load the library libsqlitefunctions using sqlite3_load_extension; the third argument should be 0. | | | | 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | -I /opt/local/include/ -L/opt/local/lib -lsqlite3 if your sqlite3 is installed from Mac ports, or -I /sw/include/ -L/sw/lib -lsqlite3 if installed with Fink.) 2) In your application, call sqlite3_enable_load_extension(db,1) to allow loading external libraries. Then load the library libsqlitefunctions using sqlite3_load_extension; the third argument should be 0. See https://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. 3) Use, for example: SELECT cos(radians(inclination)) FROM satsum WHERE satnum = 25544; Note: Loading extensions is by default prohibited as a security measure; see "Security Considerations" in https://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. If the sqlite3 program and library are built this way, you cannot use these functions from the program, you must write your own program using the sqlite3 API, and call sqlite3_enable_load_extension as described above. If the program is built so that loading extensions is permitted, the following will work: |
︙ | ︙ | |||
1346 1347 1348 1349 1350 1351 1352 | sqlite3_result_text(context, rz, -1, SQLITE_TRANSIENT); sqlite3_free(rz); } /* ** An instance of the following structure holds the context of a ** stdev() or variance() aggregate computation. | | | 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 | sqlite3_result_text(context, rz, -1, SQLITE_TRANSIENT); sqlite3_free(rz); } /* ** An instance of the following structure holds the context of a ** stdev() or variance() aggregate computation. ** implementaion of https://en.wikipedia.org/wiki/Algorithms_for_calculating_variance#Algorithm_II ** less prone to rounding errors */ typedef struct StdevCtx StdevCtx; struct StdevCtx { double rM; double rS; i64 cnt; /* number of elements */ |
︙ | ︙ |
Changes to SQLite.Interop/src/win/AssemblyInfo.cpp.
︙ | ︙ | |||
8 9 10 11 12 13 14 | using namespace System::Reflection; using namespace System::Resources; using namespace System::Runtime::InteropServices; #include "interop.h" [assembly:AssemblyTitleAttribute("SQLite.Interop")]; | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | using namespace System::Reflection; using namespace System::Resources; using namespace System::Runtime::InteropServices; #include "interop.h" [assembly:AssemblyTitleAttribute("SQLite.Interop")]; [assembly:AssemblyCompanyAttribute("https://system.data.sqlite.org/")]; [assembly:AssemblyDescriptionAttribute("System.Data.SQLite Interop Assembly")]; [assembly:AssemblyProductAttribute("System.Data.SQLite")]; [assembly:AssemblyCopyrightAttribute("Public Domain")]; [assembly:AssemblyVersionAttribute(INTEROP_VERSION)]; [assembly:AssemblyFileVersionAttribute(INTEROP_VERSION)]; #if DEBUG |
︙ | ︙ |
Changes to SQLite.Interop/src/win/SQLite.Interop.rc.
︙ | ︙ | |||
55 56 57 58 59 60 61 | VALUE "LegalCopyright", "Public Domain" VALUE "OriginalFilename", "SQLite.Interop.dll" VALUE "ProductName", "System.Data.SQLite" VALUE "ProductVersion", INTEROP_VERSION VALUE "SourceId", INTEROP_SOURCE_ID " " INTEROP_SOURCE_TIMESTAMP VALUE "SQLiteCompanyName", "D. Richard Hipp, et al." VALUE "SQLiteDescription", "SQLite Database Engine" | | | 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | VALUE "LegalCopyright", "Public Domain" VALUE "OriginalFilename", "SQLite.Interop.dll" VALUE "ProductName", "System.Data.SQLite" VALUE "ProductVersion", INTEROP_VERSION VALUE "SourceId", INTEROP_SOURCE_ID " " INTEROP_SOURCE_TIMESTAMP VALUE "SQLiteCompanyName", "D. Richard Hipp, et al." VALUE "SQLiteDescription", "SQLite Database Engine" VALUE "SQLiteCopyright", "https://www.sqlite.org/copyright.html" VALUE "SQLiteVersion", SQLITE_VERSION VALUE "SQLiteSourceId", SQLITE_SOURCE_ID END END BLOCK "VarFileInfo" BEGIN VALUE "Translation", 0x409, 0x4b0 |
︙ | ︙ |
Changes to Setup/set_common.bat.
︙ | ︙ | |||
8 9 10 11 12 13 14 | :: IF NOT DEFINED APPID ( SET APPID={{02E43EC2-6B1C-45B5-9E48-941C3E1B204A} ) IF NOT DEFINED URL ( | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | :: IF NOT DEFINED APPID ( SET APPID={{02E43EC2-6B1C-45B5-9E48-941C3E1B204A} ) IF NOT DEFINED URL ( SET URL=https://system.data.sqlite.org/ ) IF NOT DEFINED PUBLICKEY ( SET PUBLICKEY=db937bc2d44ff139 ) IF NOT DEFINED BUILD_CONFIGURATIONS ( |
︙ | ︙ |
Changes to System.Data.SQLite.Linq/AssemblyInfo.cs.
︙ | ︙ | |||
17 18 19 20 21 22 23 | #if USE_ENTITY_FRAMEWORK_6 [assembly: AssemblyTitle("System.Data.SQLite for Entity Framework 6")] #else [assembly: AssemblyTitle("System.Data.SQLite for LINQ")] #endif [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | #if USE_ENTITY_FRAMEWORK_6 [assembly: AssemblyTitle("System.Data.SQLite for Entity Framework 6")] #else [assembly: AssemblyTitle("System.Data.SQLite for LINQ")] #endif [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to System.Data.SQLite.Linq/Resources/SQLiteProviderServices.ProviderManifest.xml.
︙ | ︙ | |||
80 81 82 83 84 85 86 | </Type> <Type Name="uniqueidentifier" PrimitiveTypeKind="Guid"> </Type> </Types> <Functions> <!-- BEGIN AGGREGATES | | | 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 | </Type> <Type Name="uniqueidentifier" PrimitiveTypeKind="Guid"> </Type> </Types> <Functions> <!-- BEGIN AGGREGATES https://www.sqlite.org/lang_aggfunc.html --> <!-- AVG --> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double" /> <Parameter Name="arg" Type="Collection(Int32)" Mode="In" /> </Function> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double" /> |
︙ | ︙ | |||
281 282 283 284 285 286 287 | <Function Name="TOTAL" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double" /> <Parameter Name="arg" Type="Collection(Double)" Mode="In" /> </Function> <!-- END AGGREGATES ############################################# --> | | | 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 | <Function Name="TOTAL" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double" /> <Parameter Name="arg" Type="Collection(Double)" Mode="In" /> </Function> <!-- END AGGREGATES ############################################# --> <!-- Begin Scalars https://www.sqlite.org/lang_corefunc.html --> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Int32" /> <Parameter Name="arg" Type="Int32" Mode="In" /> </Function> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Int64" /> |
︙ | ︙ |
Changes to System.Data.SQLite/AssemblyInfo.cs.
︙ | ︙ | |||
17 18 19 20 21 22 23 | #endif // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Core")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | #endif // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Core")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to Tests/data/Installer_Test_Vs2005.log.
︙ | ︙ | |||
18 19 20 21 22 23 24 | Installer.exe: #18: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0", subKeyName = "Packages", writable = True Installer.exe: #19: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #20: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #21: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #22: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" | | | 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | Installer.exe: #18: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0", subKeyName = "Packages", writable = True Installer.exe: #19: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #20: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #21: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #22: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CompanyName", value = "https://system.data.sqlite.org/" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "MinEdition", value = "standard" Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductName", value = "System.Data.SQLite Designer Package" Installer.exe: #28: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductVersion", value = "1.0" Installer.exe: #29: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", subKeyName = "Toolbox" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Packages\Toolbox", name = "Default Items", value = 3 Installer.exe: #31: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0", subKeyName = "Menus", writable = True Installer.exe: #32: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\8.0\Menus", name = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", value = ", 1000, 3" |
︙ | ︙ |
Changes to Tests/data/Installer_Test_Vs2008.log.
︙ | ︙ | |||
28 29 30 31 32 33 34 | Installer.exe: #28: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0", subKeyName = "Packages", writable = True Installer.exe: #29: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #31: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #32: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #33: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #34: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" | | | 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | Installer.exe: #28: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0", subKeyName = "Packages", writable = True Installer.exe: #29: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #31: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #32: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #33: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #34: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" Installer.exe: #35: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CompanyName", value = "https://system.data.sqlite.org/" Installer.exe: #36: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "MinEdition", value = "standard" Installer.exe: #37: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductName", value = "System.Data.SQLite Designer Package" Installer.exe: #38: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductVersion", value = "1.0" Installer.exe: #39: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", subKeyName = "Toolbox" Installer.exe: #40: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Packages\Toolbox", name = "Default Items", value = 3 Installer.exe: #41: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0", subKeyName = "Menus", writable = True Installer.exe: #42: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\9.0\Menus", name = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", value = ", 1000, 3" |
︙ | ︙ |
Changes to Tests/data/Installer_Test_Vs2010.log.
︙ | ︙ | |||
21 22 23 24 25 26 27 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" | | | 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" Installer.exe: #28: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CompanyName", value = "https://system.data.sqlite.org/" Installer.exe: #29: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "MinEdition", value = "standard" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductName", value = "System.Data.SQLite Designer Package" Installer.exe: #31: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductVersion", value = "1.0" Installer.exe: #32: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", subKeyName = "Toolbox" Installer.exe: #33: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Packages\Toolbox", name = "Default Items", value = 3 Installer.exe: #34: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0", subKeyName = "Menus", writable = True Installer.exe: #35: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\10.0\Menus", name = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", value = ", 1000, 3" |
︙ | ︙ |
Changes to Tests/data/Installer_Test_Vs2012.log.
︙ | ︙ | |||
21 22 23 24 25 26 27 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" | | | 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" Installer.exe: #28: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CompanyName", value = "https://system.data.sqlite.org/" Installer.exe: #29: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "MinEdition", value = "standard" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductName", value = "System.Data.SQLite Designer Package" Installer.exe: #31: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductVersion", value = "1.0" Installer.exe: #32: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", subKeyName = "Toolbox" Installer.exe: #33: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Packages\Toolbox", name = "Default Items", value = 3 Installer.exe: #34: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0", subKeyName = "Menus", writable = True Installer.exe: #35: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\11.0\Menus", name = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", value = ", 1000, 3" |
︙ | ︙ |
Changes to Tests/data/Installer_Test_Vs2013.log.
︙ | ︙ | |||
21 22 23 24 25 26 27 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" | | | 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | Installer.exe: #21: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0", subKeyName = "Packages", writable = True Installer.exe: #22: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages", subKeyName = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}" Installer.exe: #23: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = <null>, value = "System.Data.SQLite Designer Package" Installer.exe: #24: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "Class", value = "SQLite.Designer.SQLitePackage" Installer.exe: #25: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CodeBase", value = "[file nativename [file join [getBuildDirectory] SQLite.Designer.dll]]" Installer.exe: #26: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ID", value = 400 Installer.exe: #27: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "InprocServer32", value = "[file nativename [file join $::env(windir) [expr {$is64 ? "SysWOW64" : "system32"}] mscoree.dll]]" Installer.exe: #28: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "CompanyName", value = "https://system.data.sqlite.org/" Installer.exe: #29: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "MinEdition", value = "standard" Installer.exe: #30: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductName", value = "System.Data.SQLite Designer Package" Installer.exe: #31: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", name = "ProductVersion", value = "1.0" Installer.exe: #32: RegistryHelper.CreateSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", subKeyName = "Toolbox" Installer.exe: #33: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Packages\Toolbox", name = "Default Items", value = 3 Installer.exe: #34: RegistryHelper.OpenSubKey: rootKey = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0", subKeyName = "Menus", writable = True Installer.exe: #35: RegistryHelper.SetValue: key = "HKEY_LOCAL_MACHINE\Software${wow64}\Microsoft\VisualStudio\12.0\Menus", name = "{dcbe6c8d-0e57-4099-a183-98ff74c64d9c}", value = ", 1000, 3" |
︙ | ︙ |
Changes to readme.htm.
1 2 3 4 5 6 7 8 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET SQLite Data Provider<br /> Version 1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font><br /> | | | | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET SQLite Data Provider<br /> Version 1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font><br /> Using <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a><br /> Originally written by Robert Simpson<br /> Released to the public domain, use at your own risk!<br /> Official provider website: <a href="https://system.data.sqlite.org/">https://system.data.sqlite.org/</a><br /> Legacy versions: <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br /> <br /> The current development version can be downloaded from <a href="https://system.data.sqlite.org/index.html/timeline?y=ci"> https://system.data.sqlite.org/index.html/timeline?y=ci</a> <br /> <br /> <h2><b>Features</b></h2> <ul> <li> |
︙ | ︙ | |||
180 181 182 183 184 185 186 | The recent versions of the .NET Compact Framework do not appear to properly support mixed-mode assemblies. All builds of System.Data.SQLite, except those explicitly marked as "static" in their package name, will also require the associated <a href="https://support.microsoft.com/kb/2019667">Microsoft Visual C++ Runtime Library</a> to be installed on the target machine. For further details on distributing and/or deploying System.Data.SQLite, please refer to the | | | | | | | | | | | | | | | | 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 | The recent versions of the .NET Compact Framework do not appear to properly support mixed-mode assemblies. All builds of System.Data.SQLite, except those explicitly marked as "static" in their package name, will also require the associated <a href="https://support.microsoft.com/kb/2019667">Microsoft Visual C++ Runtime Library</a> to be installed on the target machine. For further details on distributing and/or deploying System.Data.SQLite, please refer to the <a href="https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki">System.Data.SQLite Downloads</a> web page. </p> <h2><b>Development Notes Regarding the SQLite Native Library Source Code</b></h2> <p> The included SQLite native library is compiled directly from the official source code releases available from the <a href="https://www.sqlite.org/">sqlite.org</a> website. </p> <p> In addition, there are several relatively small extensions included within the System.Data.SQLite "interop assembly" and some of these extensions are specific to the System.Data.SQLite project itself; however, the included SQLite native library source code itself is compiled verbatim, using a set of fully supported <a href="https://www.sqlite.org/compile.html">compile-time options</a> designed for robustness and maximum backward compatibility with previously released versions of System.Data.SQLite. </p> <h2><b>Version History</b></h2> <p> <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li> <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li> <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li> <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li> <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li> <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li> <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li> <li>In the SQLiteDataReader.VerifyType method, remove duplicate "if" statement for the DbType.SByte value and move the remaining "if" to the Int64 affinity. Fix for [c5cc2fb334]. <b>** Potentially Incompatible Change **</b></li> <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe]. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1]. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932]. <b>** Potentially Incompatible Change **</b></li> <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3]. <b>** Potentially Incompatible Change **</b></li> <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li> <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li> <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.94.0 - September 9, 2014</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li> <li>Refactor and simplify NuGet packages in order to support per-solution SQLite interop assembly files. <b>** Potentially Incompatible Change **</b></li> <li>Add RefreshFlags method to the SQLiteDataReader class to forcibly refresh its connection flags.</li> <li>Improve automatic detection and handling of the Entity Framework 6 assembly by the design-time components installer. Pursuant to [e634e330a6]. <b>** Potentially Incompatible Change **</b></li> <li>Improve SQLiteDataReader performance slightly by caching the connection flags. <b>** Potentially Incompatible Change **</b></li> <li>Add ClearCachedSettings method to the SQLiteConnection class.</li> <li>Add NoConvertSettings connection flag to disable querying of runtime configuration settings from within the SQLiteConvert class. Pursuant to [58ed318f2f].</li> <li>Minimize usage of the "Use_SQLiteConvert_DefaultDbType" and "Use_SQLiteConvert_DefaultTypeName" settings. Fix for [58ed318f2f]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.93.0 - June 23, 2014</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_5.html">SQLite 3.8.5</a>.</li> <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1">Entity Framework 6.1</a>.</li> <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].</li> <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].</li> <li>Add DetectTextAffinity and DetectStringType connection flags to enable automatic detection of column types, when necessary. Pursuant to [3c00ec5b52].</li> <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li> <li>Add SharedFlags static property to the SQLiteConnection class.</li> <li>Make the ISQLiteSchemaExtensions interface public. <b>** Potentially Incompatible Change **</b></li> <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li> <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li> <li>Fix DateTime constant handling in the LINQ assembly. Fix for [da9f18d039]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.92.0 - March 19, 2014</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_4_1.html">SQLite 3.8.4.1</a>.</li> <li>Update the list of keywords returned by SQLiteConnection.GetSchema("ReservedWords"). <b>** Potentially Incompatible Change **</b></li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand or SQLiteDataReader object is closed or disposed.</li> <li>Add the SQLiteDataReader.StepCount property to return the number of rows seen so far.</li> <li>Add StickyHasRows connection flag to cause the SQLiteDataReader.HasRows property to return non-zero if there were ever any rows in the associated result sets.</li> <li>When the TraceWarning connection flag is set, issue warnings about possibly malformed UNC paths. Pursuant to [283344397b].</li> <li>Convert the primary NuGet package, "System.Data.SQLite", into a meta-package.</li> <li>Enhancements to the NuGet packages, including the new "modular" packages.</li> </ul> <p> <b>1.0.91.0 - February 12, 2014</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_3_1.html">SQLite 3.8.3.1</a>.</li> <li>Refresh all included SQLite core library documentation (e.g. SQL syntax).</li> <li>Add support for <a href="https://entityframework.codeplex.com/">Entity Framework 6</a>.</li> <li>Add support for per-connection mappings between type names and DbType values. Pursuant to [e87af1d06a].</li> <li>Modify the namespace used for all internal classes in the System.Data.SQLite.Linq assembly. <b>** Potentially Incompatible Change **</b></li> <li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li> <li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li> <li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li> <li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li> <li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li> <li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li> <li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li> <li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e].</li> </ul> <p> <b>1.0.90.0 - December 23, 2013</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_2.html">SQLite 3.8.2</a>.</li> <li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2013 support to the redesigned designer support installer.</li> <li>Add support for Windows Embedded Compact 2013.</li> <li>Add experimental support for the native regexp extension.</li> <li>Never create a new connection wrapper in the SQLiteConnection.Shutdown method. <b>** Potentially Incompatible Change **</b></li> <li>Add experimental GetMemoryStatistics, ReleaseMemory, and Shutdown methods to the SQLiteConnection class.</li> <li>Add memory leak detection to the test project for the .NET Compact Framework.</li> <li>Add SQLITE_ENABLE_MEMORY_MANAGEMENT compile-time option to the interop assembly.</li> <li>Use current isolation level when enlisting into an existing transaction. Fix for [56b42d99c1].</li> <li>Better handling of non-error log messages from the SQLite core library. Pursuant to [44df10ea90].</li> <li>Add TraceWarning connection flag to enable tracing of type mapping failures and disable tracing of them by default. Pursuant to [6d45c782e4].</li> <li>Use 32-bit values to keep track of numeric precision and scale when building the schema table for a query. Fix for [ef2216192d].</li> </ul> <p> <b>1.0.89.0 - October 28, 2013</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_1.html">SQLite 3.8.1</a>.</li> <li>Add AutoCommit property to the SQLiteConnection class. Fix for [9ba9346f75].</li> <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for [3113734605].</li> <li>Check the result of sqlite3_column_name function against NULL.</li> <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for [aba4549801].</li> <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li> <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event. <b>** Potentially Incompatible Change **</b></li> |
︙ | ︙ | |||
351 352 353 354 355 356 357 | <li>Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to [bbdda6eae2].</li> <li>Rename the ReturnCode property of the SQLiteException class to ResultCode. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.86.0 - May 23, 2013</b> </p> <ul> | | | | 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 | <li>Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to [bbdda6eae2].</li> <li>Rename the ReturnCode property of the SQLiteException class to ResultCode. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.86.0 - May 23, 2013</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_17.html">SQLite 3.7.17</a>.</li> <li>Disable use of the AllowPartiallyTrustedCallers attribute when compiled for the .NET Framework 4.0/4.5. <b>** Potentially Incompatible Change **</b></li> <li>Allow semi-colons in the data source file name. Fix for [e47b3d8346]. <b>** Potentially Incompatible Change **</b></li> <li>NULL values should be reported as type "object", not "DBNull". Fix for [48a6b8e4ca].</li> </ul> <p> <b>1.0.85.0 - April 18, 2013</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_16_2.html">SQLite 3.7.16.2</a>.</li> <li>Properly handle embedded NUL characters in parameter and column values. Fix for [3567020edf].</li> <li>Make use of the sqlite3_prepare_v2 function when applicable.</li> <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li> <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li> <li>Support automated testing when running on the .NET Compact Framework 2.0.</li> <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to [e4c8121f7b].</li> <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to [1c456ae75f].</li> |
︙ | ︙ | |||
385 386 387 388 389 390 391 | <li>Support using the directory containing the primary managed-only assembly as the basis for native library pre-loading.</li> <li>Still further enhancements to the build and test automation.</li> </ul> <p> <b>1.0.84.0 - January 9, 2013</b> </p> <ul> | | | | 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 | <li>Support using the directory containing the primary managed-only assembly as the basis for native library pre-loading.</li> <li>Still further enhancements to the build and test automation.</li> </ul> <p> <b>1.0.84.0 - January 9, 2013</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_15_2.html">SQLite 3.7.15.2</a>.</li> <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].</li> <li>Add Cancel method to the SQLiteConnection class to interrupt a long running query.</li> <li>Improve thread safety of the SQLiteLog.LogMessage method.</li> </ul> <p> <b>1.0.83.0 - December 29, 2012</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_15_1.html">SQLite 3.7.15.1</a>.</li> <li>Add Visual Studio 2012 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2012 support to the redesigned designer support installer.</li> <li>Allow opened connections to skip adding the extension functions included in the interop assembly via the new NoExtensionFunctions connection flag.</li> <li>Support loading of SQLite extensions via the new EnableExtensions and LoadExtension methods of the SQLiteConnection class. Pursuant to [17045010df].</li> <li>Remove one set of surrounding single or double quotes from property names and values parsed from the connection string. Fix for [b4cc611998].</li> <li>Modify parsing of connection strings to allow property names and values to be quoted. <b>** Potentially Incompatible Change **</b></li> <li>Add ParseViaFramework property to the SQLiteConnection class to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Pursuant to [b4cc611998].</li> |
︙ | ︙ | |||
430 431 432 433 434 435 436 | <li>Further enhancements to the build and test automation.</li> <li>Add test automation for the Windows CE binaries.</li> </ul> <p> <b>1.0.82.0 - September 3, 2012</b> </p> <ul> | | | | | | | | 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 | <li>Further enhancements to the build and test automation.</li> <li>Add test automation for the Windows CE binaries.</li> </ul> <p> <b>1.0.82.0 - September 3, 2012</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_14.html">SQLite 3.7.14</a>.</li> <li>Properly handle quoted data source values in the connection string. Fix for [8c3bee31c8].</li> <li>The <a href="https://www.nuget.org/packages/System.Data.SQLite">primary NuGet package</a> now supports x86 / x64 and the .NET Framework 2.0 / 4.0 (i.e. in a single package).</li> <li>Change the default value for the Synchronous connection string property to Full to match the default used by the SQLite core library itself. <b>** Potentially Incompatible Change **</b></li> <li>Add the ability to skip applying default connection settings to opened databases via the new SetDefaults connection string property.</li> <li>Add the ability to skip expanding data source file names to their fully qualified paths via the new ToFullPath connection string property.</li> <li>Fix the database cleanup ordering in the tests for ticket [343d392b51].</li> <li>Add support for the sqlite3_close_v2 function from the SQLite core library.</li> <li>Add support for <a href="https://www.sqlite.org/uri.html">URI file names</a> via the new FullUri connection string property.</li> <li>Improve support for the standard SQLite core library in the LINQ assembly and the test suite.</li> <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li> <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li> <li>Add define constants to support enabling or disabling individual groups of trace statements.</li> </ul> <p> <b>1.0.81.0 - May 27, 2012</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_12_1.html">SQLite 3.7.12.1</a>.</li> <li>Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.</li> <li>Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.</li> <li>Add release archive verification tool to the release automation.</li> <li>Fix NullReferenceException when calling the SQLiteDataAdapter.FillSchema method on a query that returns multiple result sets. Fix for [3aa50d8413].</li> <li>Fix subtle race condition between threads fetching connection handles from the connection pool and any garbage collection (GC) threads that may be running. Fix for [996d13cd87].</li> <li>Add missing call to SetTimeout in the SQLite3_UTF16.Open method.</li> <li>Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.</li> <li>Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.</li> <li>Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.</li> <li>Revise CriticalHandle derived classes to make them more thread-safe.</li> <li>Add connection pool related diagnostic messages when compiled with the DEBUG define constant.</li> <li>Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.</li> <li>Rename internal SQLiteLastError methods to GetLastError.</li> <li>Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.</li> </ul> <p> <b>1.0.80.0 - April 1, 2012</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_11.html">SQLite 3.7.11</a>.</li> <li>In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].</li> <li>Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2005 support to the redesigned designer support installer.</li> <li>Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.</li> <li>Add support for the native <a href="https://www.sqlite.org/backup.html">SQLite Online Backup API</a>. Fix for [c71846ed57].</li> <li>Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].</li> <li>Support tracing of all parameter binding activity and use the connection flags to control what is traced.</li> <li>When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.</li> <li>Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.</li> <li>Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.</li> <li>In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.</li> <li>Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].</li> |
︙ | ︙ | |||
502 503 504 505 506 507 508 | <li>Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for [d8491abd0b].</li> <li>Correct resource name used by the LINQ assembly to locate several key string resources. Fix for [fbebb30da9].</li> </ul> <p> <b>1.0.78.0 - January 27, 2012</b> </p> <ul> | | | | 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 | <li>Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for [d8491abd0b].</li> <li>Correct resource name used by the LINQ assembly to locate several key string resources. Fix for [fbebb30da9].</li> </ul> <p> <b>1.0.78.0 - January 27, 2012</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_10.html">SQLite 3.7.10</a>.</li> <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> <li>When emitting SQL for foreign keys in the VS designer, be sure to take all returned schema rows into account. Remainder of fix for [b226147b37].</li> <li>Add Flags connection string property to control extra behavioral flags for the connection.</li> <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> <li>Even more enhancements to the build and test automation.</li> <li>Support parameter binding to more primitive types, including unsigned integer types.</li> <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li> <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li> <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li> <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.77.0 - November 28, 2011</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_9.html">SQLite 3.7.9</a>.</li> <li>More enhancements to the build and test automation.</li> <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> <li>The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer.</li> <li>When compiled with DEBUG defined, emit diagnostic information related to resource cleanup to any TraceListener objects that may be registered.</li> <li>Stop characterizing all log messages as errors. From now on, if the errorCode is zero, the message will not be considered an error.</li> <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for [2ce0870fad].</li> <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> |
︙ | ︙ | |||
548 549 550 551 552 553 554 | <li>Prevent the domain unload event handler in SQLiteLog from being registered multiple times. Fix for [0d5b1ef362].</li> <li>Stop allowing non-default application domains to initialize the SQLiteLog class. Fix for [ac47dd230a].</li> </ul> <p> <b>1.0.75.0 - October 3, 2011</b> </p> <ul> | | | | 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 | <li>Prevent the domain unload event handler in SQLiteLog from being registered multiple times. Fix for [0d5b1ef362].</li> <li>Stop allowing non-default application domains to initialize the SQLiteLog class. Fix for [ac47dd230a].</li> </ul> <p> <b>1.0.75.0 - October 3, 2011</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_8.html">SQLite 3.7.8</a>.</li> <li>More enhancements to the build system.</li> <li>Add official <a href="https://www.nuget.org/">NuGet</a> packages for x86 and x64.</li> <li>Add Changes and LastInsertRowId properties to the connection class.</li> <li>Support more formats when converting data from/to the DateTime type.</li> <li>Make all the assembly versioning attributes consistent.</li> <li>Add unit testing infrastructure using <a href="http://eagle.to/">Eagle</a>.</li> <li>Integrate all legacy unit tests, including the "testlinq" project, into the new test suite.</li> <li>Add projects to build the interop assembly statically linked to the Visual C++ runtime. Fix for [53f0c5cbf6].</li> <li>Add SQLITE_ENABLE_STAT2 compile-time option to the interop assembly. Fix for [74807fbf27].</li> |
︙ | ︙ | |||
577 578 579 580 581 582 583 | <li>Fix incorrect resource name for SR.resx in the mixed-mode assembly.</li> <li>Reduce the number of String.Compare() calls in the hot path for SQLiteCommand.ExecuteReader().</li> </ul> <p> <b>1.0.74.0 - July 4, 2011</b> </p> <ul> | | | | | | | | 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 | <li>Fix incorrect resource name for SR.resx in the mixed-mode assembly.</li> <li>Reduce the number of String.Compare() calls in the hot path for SQLiteCommand.ExecuteReader().</li> </ul> <p> <b>1.0.74.0 - July 4, 2011</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_7_1.html">SQLite 3.7.7.1</a>.</li> <li>Fix incorrect hard-coded .NET Framework version information SQLiteFactory_Linq.cs that was causing IServiceProvider.GetService to fail when running against the .NET Framework 3.5.</li> <li>Fix all XML documentation warnings.</li> <li>Restore support for the mixed-mode assembly (i.e. the one that can be registered in the Global Assembly Cache).</li> <li>Restore support for the Compact Framework.</li> <li>Remove unused "using" statements from the System.Data.SQLite and System.Data.SQLite.Linq projects.</li> <li>Remove hard-coded System.Data.SQLite.Linq version from SQLiteFactory_Linq.cs</li> <li>Modify the setup to support bundled packages (i.e. with the mixed-mode assembly) and standard packages (i.e. with the managed assembly separate from the native interop library).</li> <li>Disable the ability to register with the Global Assembly Cache in the standard setup package (i.e. it is available in the bundled setup only).</li> <li>Remove PATH modification from the setup.</li> <li>Modify the naming scheme for the source, setup, and binary packages to allow for the necessary variants.</li> <li>In the build automation, attempt to automatically detect if Visual Studio 2008 and/or 2010 are installed and support building binaries for both at once, when available.</li> <li>Add release automation to build the source, setup, and binary packages in all supported build variants.</li> <li>Add the testlinq project to the new build system and make it work properly with Visual Studio 2008 and 2010.</li> </ul> <p> <b>1.0.73.0 - June 2, 2011</b> </p> <ul> <li>Updated to <a href="https://www.sqlite.org/releaselog/3_7_6_3.html">SQLite 3.7.6.3</a>.</li> <li>Minor optimization to GetBytes(). Fix for [8c1650482e].</li> <li>Update various assembly information settings.</li> <li>Correct System.Data.SQLite.Linq version and resource information. Fix for [6489c5a396] and [133daf50d6].</li> <li>Moved log handler from SQLiteConnection object to SQLiteFactory object to prevent if from being prematurely GCed.</li> <li>We should block x64 installs on x86 and we should install native only if the setup package itself is native. Fix for [e058ce156e].</li> </ul> <p> <b>1.0.72.0 - May 1, 2011</b> </p> <ul> <li>Add the correct directory to the path. Fix for [50515a0c8e].</li> </ul> <p> <b>1.0.71.0 - April 27, 2011</b> </p> <ul> <li>Updated to SQLite 3.7.6+ <a href="https://www.sqlite.org/src/info/1bd1484cd7">[1bd1484cd7]</a> to get additional Windows error logging.</li> <li>Updated setup to optionally add install directory to PATH if GAC option selected.</li> </ul> <p> <b>1.0.70.0 - April 22, 2011</b> </p> <ul> <li>Added support for sqlite3_extended_result_codes(), sqlite3_errcode(), and sqlite3_extended_errcode() via SetExtendedResultCodes(), ResultCode(), and ExtendedResultCode().</li> <li>Added support for SQLITE_CONFIG_LOG via SQLiteLogEventHandler().</li> </ul> <p> <b>1.0.69.0 - April 12, 2011</b> </p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_6.html">SQLite 3.7.6</a>.</li> <li>New VS2008 and VS2010 solution files.</li> <li>Build and packaging automation.</li> <li>New Inno Setup files.</li> <li>Designer support currently not ready for release.</li> </ul> <p> <b>1.0.68.0 - February 2011</b> </p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_5.html">SQLite 3.7.5</a>.</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> <p> <b>1.0.67.0 - January 3, 2011</b></p> <ul> <li>Code merge with <a href="https://www.sqlite.org/releaselog/3_7_4.html">SQLite 3.7.4</a>.</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> <p> <b>1.0.66.1 - August 1, 2010</b></p> <ul> <li>Code merge with SQLite 3.7.0.1</li> <li>Re-enabled VS2005 designer support, broken in previous versions during the 2008 |
︙ | ︙ | |||
673 674 675 676 677 678 679 | </ul> <p> <b>1.0.65.0 - July 26, 2009</b></p> <ul> <li>Fixed a bug in the encryption module to prevent a double free() when rekeying a database.</li> <li>Fixed a bug in the encryption module when ATTACHing an encrypted database.</li> | | | 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 | </ul> <p> <b>1.0.65.0 - July 26, 2009</b></p> <ul> <li>Fixed a bug in the encryption module to prevent a double free() when rekeying a database.</li> <li>Fixed a bug in the encryption module when ATTACHing an encrypted database.</li> <li>Incorporated the WinCE locking fix from ticket <a href="https://www.sqlite.org/cvstrac/tktview?tn=3991"> #3991</a></li> <li>Added "bigint" to the dropdown in the table designer, plus other minor table designer bugfixes.</li> </ul> <p> <b>1.0.64.0 - July 9, 2009</b></p> <ul> |
︙ | ︙ | |||
737 738 739 740 741 742 743 | <p> <b>1.0.60.0 - October 3, 2008</b></p> <ul> <li>Throw a NotSupported exception in the EF Sql Gen code instead of parsing illegal SQL during an update/insert/delete where no primary key is defined.</li> <li>Fixed the Compact Framework interop library. Since the linker flag /subsystem had no version specified, it was causing a problem for many CE-based platforms.</li> | | | 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 | <p> <b>1.0.60.0 - October 3, 2008</b></p> <ul> <li>Throw a NotSupported exception in the EF Sql Gen code instead of parsing illegal SQL during an update/insert/delete where no primary key is defined.</li> <li>Fixed the Compact Framework interop library. Since the linker flag /subsystem had no version specified, it was causing a problem for many CE-based platforms.</li> <li>Incorporated SQLite patch for ticket <a href="https://www.sqlite.org/cvstrac/tktview?tn=3387"> #3387</a> and reverted out the vfs override code I added in build 59 to work around this problem.</li> <li>Fixed a designer issue when creating a new table from the Server Explorer. After initially saving it, if you then continued to edit it and tried to save it again, it would generate the change SQL using the old temporary table name rather than the new name.</li> </ul> |
︙ | ︙ | |||
779 780 781 782 783 784 785 | to deeply-nested subqueries that the EF SqlGen creates.</li> <li>The Rollback SQLiteConnection event no longer requires an open connection in order to subscribe to it. Missed this one in the 57 release.</li> </ul> <p> <b>1.0.57.0 - August 29, 2008</b></p> <ul> | | | 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 | to deeply-nested subqueries that the EF SqlGen creates.</li> <li>The Rollback SQLiteConnection event no longer requires an open connection in order to subscribe to it. Missed this one in the 57 release.</li> </ul> <p> <b>1.0.57.0 - August 29, 2008</b></p> <ul> <li>Compiled against 3.6.1 with checkin <a href="https://www.sqlite.org/cvstrac/tktview?tn=3300"> #3300</a> resolved, which fixes an Entity Framework bug I was seeing. I currently have 3 other tickets out on the engine, which are not yet resolved and relate to EF.</li> <li>Fixed decimal types to store and fetch using InvariantCulture. If you're using decimal datatypes in your database and were affected by the 56 release, please issue an UPDATE <table> SET <column> = REPLACE(<column>, ',', '.'); to fix the decimal separators. Apologies for not testing |
︙ | ︙ | |||
825 826 827 828 829 830 831 | <li>LINQ to Entities bits heavily updated and compiled against VS2008 SP1 RTM. SQLite LINQ support is still considered beta.</li> </ul> <p> <b>1.0.55.0 - August 6, 2008</b></p> <ul> <li>Code merge with SQLite 3.6.1</li> | | | | 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 | <li>LINQ to Entities bits heavily updated and compiled against VS2008 SP1 RTM. SQLite LINQ support is still considered beta.</li> </ul> <p> <b>1.0.55.0 - August 6, 2008</b></p> <ul> <li>Code merge with SQLite 3.6.1</li> <li>Added support for the user-contributed extension-functions at <a href="https://www.sqlite.org/contrib"> https://www.sqlite.org/contrib</a>. Feel free to override any of them with your own implementation. The new functions are: <i>acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi, replicate, charindex, leftstr, rightstr, reverse, proper, padl, padr, padc, strfilter,</i> and aggregates <i>stdev, variance, mode, median, lower_quartile, upper_quartile.</i></li> <li>Moved the last_rows_affected() function to the C extension library.</li> <li>Added a new class, SQLiteFunctionEx which extends SQLiteFunction and adds the |
︙ | ︙ |
Changes to test/AssemblyInfo.cs.
︙ | ︙ | |||
9 10 11 12 13 14 15 | using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Tester")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Tester")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to testce/AssemblyInfo.cs.
︙ | ︙ | |||
9 10 11 12 13 14 15 | using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Tester for Windows CE")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Tester for Windows CE")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to testlinq/Properties/AssemblyInfo.cs.
︙ | ︙ | |||
14 15 16 17 18 19 20 | #if USE_ENTITY_FRAMEWORK_6 [assembly: AssemblyTitle("System.Data.SQLite Tester for Entity Framework 6")] #else [assembly: AssemblyTitle("System.Data.SQLite Tester for LINQ")] #endif [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | #if USE_ENTITY_FRAMEWORK_6 [assembly: AssemblyTitle("System.Data.SQLite Tester for Entity Framework 6")] #else [assembly: AssemblyTitle("System.Data.SQLite Tester for LINQ")] #endif [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to tools/install/Installer.cs.
︙ | ︙ | |||
6664 6665 6666 6667 6668 6669 6670 | // string, must be placed in the resource string named // "400" in the "SQLite.Designer\VSPackage.resx" file // and then the designer assembly itself must be // recompiled. As of this writing (in February 2012), // the following URL is the proper place to generate // package load keys: // | | | 6664 6665 6666 6667 6668 6669 6670 6671 6672 6673 6674 6675 6676 6677 6678 | // string, must be placed in the resource string named // "400" in the "SQLite.Designer\VSPackage.resx" file // and then the designer assembly itself must be // recompiled. As of this writing (in February 2012), // the following URL is the proper place to generate // package load keys: // // https://msdn.microsoft.com/en-us/vstudio/cc655795 // using (MockRegistryKey packageKey = RegistryHelper.CreateSubKey(subKey, package.PackageId.ToString(VsIdFormat), whatIf, verbose)) { if (packageKey == null) |
︙ | ︙ | |||
6703 6704 6705 6706 6707 6708 6709 | directory = String.Empty; RegistryHelper.SetValue(packageKey, "InprocServer32", Path.Combine(directory, "mscoree.dll"), whatIf, verbose); RegistryHelper.SetValue(packageKey, "CompanyName", | | | 6703 6704 6705 6706 6707 6708 6709 6710 6711 6712 6713 6714 6715 6716 6717 | directory = String.Empty; RegistryHelper.SetValue(packageKey, "InprocServer32", Path.Combine(directory, "mscoree.dll"), whatIf, verbose); RegistryHelper.SetValue(packageKey, "CompanyName", "https://system.data.sqlite.org/", whatIf, verbose); RegistryHelper.SetValue(packageKey, "MinEdition", "standard", whatIf, verbose); RegistryHelper.SetValue(packageKey, "ProductName", String.Format("{0} Designer Package", ProjectName), whatIf, verbose); |
︙ | ︙ |
Changes to tools/install/Properties/AssemblyInfo.cs.
1 2 3 4 5 6 7 8 | using System.Reflection; using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Designer Installer")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | using System.Reflection; using System.Runtime.InteropServices; // General Information about an assembly is controlled through the following // set of attributes. Change these attribute values to modify the information // associated with an assembly. [assembly: AssemblyTitle("System.Data.SQLite Designer Installer")] [assembly: AssemblyDescription("ADO.NET Data Provider for SQLite")] [assembly: AssemblyCompany("https://system.data.sqlite.org/")] [assembly: AssemblyProduct("System.Data.SQLite")] [assembly: AssemblyCopyright("Public Domain")] #if DEBUG [assembly: AssemblyConfiguration("Debug")] #else [assembly: AssemblyConfiguration("Release")] |
︙ | ︙ |
Changes to www/build.wiki.
︙ | ︙ | |||
65 66 67 68 69 70 71 | "System.Data.SQLite.dll" assembly that includes all the necessary native and managed code). This will make it easier for developers that wish to register the assembly in the Global Assembly Cache (GAC). </li> <li> The machine used to prepare the official releases will have the | | | | 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | "System.Data.SQLite.dll" assembly that includes all the necessary native and managed code). This will make it easier for developers that wish to register the assembly in the Global Assembly Cache (GAC). </li> <li> The machine used to prepare the official releases will have the <a href="https://www.microsoft.com/downloads/en/details.aspx?FamilyID=ab99342f-5d1a-413d-8319-81da479ab0d7">.NET Framework 3.5 SP1</a> and the corresponding <a href="https://www.microsoft.com/downloads/details.aspx?FamilyId=E6E1C3DF-A74F-4207-8586-711EBE331CDC">SDK</a> installed. </li> <li> The machine used to prepare the official releases will have <a href="http://www.jrsoftware.org/isdl.php">Inno Setup 5.5.5</a> or higher installed in "%ProgramFiles%\Inno Setup 5" or |
︙ | ︙ | |||
114 115 116 117 118 119 120 | <ul> <li><root>\SQLite.Interop\props\sqlite3.vsprops</li> <li><root>\SQLite.Interop\props\sqlite3.props</li> </ul> You'll need to update the SQLITE_MANIFEST_VERSION and SQLITE_RC_VERSION properties. This version number should track the release versions of | | | 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 | <ul> <li><root>\SQLite.Interop\props\sqlite3.vsprops</li> <li><root>\SQLite.Interop\props\sqlite3.props</li> </ul> You'll need to update the SQLITE_MANIFEST_VERSION and SQLITE_RC_VERSION properties. This version number should track the release versions of SQLite (i.e. <a href="https://www.sqlite.org/changes.html">3.7.x</a>). </li> <li> Make sure the version information is correct for System.Data.SQLite in the following files (<i>this step should not be necessary when using source code checked out from the official repository</i>): |
︙ | ︙ |
Changes to www/contribute.wiki.
︙ | ︙ | |||
38 39 40 41 42 43 44 | implementation of the same feature being prepared separately. <h2>3.0 Check-in Privileges</h2> Check-in privileges are granted on a case-by-case basis. Your chances of getting check-in privileges are much improved if you have a history of submitting quality patches and/or making thoughtful posts on the | | | 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | implementation of the same feature being prepared separately. <h2>3.0 Check-in Privileges</h2> Check-in privileges are granted on a case-by-case basis. Your chances of getting check-in privileges are much improved if you have a history of submitting quality patches and/or making thoughtful posts on the [https://www.mail-archive.com/sqlite-users@sqlite.org/ | mailing list]. A contributor agreement is, of course, a prerequisite for check-in privileges.</p> Contributors are asked to make all non-trivial changes on a branch. A System.Data.SQLite admin will review the branch and merge the changes into the trunk.</p> |
︙ | ︙ |
Changes to www/copyright.wiki.
︙ | ︙ | |||
10 11 12 13 14 15 16 | and "System.Data.SQLite.EF6" assemblies. </p> <table align="right" vspace="0" hspace="10" border="1" cellpadding="20"> <tr><td align="center"> <img src="art/nocopy.gif"><br> System.Data.SQLite is in the<br> | | | | 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | and "System.Data.SQLite.EF6" assemblies. </p> <table align="right" vspace="0" hspace="10" border="1" cellpadding="20"> <tr><td align="center"> <img src="art/nocopy.gif"><br> System.Data.SQLite is in the<br> <a href="https://en.wikipedia.org/wiki/Public_Domain">Public Domain</a> </td></tr> </table> <p> All other code and documentation in System.Data.SQLite has been dedicated to the <a href="https://en.wikipedia.org/wiki/Public_Domain">public domain</a> by the authors. All code authors, and representatives of the companies they work for, have signed affidavits dedicating their contributions to the public domain and originals of those signed affidavits are stored in a firesafe at the main offices of <a href="http://www.hwaci.com">Hwaci</a>. Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original System.Data.SQLite code, either in source code form or as a |
︙ | ︙ | |||
94 95 96 97 98 99 100 | 6200 Maple Cove Lane<br> Charlotte, NC 28269<br> USA </blockquote> <p> A template copyright release is available | | | | 94 95 96 97 98 99 100 101 102 103 104 | 6200 Maple Cove Lane<br> Charlotte, NC 28269<br> USA </blockquote> <p> A template copyright release is available in <a href="https://www.sqlite.org/copyright-release.pdf">PDF</a> or <a href="https://www.sqlite.org/copyright-release.html">HTML</a>. You can use this release to make future changes. </p> |
Changes to www/downloads.wiki.
︙ | ︙ | |||
73 74 75 76 77 78 79 | <td colspan="3" class="importantNotes"> There are several other projects, with widely varying levels of support and compatibility, known to use the similar names. At least one of those projects is an unofficial fork of the legacy 1.0.66.0 release, modified (by a third-party) to work with Visual Studio 2010 (or higher). Only the software contained on this page is directly <a href="support.wiki">supported</a> by the maintainers of this project | | | | 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 | <td colspan="3" class="importantNotes"> There are several other projects, with widely varying levels of support and compatibility, known to use the similar names. At least one of those projects is an unofficial fork of the legacy 1.0.66.0 release, modified (by a third-party) to work with Visual Studio 2010 (or higher). Only the software contained on this page is directly <a href="support.wiki">supported</a> by the maintainers of this project (i.e. the <a href="https://www.sqlite.org">SQLite Development Team</a>) as we do not necessarily have any knowledge of the other projects that use the same (or a similar) name. That being said, if a particular question is related to the core SQLite native library itself, one of the <a href="https://www.sqlite.org/support.html">SQLite support options</a> is probably the best way to get an answer. </td> </tr> <tr bgcolor="#fff1c8"> <td colspan="3" class="importantHeader"> <a name="windowsEmbeddedCompact"></a> |
︙ | ︙ | |||
176 177 178 179 180 181 182 | deployment is not recommended. </li> <br /> <li> The binary packages are intended to be used by developers in order to obtain the assembly binaries necessary for development and deployment of their applications onto customer machines via | | | | | | 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 | deployment is not recommended. </li> <br /> <li> The binary packages are intended to be used by developers in order to obtain the assembly binaries necessary for development and deployment of their applications onto customer machines via <a href="https://en.wikipedia.org/wiki/XCOPY_deployment">XCOPY deployment</a>. </li> </ul> </td> <td> </td> </tr> <tr> <td colspan="3" class="importantNotes"> All the "bundle" packages contain the "System.Data.SQLite.dll" mixed-mode assembly. These packages should <b>only</b> be used in cases where the assembly binary <b>must</b> be deployed to the <a href="https://en.wikipedia.org/wiki/Global_Assembly_Cache">Global Assembly Cache</a> for some reason (e.g. to support some legacy application on customer machines). <br /><br /> All the "static" packages contain either native or mixed-mode assembly binaries linked statically to the appropriate version of the <a href="https://en.wikipedia.org/wiki/Visual_C++">Visual C++</a> runtime. Typically, these packages are used in cases where customer machines may not have the necessary version of the Visual C++ runtime installed and it cannot be installed due to limited privileges. <br /><br /> The next step is to identify the version of the <a href="https://en.wikipedia.org/wiki/.NET_Framework">.NET Framework</a> being targeted by the application. Generally, assembly binaries linked against the <a href="http://go.microsoft.com/fwlink/?LinkID=32168">.NET Framework 2.0</a> (or the <a href="http://go.microsoft.com/fwlink/?LinkId=124150">.NET Framework 3.5</a>) will work with the <a href="http://go.microsoft.com/fwlink/?LinkID=186913">.NET Framework |
︙ | ︙ | |||
229 230 231 232 233 234 235 | </td> </tr> <tr> <td colspan="3" class="importantNotes"> The final step is to identify the target processor architecture on both the development and customer machines. Generally, | | | | | | 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 | </td> </tr> <tr> <td colspan="3" class="importantNotes"> The final step is to identify the target processor architecture on both the development and customer machines. Generally, <a href="https://en.wikipedia.org/wiki/X86">x86</a> binaries will work on an <a href="https://en.wikipedia.org/wiki/X64">x64</a> machine running <a href="https://en.wikipedia.org/wiki/Windows">Windows</a> (using <a href="https://en.wikipedia.org/wiki/WoW64">WoW64</a>). However, there is a problem when using managed code. If the executable that starts the process consists entirely of managed code, it will run with the native processor architecture of the machine, which will be x64 on an x64 machine. Later on, this will cause assemblies containing any native code compiled for x86 (e.g. the "System.Data.SQLite.dll" mixed-mode assembly, the "SQLite.Interop.dll" native interop assembly, or the "sqlite3.dll" native library) to fail to |
︙ | ︙ | |||
340 341 342 343 344 345 346 | For each configuration setting, the associated environment variable value, if present, will override the value specified via the XML configuration file. <br /><br /> For the full .NET Framework, the XML configuration file <b>must</b> be named "<b>System.Data.SQLite.dll.config</b>" and it <b>must</b> be present in the | | | | 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 | For each configuration setting, the associated environment variable value, if present, will override the value specified via the XML configuration file. <br /><br /> For the full .NET Framework, the XML configuration file <b>must</b> be named "<b>System.Data.SQLite.dll.config</b>" and it <b>must</b> be present in the <a href="https://msdn.microsoft.com/en-us/library/system.appdomain.basedirectory%28v=vs.80%29.aspx">base directory for the application domain</a> <b>or</b> the directory containing the primary System.Data.SQLite assembly as reported by its <a href="https://msdn.microsoft.com/en-us/library/system.reflection.assembly.location%28v=vs.80%29.aspx">location</a> property; otherwise, it will be ignored. <br /><br /> For the .NET Compact Framework, the XML configuration file <b>must</b> be named "<b>System.Data.SQLite.dll.config</b>" and it <b>must</b> be present in the directory containing the primary System.Data.SQLite assembly; otherwise, it will be ignored. </td> |
︙ | ︙ | |||
1867 1868 1869 1870 1871 1872 1873 | <b>Official NuGet Packages</b> </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 | <b>Official NuGet Packages</b> </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite/1.0.94.1">System.Data.SQLite.1.0.94.1.nupkg</a> <br /> (0.00 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package includes all the binaries for both the x86 and x64 versions of System.Data.SQLite 1.0.94.0 (3.8.6). The .NET Framework |
︙ | ︙ | |||
1898 1899 1900 1901 1902 1903 1904 | (sha1: 45eaa9eab15571878adc89750a491e1990d63e12) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 | (sha1: 45eaa9eab15571878adc89750a491e1990d63e12) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.Core/1.0.94.0">System.Data.SQLite.Core.1.0.94.0.nupkg</a> <br /> (4.92 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains all the binaries for both the x86 and x64 versions of System.Data.SQLite 1.0.94.0 (3.8.6), <big><b>except those |
︙ | ︙ | |||
1921 1922 1923 1924 1925 1926 1927 | (sha1: 1ccad1b567f2d5d86d6f487e3613e605d24b6b07) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 | (sha1: 1ccad1b567f2d5d86d6f487e3613e605d24b6b07) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.Core.MSIL/1.0.94.0">System.Data.SQLite.Core.MSIL.1.0.94.0.nupkg</a> <br /> (0.68 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains the managed binaries for System.Data.SQLite 1.0.94.0. The .NET Framework 3.5 SP1, 4.0, 4.5, or 4.5.1 is required. |
︙ | ︙ | |||
1947 1948 1949 1950 1951 1952 1953 | (sha1: 5ab704db605288ded3ac37787303d7074e4988bf) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | | | 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 | (sha1: 5ab704db605288ded3ac37787303d7074e4988bf) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.EF6/1.0.94.0">System.Data.SQLite.EF6.1.0.94.0.nupkg</a> <br /> (0.13 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains just the binaries to support Entity Framework 6 using System.Data.SQLite 1.0.94.0 (3.8.6). The .NET Framework 4.0, 4.5, or 4.5.1 is required. <br /> <big><b>This package depends on both the "System.Data.SQLite.Core" and "EntityFramework" packages.</b></big> <br /> (sha1: fc4b0046b083a9fc7a294df3af3b9d3918ee88d8) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.Linq/1.0.94.1">System.Data.SQLite.Linq.1.0.94.1.nupkg</a> <br /> (0.17 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains just the binaries to support LINQ using System.Data.SQLite 1.0.94.0 (3.8.6). The .NET Framework 3.5 SP1, 4.0, 4.5, or 4.5.1 is required. <br /> <big><b>This package depends on the "System.Data.SQLite.Core" package.</b></big> <br /> (sha1: a08052b4d350e3ba830ebf0618bc8c221a2ef70e) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.MSIL/1.0.94.1">System.Data.SQLite.MSIL.1.0.94.1.nupkg</a> <br /> (0.99 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains the managed binaries for System.Data.SQLite 1.0.94.0. The .NET Framework 3.5 SP1, 4.0, 4.5, or 4.5.1 is required. |
︙ | ︙ | |||
2017 2018 2019 2020 2021 2022 2023 | (sha1: 7689db66a5b1f2c9c751dbece99ec2faa840f48d) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 | (sha1: 7689db66a5b1f2c9c751dbece99ec2faa840f48d) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.x86/1.0.94.1">System.Data.SQLite.x86.1.0.94.1.nupkg</a> <br /> (2.84 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains all the binaries for the x86 version of System.Data.SQLite 1.0.94.0 (3.8.6). The .NET Framework 3.5 SP1, |
︙ | ︙ | |||
2041 2042 2043 2044 2045 2046 2047 | (sha1: 501c8252fc23134ab99bc6c170a66732578e4a73) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> | | | 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 | (sha1: 501c8252fc23134ab99bc6c170a66732578e4a73) </td> </tr> <tr> <td width="10"> </td> <td width="30%" valign="top" align="right"> <a href="https://www.nuget.org/api/v2/package/System.Data.SQLite.x64/1.0.94.1">System.Data.SQLite.x64.1.0.94.1.nupkg</a> <br /> (3.11 MiB) </td> <td width="5"></td> <td valign="top"> This NuGet package contains all the binaries for the x64 version of System.Data.SQLite 1.0.94.0 (3.8.6). The .NET Framework 3.5 SP1, |
︙ | ︙ | |||
2163 2164 2165 2166 2167 2168 2169 | <p> The <b>releaseType</b> in template (12) will be Beta or Test. Alternatively, it may be absent, which represents the default release type. <ul> <li>The "Beta" release type is used to indicate that the package was intended to be used for | | | | 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 | <p> The <b>releaseType</b> in template (12) will be Beta or Test. Alternatively, it may be absent, which represents the default release type. <ul> <li>The "Beta" release type is used to indicate that the package was intended to be used for <a href="https://en.wikipedia.org/wiki/Software_release_life_cycle#Beta">beta</a> testing.</li> <li>The "Test" release type is used to indicate that the package was intended to be used for <a href="https://en.wikipedia.org/wiki/Software_release_life_cycle#Release_candidate">release candidate</a> testing.</li> </ul> </p> <h3>Canonical Source Code</h3> <p> |
︙ | ︙ |
Changes to www/faq.wiki.
︙ | ︙ | |||
124 125 126 127 128 129 130 | <p> <b>(1) When will the next version of System.Data.SQLite be released?</b> </p> <p> The release schedule for the System.Data.SQLite project is roughly synchronized (within about two or three weeks) with that of the | | | 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 | <p> <b>(1) When will the next version of System.Data.SQLite be released?</b> </p> <p> The release schedule for the System.Data.SQLite project is roughly synchronized (within about two or three weeks) with that of the [https://www.sqlite.org/ | SQLite] core itself. The release history for the System.Data.SQLite project is [./news.wiki | here]. </p> <hr> <a name="q2"></a> <p> <b>(2) When are you planning on adding feature "X"?</b> |
︙ | ︙ | |||
223 224 225 226 227 228 229 | </p> <p> Yes, the following official NuGet packages are available: <ul> <li> | | | | | | | | | | | | | | | | | | | | | | 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 | </p> <p> Yes, the following official NuGet packages are available: <ul> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite"> System.Data.SQLite</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider, including support for LINQ and Entity Framework 6. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Beta"> System.Data.SQLite.Beta</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider, including support for LINQ and Entity Framework 6. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core"> System.Data.SQLite.Core</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Beta"> System.Data.SQLite.Core.Beta</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.Test"> System.Data.SQLite.Core.Test</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL"> System.Data.SQLite.Core.MSIL</a>: Just the managed ADO.NET provider for SQLite. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Beta"> System.Data.SQLite.Core.MSIL.Beta</a>: Just the managed ADO.NET provider for SQLite. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Core.MSIL.Test"> System.Data.SQLite.Core.MSIL.Test</a>: Just the managed ADO.NET provider for SQLite. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6"> System.Data.SQLite.EF6</a>: Just support for Entity Framework 6 using System.Data.SQLite. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Beta"> System.Data.SQLite.EF6.Beta</a>: Just support for Entity Framework 6 using System.Data.SQLite. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.EF6.Test"> System.Data.SQLite.EF6.Test</a>: Just support for Entity Framework 6 using System.Data.SQLite. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq"> System.Data.SQLite.Linq</a>: Just support for LINQ using System.Data.SQLite. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Beta"> System.Data.SQLite.Linq.Beta</a>: Just support for LINQ using System.Data.SQLite. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Linq.Test"> System.Data.SQLite.Linq.Test</a>: Just support for LINQ using System.Data.SQLite. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL"> System.Data.SQLite.MSIL</a>: Just the managed ADO.NET provider for SQLite. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Beta"> System.Data.SQLite.MSIL.Beta</a>: Just the managed ADO.NET provider for SQLite. <br><b>This package may contain "beta" code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.MSIL.Test"> System.Data.SQLite.MSIL.Test</a>: Just the managed ADO.NET provider for SQLite. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.Test"> System.Data.SQLite.Test</a>: The SQLite database engine for both x86 and x64 along with the ADO.NET provider, including support for LINQ and Entity Framework 6. <br><b>This package may contain pre-release code and is not intended for production use.</b> </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.x86"> System.Data.SQLite.x86</a>: The SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x86. </li> <li> <a href="https://www.nuget.org/packages/System.Data.SQLite.x64"> System.Data.SQLite.x64</a>: The SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x64. </li> </ul> </p> |
︙ | ︙ | |||
510 511 512 513 514 515 516 | </p> <p> A mixed-mode assembly is a dynamic link library that contains both managed code and native code for a particular processor architecture. Since it contains native code it can only be loaded into a process that matches the processor architecture it was compiled for. Also see this | | | 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 | </p> <p> A mixed-mode assembly is a dynamic link library that contains both managed code and native code for a particular processor architecture. Since it contains native code it can only be loaded into a process that matches the processor architecture it was compiled for. Also see this <a href="https://stackoverflow.com/questions/7266936/what-is-a-mixed-mode-assembly">StackOverflow question</a>. </p> <hr> <a name="q15"></a> <p> <b>(15) What is a "bundle" package (i.e. from the download page)?</b> </p> |
︙ | ︙ | |||
663 664 665 666 667 668 669 | <p> As of version 1.0.82.0, the native resources for a SQLiteConnection object, including any native locks on the underlying file, are not fully released until all SQLiteCommand, SQLiteDataReader, SQLiteStatement, and SQLiteBackup objects associated with that SQLiteConnection object have also been disposed. These changes were made to allow the SQLite native resource management to integrate better with the | | | | | 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 | <p> As of version 1.0.82.0, the native resources for a SQLiteConnection object, including any native locks on the underlying file, are not fully released until all SQLiteCommand, SQLiteDataReader, SQLiteStatement, and SQLiteBackup objects associated with that SQLiteConnection object have also been disposed. These changes were made to allow the SQLite native resource management to integrate better with the <a href="https://en.wikipedia.org/wiki/Garbage_collection_%28computer_science%29">garbage collection</a> semantics used by the <a href="https://en.wikipedia.org/wiki/Common_Language_Runtime">Common Language Runtime</a>. Allowing native SQLite resources to be released in a non-deterministic order is accomplished through careful use of the <a href="https://www.sqlite.org/c3ref/close.html">sqlite3_close_v2()</a> core native library routine. </p> |
Changes to www/index.wiki.
1 2 3 4 5 6 7 8 9 10 11 12 | <title>Home</title> <nowiki> <br> <table width="100%" cellpadding="5"> <tr> <td width="20%"> </td> <td> <h2>About System.Data.SQLite</h2> <p> System.Data.SQLite is an ADO.NET provider for | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | <title>Home</title> <nowiki> <br> <table width="100%" cellpadding="5"> <tr> <td width="20%"> </td> <td> <h2>About System.Data.SQLite</h2> <p> System.Data.SQLite is an ADO.NET provider for <a href="https://www.sqlite.org/">SQLite</a>. </p> <p> System.Data.SQLite was started by Robert Simpson. Robert still has commit privileges on this repository but is no longer an active contributor. Development and maintenance work is now mostly performed by the SQLite Development Team. The SQLite team is committed to supporting System.Data.SQLite long-term. |
︙ | ︙ | |||
37 38 39 40 41 42 43 | </p> <h2>Documentation for System.Data.SQLite</h2> <p> The documentation corresponding to the most recently released version of System.Data.SQLite, which contains detailed information for all public types, methods, properties, and events is checked into the repository in | | | 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 | </p> <h2>Documentation for System.Data.SQLite</h2> <p> The documentation corresponding to the most recently released version of System.Data.SQLite, which contains detailed information for all public types, methods, properties, and events is checked into the repository in <a href="https://en.wikipedia.org/wiki/Microsoft_Compiled_HTML_Help"> <i>Microsoft Compiled HTML Help</i> ("CHM") format</a>. It can also be <a href="/index.html/doc/trunk/Doc/SQLite.NET.chm?mimetype=application/x-chm"> <b>downloaded directly</b></a> via the web interface to the repository. </p> </td> <td width="30%" valign="top"> |
︙ | ︙ |
Changes to www/news.wiki.
1 2 3 4 5 6 7 8 | <title>News</title> <b>Version History</b> <p> <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> | | | | | | | | | | | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 | <title>News</title> <b>Version History</b> <p> <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_8_2.html|SQLite 3.8.8.2].</li> <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.2|Entity Framework 6.1.2].</li> <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li> <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li> <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li> <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li> <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li> <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li> <li>In the SQLiteDataReader.VerifyType method, remove duplicate "if" statement for the DbType.SByte value and move the remaining "if" to the Int64 affinity. Fix for [c5cc2fb334]. <b>** Potentially Incompatible Change **</b></li> <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe]. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1]. <b>** Potentially Incompatible Change **</b></li> <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932]. <b>** Potentially Incompatible Change **</b></li> <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3]. <b>** Potentially Incompatible Change **</b></li> <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li> <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li> <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.94.0 - September 9, 2014</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_6.html|SQLite 3.8.6].</li> <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.1|Entity Framework 6.1.1].</li> <li>Refactor and simplify NuGet packages in order to support per-solution SQLite interop assembly files. <b>** Potentially Incompatible Change **</b></li> <li>Add RefreshFlags method to the SQLiteDataReader class to forcibly refresh its connection flags.</li> <li>Improve automatic detection and handling of the Entity Framework 6 assembly by the design-time components installer. Pursuant to [e634e330a6]. <b>** Potentially Incompatible Change **</b></li> <li>Improve SQLiteDataReader performance slightly by caching the connection flags. <b>** Potentially Incompatible Change **</b></li> <li>Add ClearCachedSettings method to the SQLiteConnection class.</li> <li>Add NoConvertSettings connection flag to disable querying of runtime configuration settings from within the SQLiteConvert class. Pursuant to [58ed318f2f].</li> <li>Minimize usage of the "Use_SQLiteConvert_DefaultDbType" and "Use_SQLiteConvert_DefaultTypeName" settings. Fix for [58ed318f2f]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.93.0 - June 23, 2014</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_5.html|SQLite 3.8.5].</li> <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1|Entity Framework 6.1].</li> <li>Add support for mapping transaction isolation levels to their legacy default values. Pursuant to [56b42d99c1].</li> <li>Add support for setting the default DbType and type name used for mappings on a per-connection basis. Pursuant to [3c00ec5b52].</li> <li>Add DetectTextAffinity and DetectStringType connection flags to enable automatic detection of column types, when necessary. Pursuant to [3c00ec5b52].</li> <li>Add SetChunkSize method to the SQLiteConnection class. Pursuant to [d1c008fa0a].</li> <li>Add SharedFlags static property to the SQLiteConnection class.</li> <li>Make the ISQLiteSchemaExtensions interface public. <b>** Potentially Incompatible Change **</b></li> <li>Have the SQLiteProviderFactory class (in the System.Data.SQLite.Linq assembly) implement the IServiceProvider interface.</li> <li>Fix bug in documentation generator automation that prevented some internal documentation links from working.</li> <li>Fix DateTime constant handling in the LINQ assembly. Fix for [da9f18d039]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.92.0 - March 19, 2014</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_4_1.html|SQLite 3.8.4.1].</li> <li>Update the list of keywords returned by SQLiteConnection.GetSchema("ReservedWords"). <b>** Potentially Incompatible Change **</b></li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand or SQLiteDataReader object is closed or disposed.</li> <li>Add the SQLiteDataReader.StepCount property to return the number of rows seen so far.</li> <li>Add StickyHasRows connection flag to cause the SQLiteDataReader.HasRows property to return non-zero if there were ever any rows in the associated result sets.</li> <li>When the TraceWarning connection flag is set, issue warnings about possibly malformed UNC paths. Pursuant to [283344397b].</li> <li>Convert the primary NuGet package, "System.Data.SQLite", into a meta-package.</li> <li>Enhancements to the NuGet packages, including the new "modular" packages.</li> </ul> <p> <b>1.0.91.0 - February 12, 2014</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_3_1.html|SQLite 3.8.3.1].</li> <li>Refresh all included SQLite core library documentation (e.g. SQL syntax).</li> <li>Add support for [https://entityframework.codeplex.com/|Entity Framework 6].</li> <li>Add support for per-connection mappings between type names and DbType values. Pursuant to [e87af1d06a].</li> <li>Modify the namespace used for all internal classes in the System.Data.SQLite.Linq assembly. <b>** Potentially Incompatible Change **</b></li> <li>Add SQLiteCompileOptions and InteropCompileOptions properties to the SQLiteConnection class to return the compile-time options for the SQLite core library and interop assembly, respectively.</li> <li>Add BindInvariantText and ConvertInvariantText connection flags to force the invariant culture to be used when converting parameter values to/from strings.</li> <li>Add NoConnectionPool and UseConnectionPool connection flags to disable or enable connection pooling by default.</li> <li>Modify handling of the design-time components installer to run Visual Studio <b>devenv.exe /setup</b> after installing the package. This appears to be necessary in some circumstances for Visual Studio 2013. Pursuant to [a47eff2c71].</li> <li>Modify the native library pre-loader to support reading settings from an XML configuration file and to be capable of checking more than one directory. Persuant to [f0246d1817].</li> <li>Support detecting when the native library pre-loader should use the CodeBase property instead of the Location property as the basis for locating the interop assembly.</li> <li>Change the default behavior for the native library pre-loader so it first searches the executing (i.e. System.Data.SQLite) assembly directory and then the application domain directory. Pursuant to [f0246d1817]. <b>** Potentially Incompatible Change **</b></li> <li>Include DbType.AnsiString in the list of types that need special ColumnSize handling. Fix for [0550f0326e].</li> </ul> <p> <b>1.0.90.0 - December 23, 2013</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_2.html|SQLite 3.8.2].</li> <li>Add Visual Studio 2013 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2013 support to the redesigned designer support installer.</li> <li>Add support for Windows Embedded Compact 2013.</li> <li>Add experimental support for the native regexp extension.</li> <li>Never create a new connection wrapper in the SQLiteConnection.Shutdown method. <b>** Potentially Incompatible Change **</b></li> <li>Add experimental GetMemoryStatistics, ReleaseMemory, and Shutdown methods to the SQLiteConnection class.</li> <li>Add memory leak detection to the test project for the .NET Compact Framework.</li> <li>Add SQLITE_ENABLE_MEMORY_MANAGEMENT compile-time option to the interop assembly.</li> <li>Use current isolation level when enlisting into an existing transaction. Fix for [56b42d99c1].</li> <li>Better handling of non-error log messages from the SQLite core library. Pursuant to [44df10ea90].</li> <li>Add TraceWarning connection flag to enable tracing of type mapping failures and disable tracing of them by default. Pursuant to [6d45c782e4].</li> <li>Use 32-bit values to keep track of numeric precision and scale when building the schema table for a query. Fix for [ef2216192d].</li> </ul> <p> <b>1.0.89.0 - October 28, 2013</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_8_1.html|SQLite 3.8.1].</li> <li>Add AutoCommit property to the SQLiteConnection class. Fix for [9ba9346f75].</li> <li>Use declared column sizes for the AnsiStringFixedLength and StringFixedLength mapped database types. Fix for [3113734605].</li> <li>Check the result of sqlite3_column_name function against NULL.</li> <li>Return false for the SQLiteParameterCollection.IsSynchronized property because it is not thread-safe.</li> <li>Raise the static SQLiteConnection.Changed event when any SQLiteCommand, SQLiteDataReader, or CriticalHandle derived object instance is created. Fix for [aba4549801].</li> <li>Add SQLiteCommand.Execute, SQLiteCommand.ExecuteNonQuery, and SQLiteCommand.ExecuteScalar method overloads that take a CommandBehavior parameter.</li> <li>Revise how the extra object data is passed to the static SQLiteConnection.Changed event. <b>** Potentially Incompatible Change **</b></li> |
︙ | ︙ | |||
145 146 147 148 149 150 151 | <li>Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to [bbdda6eae2].</li> <li>Rename the ReturnCode property of the SQLiteException class to ResultCode. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.86.0 - May 23, 2013</b> </p> <ul> | | | | 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 | <li>Disable use of the new connection string parsing algorithm when the No_SQLiteConnectionNewParser environment variable is set. Pursuant to [bbdda6eae2].</li> <li>Rename the ReturnCode property of the SQLiteException class to ResultCode. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.86.0 - May 23, 2013</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_17.html|SQLite 3.7.17].</li> <li>Disable use of the AllowPartiallyTrustedCallers attribute when compiled for the .NET Framework 4.0/4.5. <b>** Potentially Incompatible Change **</b></li> <li>Allow semi-colons in the data source file name. Fix for [e47b3d8346]. <b>** Potentially Incompatible Change **</b></li> <li>NULL values should be reported as type "object", not "DBNull". Fix for [48a6b8e4ca].</li> </ul> <p> <b>1.0.85.0 - April 18, 2013</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_16_2.html|SQLite 3.7.16.2].</li> <li>Properly handle embedded NUL characters in parameter and column values. Fix for [3567020edf].</li> <li>Make use of the sqlite3_prepare_v2 function when applicable.</li> <li>Check for a valid row in the SQLiteDataReader.GetValue method.</li> <li>Implement processor architecture detection when running on the .NET Compact Framework (via P/Invoke).</li> <li>Support automated testing when running on the .NET Compact Framework 2.0.</li> <li>Skip checking loaded assemblies for types tagged with the SQLiteFunction attribute when the No_SQLiteFunctions environment variable is set. Pursuant to [e4c8121f7b].</li> <li>Add HexPassword connection string property to work around the inability to include a literal semicolon in a connection string property value. Pursuant to [1c456ae75f].</li> |
︙ | ︙ | |||
179 180 181 182 183 184 185 | <li>Support using the directory containing the primary managed-only assembly as the basis for native library pre-loading.</li> <li>Still further enhancements to the build and test automation.</li> </ul> <p> <b>1.0.84.0 - January 9, 2013</b> </p> <ul> | | | | 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 | <li>Support using the directory containing the primary managed-only assembly as the basis for native library pre-loading.</li> <li>Still further enhancements to the build and test automation.</li> </ul> <p> <b>1.0.84.0 - January 9, 2013</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_15_2.html|SQLite 3.7.15.2].</li> <li>Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].</li> <li>Add Cancel method to the SQLiteConnection class to interrupt a long running query.</li> <li>Improve thread safety of the SQLiteLog.LogMessage method.</li> </ul> <p> <b>1.0.83.0 - December 29, 2012</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_15_1.html|SQLite 3.7.15.1].</li> <li>Add Visual Studio 2012 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2012 support to the redesigned designer support installer.</li> <li>Allow opened connections to skip adding the extension functions included in the interop assembly via the new NoExtensionFunctions connection flag.</li> <li>Support loading of SQLite extensions via the new EnableExtensions and LoadExtension methods of the SQLiteConnection class. Pursuant to [17045010df].</li> <li>Remove one set of surrounding single or double quotes from property names and values parsed from the connection string. Fix for [b4cc611998].</li> <li>Modify parsing of connection strings to allow property names and values to be quoted. <b>** Potentially Incompatible Change **</b></li> <li>Add ParseViaFramework property to the SQLiteConnection class to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Pursuant to [b4cc611998].</li> |
︙ | ︙ | |||
224 225 226 227 228 229 230 | <li>Further enhancements to the build and test automation.</li> <li>Add test automation for the Windows CE binaries.</li> </ul> <p> <b>1.0.82.0 - September 3, 2012</b> </p> <ul> | | | | | | | | 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 | <li>Further enhancements to the build and test automation.</li> <li>Add test automation for the Windows CE binaries.</li> </ul> <p> <b>1.0.82.0 - September 3, 2012</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_14.html|SQLite 3.7.14].</li> <li>Properly handle quoted data source values in the connection string. Fix for [8c3bee31c8].</li> <li>The [https://www.nuget.org/packages/System.Data.SQLite|primary NuGet package] now supports x86 / x64 and the .NET Framework 2.0 / 4.0 (i.e. in a single package).</li> <li>Change the default value for the Synchronous connection string property to Full to match the default used by the SQLite core library itself. <b>** Potentially Incompatible Change **</b></li> <li>Add the ability to skip applying default connection settings to opened databases via the new SetDefaults connection string property.</li> <li>Add the ability to skip expanding data source file names to their fully qualified paths via the new ToFullPath connection string property.</li> <li>Fix the database cleanup ordering in the tests for ticket [343d392b51].</li> <li>Add support for the sqlite3_close_v2 function from the SQLite core library.</li> <li>Add support for [https://www.sqlite.org/uri.html|URI file names] via the new FullUri connection string property.</li> <li>Improve support for the standard SQLite core library in the LINQ assembly and the test suite.</li> <li>Add SetMemoryStatus static method to the SQLiteConnection class.</li> <li>Improve threaded handling of the delegate used by the SQLiteLog class.</li> <li>Add define constants to support enabling or disabling individual groups of trace statements.</li> </ul> <p> <b>1.0.81.0 - May 27, 2012</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_12_1.html|SQLite 3.7.12.1].</li> <li>Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec.</li> <li>Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly.</li> <li>Add release archive verification tool to the release automation.</li> <li>Fix NullReferenceException when calling the SQLiteDataAdapter.FillSchema method on a query that returns multiple result sets. Fix for [3aa50d8413].</li> <li>Fix subtle race condition between threads fetching connection handles from the connection pool and any garbage collection (GC) threads that may be running. Fix for [996d13cd87].</li> <li>Add missing call to SetTimeout in the SQLite3_UTF16.Open method.</li> <li>Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid.</li> <li>Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library.</li> <li>Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon.</li> <li>Revise CriticalHandle derived classes to make them more thread-safe.</li> <li>Add connection pool related diagnostic messages when compiled with the DEBUG define constant.</li> <li>Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection.</li> <li>Rename internal SQLiteLastError methods to GetLastError.</li> <li>Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files.</li> </ul> <p> <b>1.0.80.0 - April 1, 2012</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_11.html|SQLite 3.7.11].</li> <li>In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb].</li> <li>Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite.</li> <li>Add Visual Studio 2005 support to the redesigned designer support installer.</li> <li>Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time.</li> <li>Add support for the native [https://www.sqlite.org/backup.html|SQLite Online Backup API]. Fix for [c71846ed57].</li> <li>Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77].</li> <li>Support tracing of all parameter binding activity and use the connection flags to control what is traced.</li> <li>When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available.</li> <li>Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection.</li> <li>Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch.</li> <li>In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null.</li> <li>Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5].</li> |
︙ | ︙ | |||
296 297 298 299 300 301 302 | <li>Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for [d8491abd0b].</li> <li>Correct resource name used by the LINQ assembly to locate several key string resources. Fix for [fbebb30da9].</li> </ul> <p> <b>1.0.78.0 - January 27, 2012</b> </p> <ul> | | | | 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 | <li>Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for [d8491abd0b].</li> <li>Correct resource name used by the LINQ assembly to locate several key string resources. Fix for [fbebb30da9].</li> </ul> <p> <b>1.0.78.0 - January 27, 2012</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_10.html|SQLite 3.7.10] <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> <li>When emitting SQL for foreign keys in the VS designer, be sure to take all returned schema rows into account. Remainder of fix for [b226147b37].</li> <li>Add Flags connection string property to control extra behavioral flags for the connection.</li> <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> <li>Even more enhancements to the build and test automation.</li> <li>Support parameter binding to more primitive types, including unsigned integer types.</li> <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li> <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li> <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li> <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. <b>** Potentially Incompatible Change **</b></li> </ul> <p> <b>1.0.77.0 - November 28, 2011</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_9.html|SQLite 3.7.9] <li>More enhancements to the build and test automation.</li> <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> <li>The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer.</li> <li>When compiled with DEBUG defined, emit diagnostic information related to resource cleanup to any TraceListener objects that may be registered.</li> <li>Stop characterizing all log messages as errors. From now on, if the errorCode is zero, the message will not be considered an error.</li> <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for [2ce0870fad].</li> <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> |
︙ | ︙ | |||
342 343 344 345 346 347 348 | <li>Prevent the domain unload event handler in SQLiteLog from being registered multiple times. Fix for [0d5b1ef362].</li> <li>Stop allowing non-default application domains to initialize the SQLiteLog class. Fix for [ac47dd230a].</li> </ul> <p> <b>1.0.75.0 - October 3, 2011</b> </p> <ul> | | | | 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 | <li>Prevent the domain unload event handler in SQLiteLog from being registered multiple times. Fix for [0d5b1ef362].</li> <li>Stop allowing non-default application domains to initialize the SQLiteLog class. Fix for [ac47dd230a].</li> </ul> <p> <b>1.0.75.0 - October 3, 2011</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_8.html|SQLite 3.7.8] <li>More enhancements to the build system.</li> <li>Add official [https://www.nuget.org/|NuGet] packages for x86 and x64.</li> <li>Add Changes and LastInsertRowId properties to the connection class.</li> <li>Support more formats when converting data from/to the DateTime type.</li> <li>Make all the assembly versioning attributes consistent.</li> <li>Add unit testing infrastructure using [http://eagle.to/|Eagle].</li> <li>Integrate all legacy unit tests, including the "testlinq" project, into the new test suite.</li> <li>Add projects to build the interop assembly statically linked to the Visual C++ runtime. Fix for [53f0c5cbf6].</li> <li>Add SQLITE_ENABLE_STAT2 compile-time option to the interop assembly. Fix for [74807fbf27].</li> |
︙ | ︙ | |||
371 372 373 374 375 376 377 | <li>Fix incorrect resource name for SR.resx in the mixed-mode assembly.</li> <li>Reduce the number of String.Compare() calls in the hot path for SQLiteCommand.ExecuteReader().</li> </ul> <p> <b>1.0.74.0 - July 4, 2011</b> </p> <ul> | | | | | | | | 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 | <li>Fix incorrect resource name for SR.resx in the mixed-mode assembly.</li> <li>Reduce the number of String.Compare() calls in the hot path for SQLiteCommand.ExecuteReader().</li> </ul> <p> <b>1.0.74.0 - July 4, 2011</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_7_1.html|SQLite 3.7.7.1] <li>Fix incorrect hard-coded .NET Framework version information SQLiteFactory_Linq.cs that was causing IServiceProvider.GetService to fail when running against the .NET Framework 3.5.</li> <li>Fix all XML documentation warnings.</li> <li>Restore support for the mixed-mode assembly (i.e. the one that can be registered in the Global Assembly Cache).</li> <li>Restore support for the Compact Framework.</li> <li>Remove unused "using" statements from the System.Data.SQLite and System.Data.SQLite.Linq projects.</li> <li>Remove hard-coded System.Data.SQLite.Linq version from SQLiteFactory_Linq.cs</li> <li>Modify the setup to support bundled packages (i.e. with the mixed-mode assembly) and standard packages (i.e. with the managed assembly separate from the native interop library).</li> <li>Disable the ability to register with the Global Assembly Cache in the standard setup package (i.e. it is available in the bundled setup only).</li> <li>Remove PATH modification from the setup.</li> <li>Modify the naming scheme for the source, setup, and binary packages to allow for the necessary variants.</li> <li>In the build automation, attempt to automatically detect if Visual Studio 2008 and/or 2010 are installed and support building binaries for both at once, when available.</li> <li>Add release automation to build the source, setup, and binary packages in all supported build variants.</li> <li>Add the testlinq project to the new build system and make it work properly with Visual Studio 2008 and 2010.</li> </ul> <p> <b>1.0.73.0 - June 2, 2011</b> </p> <ul> <li>Updated to [https://www.sqlite.org/releaselog/3_7_6_3.html|SQLite 3.7.6.3].</li> <li>Minor optimization to GetBytes(). Fix for [8c1650482e].</li> <li>Update various assembly information settings.</li> <li>Correct System.Data.SQLite.Linq version and resource information. Fix for [6489c5a396] and [133daf50d6].</li> <li>Moved log handler from SQLiteConnection object to SQLiteFactory object to prevent if from being prematurely GCed.</li> <li>We should block x64 installs on x86 and we should install native only if the setup package itself is native. Fix for [e058ce156e].</li> </ul> <p> <b>1.0.72.0 - May 1, 2011</b> </p> <ul> <li>Add the correct directory to the path. Fix for [50515a0c8e].</li> </ul> <p> <b>1.0.71.0 - April 27, 2011</b> </p> <ul> <li>Updated to SQLite 3.7.6+ [https://www.sqlite.org/src/info/1bd1484cd7 | [1bd1484cd7]]</a> to get additional Windows error logging.</li> <li>Updated setup to optionally add install directory to PATH if GAC option selected.</li> </ul> <p> <b>1.0.70.0 - April 22, 2011</b> </p> <ul> <li>Added support for sqlite3_extended_result_codes(), sqlite3_errcode(), and sqlite3_extended_errcode() via SetExtendedResultCodes(), ResultCode(), and ExtendedResultCode().</li> <li>Added support for SQLITE_CONFIG_LOG via SQLiteLogEventHandler().</li> </ul> <p> <b>1.0.69.0 - April 12, 2011</b> </p> <ul> <li>Code merge with [https://www.sqlite.org/releaselog/3_7_6.html | SQLite 3.7.6].</li> <li>New VS2008 and VS2010 solution files.</li> <li>Build and packaging automation.</li> <li>New Inno Setup files.</li> <li>Designer support currently not ready for release.</li> </ul> <p> <b>1.0.68.0 - February 2011</b> </p> <ul> <li>Code merge with [https://www.sqlite.org/releaselog/3_7_5.html | SQLite 3.7.5].</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> <p> <b>1.0.67.0 - January 3, 2011</b> </p> <ul> <li>Code merge with [https://www.sqlite.org/releaselog/3_7_4.html | SQLite 3.7.4].</li> <li>Continuing work on supporting Visual Studio 2010.</li> </ul> |
Changes to www/release.wiki.
︙ | ︙ | |||
200 201 202 203 204 205 206 | <ol> <li>Open a normal command prompt window with "cmd.exe".</li> <li>Change the current directory to "<root>\Doc".</li> <li> Enter the following command to build all the documentation in | | | | | 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 | <ol> <li>Open a normal command prompt window with "cmd.exe".</li> <li>Change the current directory to "<root>\Doc".</li> <li> Enter the following command to build all the documentation in [https://en.wikipedia.org/wiki/Microsoft_Compiled_HTML_Help | CHM] format: <br /> <br /> <b>tclsh.exe buildChm.tcl</b> <br /> <br /> <i>This assumes that [https://www.activestate.com/activetcl | ActiveTcl] version 8.4 or later, the [https://www.microsoft.com/download/en/details.aspx?displaylang=en&id=21138 | HTML Help Workshop], and [http://ndoc3.sourceforge.net/ | NDoc3] have all been installed using the default settings.</i> </li> </ol> <a name="buildSetupPackages"></a> <h2>Build Setup Release Packages</h2> |
︙ | ︙ | |||
321 322 323 324 325 326 327 | <li> Enter the following command to build all the source release packages: <br /> <br /> <b>..\Externals\Eagle\bin\EagleShell.exe -file verify.eagle Output true</b> <br /> <br /> | | | | 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 | <li> Enter the following command to build all the source release packages: <br /> <br /> <b>..\Externals\Eagle\bin\EagleShell.exe -file verify.eagle Output true</b> <br /> <br /> <i>This assumes that the <a href="https://www.fossil-scm.org/">Fossil</a>, <a href="https://sourceforge.net/projects/innounp/">Inno Setup Unpacker</a>, <a href="http://www.rarlab.com/">UnRAR</a>, and <a href="http://www.info-zip.org/">UnZip</a> binaries are available in the locations specified via the "FossilTool", "InnoUnpackTool", "UnRARTool", and "UnZipTool" environment variables, respectively.</i> <br /> <br /> |
︙ | ︙ | |||
353 354 355 356 357 358 359 | Enter the following command to build all the NuGet packages: <br /> <br /> <b>build_nuget.bat</b> <br /> <br /> <i>This assumes that the NuGet binary is available somewhere along the | | | | 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 | Enter the following command to build all the NuGet packages: <br /> <br /> <b>build_nuget.bat</b> <br /> <br /> <i>This assumes that the NuGet binary is available somewhere along the [https://en.wikipedia.org/wiki/PATH_%28variable%29 | PATH].<br />Please refer to [https://docs.nuget.org/ | NuGet Documentation] for further details.</i> </li> </ol> <a name="updateDownloadsPage"></a> <h2>Update Downloads Page</h2> <ol> |
︙ | ︙ | |||
380 381 382 383 384 385 386 | Enter the following command to update the sizes and hashes on the downloads page based on all the built release packages: <br /> <br /> <b>tclsh.exe updateFileInfo.tcl</b> <br /> <br /> | | | | | | | 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 | Enter the following command to update the sizes and hashes on the downloads page based on all the built release packages: <br /> <br /> <b>tclsh.exe updateFileInfo.tcl</b> <br /> <br /> <i>This assumes that [https://www.activestate.com/activetcl | ActiveTcl] version 8.4 or later has been installed using the default settings and that the Fossil binary is available somewhere along the [https://en.wikipedia.org/wiki/PATH_%28variable%29 | PATH] (i.e. for calculating the SHA1 hashes).</i> </li> </ol> <a name="publishRelease"></a> <h2>Publish Release</h2> <ol> <li>Upload all the release packages to the web site.</li> <li> Commit pending source code changes to the [https://www.fossil-scm.org/ | Fossil] repository. </li> <li>Tag the release in the Fossil repository.</li> <li> Push the [https://www.nuget.org/ | NuGet] packages.<br /> <i>Please refer to [https://docs.nuget.org/ | NuGet Documentation] for further details.</i> </li> <li>Announce the release on the System.Data.SQLite mailing list.</li> </ol> |
Changes to www/source.wiki.
︙ | ︙ | |||
23 24 25 26 27 28 29 | (and potentially other projects) is to reside. </p> <a name="fossil"></a> <h2>Obtain & Install Fossil Itself</h2> <p> | | | | | | | 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | (and potentially other projects) is to reside. </p> <a name="fossil"></a> <h2>Obtain & Install Fossil Itself</h2> <p> The [https://www.fossil-scm.org | Fossil] open-source [https://en.wikipedia.org/wiki/Distributed_revision_control | distributed version control] system is a computer program that must be installed on your machine before you use it. Fortunately, installing Fossil is very easy. Fossil consists of a single executable file that you simply download and run. For convenience, the Fossil executable file should be placed in a directory present in your [https://en.wikipedia.org/wiki/PATH_%28variable%29 | PATH]. To uninstall Fossil, simply delete the executable file. [https://www.fossil-scm.org/index.html/doc/tip/www/quickstart.wiki | Detailed instructions] for installing and getting started with Fossil are available on the [https://www.fossil-scm.org/ | Fossil website]. </p> <a name="clone"></a> <h2>Clone Repository (Windows)</h2> <ol> <li>Open a Windows command prompt using "<b>cmd.exe</b>".</li> |
︙ | ︙ | |||
56 57 58 59 60 61 62 | <li> Enter the following command to create a complete clone (i.e. local copy) of the entire source code repository for the System.Data.SQLite project, including the entire check-in history: <br /> <br /> | | | | | | 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 | <li> Enter the following command to create a complete clone (i.e. local copy) of the entire source code repository for the System.Data.SQLite project, including the entire check-in history: <br /> <br /> <b>fossil [https://www.fossil-scm.org/index.html/help/clone | clone] https://system.data.sqlite.org/ <repositories>/sds.fossil</b> </li> <li> Please note that the repository itself uses an [https://www.fossil-scm.org/index.html/doc/trunk/www/fileformat.wiki | enduring file format] stored in a single [https://www.fossil-scm.org/index.html/doc/trunk/www/tech_overview.wiki | SQLite database file] with a particular schema. </li> <li> In this case, after executing the [https://www.fossil-scm.org/index.html/help/clone | clone] command, the local clone of the repository will be placed into the "<b>sds.fossil</b>" file in the <b><repositories></b> directory. </li> </ol> <a name="working"></a> <h2>Working Copy (Windows)</h2> |
︙ | ︙ | |||
94 95 96 97 98 99 100 | </li> <li> Enter the following command to create a local working copy of all the files that are currently part of the System.Data.SQLite project: <br /> <br /> | | | | 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 | </li> <li> Enter the following command to create a local working copy of all the files that are currently part of the System.Data.SQLite project: <br /> <br /> <b>fossil [https://www.fossil-scm.org/index.html/help/open | open] <repositories>/sds.fossil</b> </li> <li> The local source tree should now be ready for use as described in the [./build.wiki | build procedures] and/or [./test.wiki | test procedures]. </li> <li> In the future, to update the local working copy with the latest changes from the official System.Data.SQLite repository (i.e. instead of having to re-clone the entire thing), enter the following command from the same directory where the working copy is located: <br /> <br /> <b>fossil [https://www.fossil-scm.org/index.html/help/update | update]</b> </li> </ol> |
Changes to www/support.wiki.
︙ | ︙ | |||
44 45 46 47 48 49 50 | Off-site archives of the <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users"> sqlite-users</a> list are available at: </p> <ul> <li> | | | | | | | 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 | Off-site archives of the <a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users"> sqlite-users</a> list are available at: </p> <ul> <li> <a href="https://www.mail-archive.com/sqlite-users%40sqlite.org/"> https://www.mail-archive.com/sqlite-users%40sqlite.org/</a> </li> <li> <a href="https://marc.info/?l=sqlite-users&r=1&w=2"> https://marc.info/?l=sqlite-users&r=1&w=2</a> </li> <li> <a href="http://news.gmane.org/gmane.comp.db.sqlite.general"> http://news.gmane.org/gmane.comp.db.sqlite.general</a> </li> </ul> <h3>Direct E-Mail</h3> <p> Use the mailing list. Please do <b>not</b> send email directly to the authors of SQLite or System.Data.SQLite unless: </p> <ul> <li> You have or intend to acquire a <a href="https://www.sqlite.org/support.html"> professional support contract</a>. </li> <li> You are working on an open source project. </li> </ul> |
︙ | ︙ |
Changes to www/test.wiki.
︙ | ︙ | |||
59 60 61 62 63 64 65 | "<root>\bin\<year>\<platform>\<configuration>" for the mixed-mode assembly). </p> <p> The new unit tests have been setup using <a href="http://eagle.to/">Eagle</a> and its associated unit testing framework, named "Eagle.Test". | | | | 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 | "<root>\bin\<year>\<platform>\<configuration>" for the mixed-mode assembly). </p> <p> The new unit tests have been setup using <a href="http://eagle.to/">Eagle</a> and its associated unit testing framework, named "Eagle.Test". Eagle itself is an implementation of the <a href="https://www.tcl.tk/">Tcl</a> scripting language for the Common Language Runtime (CLR). "Eagle.Test" is the unit testing framework for Eagle, packaged as a collection of Eagle scripts, based loosely on the implementation of <a href="https://www.tcl.tk/man/tcl8.4/TclCmd/tcltest.htm">tcltest</a>. </p> <a name="automated"></a> <h2>Automated Unit Tests</h2> <ol> <li>Open a normal command prompt window with "cmd.exe".</li> |
︙ | ︙ |