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

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

Overview
Comment:Documentation updates in preparation for release 1.0.78.0.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b694fa3e06d274bd315f48aef4915b18377303c6
User & Date: mistachkin 2012-01-21 04:51:14
Context
2012-01-21
05:06
Update core SQLite version numbers to 3.7.10 in the VS props files. check-in: c5610e4d97 user: mistachkin tags: trunk
04:51
Documentation updates in preparation for release 1.0.78.0. check-in: b694fa3e06 user: mistachkin tags: trunk
2012-01-17
12:42
Update core SQLite to 3.7.10 release. check-in: 4ec265e1b4 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/version.html.

    39     39             </td>
    40     40           </tr>
    41     41         </table>
    42     42       </div>
    43     43       <div id="mainSection">
    44     44       <div id="mainBody">
    45     45       <h1 class="heading">Version History</h1>
           46  +    <p><b>1.0.78.0 - January XX, 2012</b></p>
           47  +    <ul>
           48  +      <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li>
           49  +      <li>Redesign the VS designer support installer and integrate it into the setup packages.</li>
           50  +      <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li>
           51  +      <li>Even more enhancements to the build and test automation.</li>
           52  +      <li>Support parameter binding to more primitive types, including unsigned integer types.</li>
           53  +      <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for <a href="http://system.data.sqlite.org/index.html/info/bb4b04d457">[bb4b04d457]</a>.</li>
           54  +      <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for <a href="http://system.data.sqlite.org/index.html/info/3fc172d1be">[3fc172d1be]</a>.</li>
           55  +      <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for <a href="http://system.data.sqlite.org/index.html/info/f3ec1e0066">[f3ec1e0066]</a>.</li>
           56  +      <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/4bbf851fa5">[4bbf851fa5]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
           57  +    </ul>
    46     58       <p><b>1.0.77.0 - November 28, 2011</b></p>
    47     59       <ul>
    48     60         <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li>
    49     61         <li>More enhancements to the build and test automation.</li>
    50     62         <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li>
    51     63         <li>The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer.</li>
    52     64         <li>When compiled with DEBUG defined, emit diagnostic information related to resource cleanup to any TraceListener objects that may be registered.</li>
................................................................................
    54     66         <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="http://system.data.sqlite.org/index.html/info/2ce0870fad">[2ce0870fad]</a>.</li>
    55     67         <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li>
    56     68         <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for <a href="http://system.data.sqlite.org/index.html/info/566f1ad1e4">[566f1ad1e4]</a>.</li>
    57     69         <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="http://system.data.sqlite.org/index.html/info/7e3fa93744">[7e3fa93744]</a>.</li>
    58     70         <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="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li>
    59     71         <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li>
    60     72         <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li>
    61         -      <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li>
           73  +      <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    62     74         <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li>
    63     75         <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="http://system.data.sqlite.org/index.html/info/737ca4ff74">[737ca4ff74]</a>.</li>
    64     76         <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for <a href="http://system.data.sqlite.org/index.html/info/544dba0a2f">[544dba0a2f]</a>.</li>
    65     77         <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for <a href="http://system.data.sqlite.org/index.html/info/84718e79fa">[84718e79fa]</a>.</li>
    66     78       </ul>
    67     79       <p><b>1.0.76.0 - October 4, 2011</b></p>
    68     80       <ul>

Changes to readme.htm.

     1      1   <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
     2      2   <html>
     3      3   <head>
     4      4   <title></title>
     5      5   </head>
     6      6   <body>
     7      7   ADO.NET SQLite Data Provider<br />
     8         -Version 1.0.77.0 November 28, 2011<br />
     9         -Using SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/c7c6050ef0">[c7c6050ef0]</a><br />
            8  +Version 1.0.78.0 January XX, 2012<br />
            9  +Using SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a><br />
    10     10   Originally written by Robert Simpson<br />
    11     11   Released to the public domain, use at your own risk!<br />
    12         -Official provider website:&nbsp; <a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br />
    13         -Legacy versions:&nbsp; <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br />
           12  +Official provider website:&nbsp;<a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br />
           13  +Legacy versions:&nbsp;<a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br />
    14     14   <br />
    15         -The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?n=20&y=ci">
    16         -http://system.data.sqlite.org/index.html/timeline?n=20&y=ci</a>
           15  +The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?y=ci">
           16  +http://system.data.sqlite.org/index.html/timeline?y=ci</a>
    17     17   <br />
    18     18   <br />
    19     19   
    20     20   <h2><b>Features</b></h2>
    21     21   
    22     22   <ul>
    23     23     <li>
................................................................................
    52     52     <li>
    53     53       Visual Studio design-time Support, works with all versions of Visual Studio
    54     54       2005/2008/2010.  You can add a SQLite database to the Servers list, design
    55     55       queries with the Query Designer, drag-and-drop tables onto a Typed DataSet,
    56     56       etc.
    57     57       <br />
    58     58       <font color="red">
    59         -      Currently not included.  We are still updating the design-time support
    60         -      installer.  Due to Visual Studio licensing restrictions, the Express
    61         -      Editions can no longer be supported.
           59  +      Due to Visual Studio licensing restrictions, the Express Editions can no
           60  +      longer be supported.
    62     61       </font>
    63     62     </li>
    64     63   
    65     64     <li>
    66     65       Full SQLite schema editing inside Visual Studio.  You can create/edit tables,
    67     66       views, triggers, indexes, check constraints and foreign keys.
    68     67     </li>
................................................................................
   185    184   at the sqlite.org website.&nbsp; Several additional pieces are compiled on top of
   186    185   it to extend its functionality, but the core engine's source is not changed.</p>
   187    186   <p>
   188    187   </p>
   189    188   
   190    189   <h2><b>Version History</b></h2>
   191    190   
          191  +<p>
          192  +    <b>1.0.78.0 - January XX, 2012</b>
          193  +</p>
          194  +<ul>
          195  +    <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li>
          196  +    <li>Redesign the VS designer support installer and integrate it into the setup packages.</li>
          197  +    <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li>
          198  +    <li>Even more enhancements to the build and test automation.</li>
          199  +    <li>Support parameter binding to more primitive types, including unsigned integer types.</li>
          200  +    <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li>
          201  +    <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li>
          202  +    <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li>
          203  +    <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5].&nbsp;<b>** Potentially Incompatible Change **</b></li>
          204  +</ul>
   192    205   <p>
   193    206       <b>1.0.77.0 - November 28, 2011</b>
   194    207   </p>
   195    208   <ul>
   196    209       <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li>
   197    210       <li>More enhancements to the build and test automation.</li>
   198    211       <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li>
................................................................................
   202    215       <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>
   203    216       <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li>
   204    217       <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].</li>
   205    218       <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 [7e3fa93744].</li>
   206    219       <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 [343d392b51].</li>
   207    220       <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li>
   208    221       <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li>
   209         -    <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].</li>
          222  +    <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].&nbsp;<b>** Potentially Incompatible Change **</b></li>
   210    223       <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li>
   211    224       <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 [737ca4ff74].</li>
   212    225       <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].</li>
   213    226       <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].</li>
   214    227   </ul>
   215    228   <p>
   216    229       <b>1.0.76.0 - October 4, 2011</b>

Changes to www/news.wiki.

     1      1   <title>News</title>
     2      2   
     3      3   <b>Version History</b>
     4      4   
            5  +<p>
            6  +    <b>1.0.78.0 - January XX, 2012 <font color="red">(release pending)</font></b>
            7  +</p>
            8  +<ul>
            9  +    <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li>
           10  +    <li>Redesign the VS designer support installer and integrate it into the setup packages.</li>
           11  +    <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li>
           12  +    <li>Even more enhancements to the build and test automation.</li>
           13  +    <li>Support parameter binding to more primitive types, including unsigned integer types.</li>
           14  +    <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li>
           15  +    <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li>
           16  +    <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li>
           17  +    <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5].&nbsp;<b>** Potentially Incompatible Change **</b></li>
           18  +</ul>
     5     19   <p>
     6     20       <b>1.0.77.0 - November 28, 2011</b>
     7     21   </p>
     8     22   <ul>
     9     23       <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li>
    10     24       <li>More enhancements to the build and test automation.</li>
    11     25       <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li>
................................................................................
    15     29       <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>
    16     30       <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li>
    17     31       <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].</li>
    18     32       <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 [7e3fa93744].</li>
    19     33       <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 [343d392b51].</li>
    20     34       <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li>
    21     35       <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li>
    22         -    <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].</li>
           36  +    <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    23     37       <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li>
    24     38       <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 [737ca4ff74].</li>
    25     39       <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].</li>
    26     40       <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].</li>
    27     41   </ul>
    28     42   <p>
    29     43       <b>1.0.76.0 - October 4, 2011</b>