System.Data.SQLite
Check-in [1f6d89bf5d]
Not logged in

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

Overview
Comment:Final doc updates for release 1.0.78.0.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 1f6d89bf5db6111e5b15ac035b089049eb0219bb
User & Date: mistachkin 2012-01-27 10:13:44
Context
2012-01-27
10:46
Add missing step to updating the downloads page in the release procedures. check-in: e9bc8771cb user: mistachkin tags: trunk
10:13
Final doc updates for release 1.0.78.0. check-in: 1f6d89bf5d user: mistachkin tags: trunk
09:45
Exclude the *.done task completion marker files from the released ZIP files. check-in: 3af389434a user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/designer.html.

    46     46         <h1 class="heading">Installing SQLite Visual Studio Design-Time Support</h1>
    47     47         <p>Supporting the Visual Studio query designer and allowing you to manipulate 
    48     48           SQLite databases from within Visual Studio is a great time-saver.&nbsp; Though 
    49     49           the support is not yet fully-implemented, there's certainly enough there to 
    50     50           keep you busy.&nbsp; You can create databases, design and execute queries, 
    51     51           create typed datasets and lots more all from Visual Studio.</p>
    52     52         <h3> Installation Instructions</h3>
    53         -      <p>
    54         -        In Windows Explorer, navigate to <STRONG>SQLite.Net\bin\Designer</STRONG>
    55         -        and execute the <STRONG>INSTALL.EXE</STRONG> program.&nbsp; It will automatically
    56         -        detect what eligible Visual Studio products are installed, and allow you to check
    57         -        and uncheck which environments to install the designer for.</p>
           53  +      <p>Download and run one of the setup packages and then select the &quot;<b>Install
           54  +        the designer components for Visual Studio 20XX.</b>&quot; option when prompted.</p>
    58     55         <h3> Express Edition Limitations</h3>
    59         -      <p>All Express Editions (except Visual Web Developer) are hard-coded to only allow you to design for Jet and Sql Server Database Files.&nbsp; The only way for SQLite
    60         -        to install its designer is to temporarily replace one of the existing "approved"
    61         -        designers.&nbsp; Therefore, when you install the SQLite designer for one of these
    62         -        express editions, it will temporarily replace the Microsoft Access designer.&nbsp;
    63         -        You can revert back to the Access designer simply by re-running the install.exe
    64         -        program and un-checking the boxes.</p>
           56  +      <p>Visual Studio design-time Support, works with all versions of Visual Studio
           57  +        2005/2008/2010.  You can add a SQLite database to the Servers list, design
           58  +        queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc.
           59  +        <br />
           60  +        <font color="red">
           61  +          Due to Visual Studio licensing restrictions, the Express Editions can no
           62  +          longer be supported.
           63  +        </font>
           64  +      </p>
    65     65         <hr/>
    66     66         <div id="footer">
    67     67           <p>
    68     68             <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Designer%20Support">
    69     69               Send comments on this topic.</a>
    70     70           </p>
    71     71           <p>
    72     72           </p>
    73     73         </div>
    74     74       </div>
    75     75       </div>
    76     76     </body>
    77     77   </html>

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>
           46  +    <p><b>1.0.78.0 - January 27, 2012</b></p>
    47     47       <ul>
    48     48         <li>Updated to <a href="http://www.sqlite.org/releaselog/3_7_10.html">SQLite 3.7.10</a>.</li>
    49     49         <li>Redesign the VS designer support installer and integrate it into the setup packages.</li>
    50     50         <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="http://system.data.sqlite.org/index.html/info/b226147b37">[b226147b37]</a>.</li>
    51     51         <li>Add Flags connection string property to control extra behavioral flags for the connection.</li>
    52     52         <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li>
    53     53         <li>Even more enhancements to the build and test automation.</li>

Changes to Doc/Extra/welcome.html.

    73     73             engine (compared to other providers and engines)</a></p>
    74     74         <br>
    75     75         <h1 class="heading">SQLite.NET Provider Features</h1>
    76     76         <p>This SQLite provider implements every feature of the underlying SQLite 
    77     77           database engine without omission. Here's a brief summary:</p>
    78     78         <UL>
    79     79           <LI>
    80         -        Written from scratch on VS2005/2008 specifically for ADO.NET, implenting all the
           80  +        Written from scratch on Visual Studio 2008 specifically for ADO.NET, implenting all the
    81     81           base classes and features recently introduced in the framework, including automatic
    82     82           transaction enlistment.<li>Supports the Full and Compact .NET Framework, as well as
    83     83             native C/C++ development.&nbsp; 100% binary compatible with the original sqlite3.dll.</li>
    84     84           <li>Full support for Mono via a &quot;managed only&quot; provider that runs against the 
    85     85             official SQLite 3.6.1 or higher library.</li>
    86     86           <li>Full Entity Framework support (ADO.NET 3.5 SP1)</li>
    87     87           <li>
    88     88           On the Compact Framework, it is faster than Sql Server Mobile.
    89     89             SQLite's installed size is a fraction of Sql Mobile's. It uses less memory at runtime,
    90     90             runs queries faster, and has a smaller database file size as well. </li>
    91     91           <li>Encrypted database support.&nbsp; Encrypted databases are fully encrypted and
    92     92             support both binary and cleartext password types. </li>
    93         -        <li>Visual Studio 2005/2008 Design-Time Support.&nbsp; You can add a SQLite 
           93  +        <li>Visual Studio 2005/2008/2010 Design-Time Support.&nbsp; You can add a SQLite 
    94     94           database to the Servers list, design queries with the Query Designer, 
    95     95           drag-and-drop tables onto a Typed DataSet, etc.</li>
    96     96               <li>Full SQLite schema editing inside Visual Studio.&nbsp; You can create/edit 
    97     97                 tables, views, triggers, indexes, check constraints and foreign keys. </li>
    98     98           <li>
    99         -        Single file redistributable (except Compact Framework).&nbsp; The core sqlite3 codebase and the ADO.NET wrapper 
           99  +        Available as a single file redistributable (except Compact Framework).&nbsp; The core sqlite3 codebase and the ADO.NET wrapper 
   100    100           are combined into one multi-module assembly. </li>
   101         -        <li>Binaries included for Itanium, x64, x86 and ARM processors. </li>
          101  +        <li>Also available as separate native and managed assemblies and optionally with the Visual C++ Runtime statically linked. </li>
          102  +        <li>
          103  +          Binaries included for Itanium, x64, x86 and ARM processors.
          104  +          <br />
          105  +          <font color="red">
          106  +            Itanium processor support not currently included.
          107  +          </font>
          108  +        </li>
   102    109           <li>
   103    110           DbProviderFactory support. </li>
   104    111           <li>
   105    112             Full support for ATTACH'ed databases.&nbsp; Exposed as <i>Catalogs</i>
   106    113           in the schema.&nbsp; When cloning a connection, all attached databases are 
   107    114           automatically re-attached to the new connection. </li>
   108    115           <li>
................................................................................
   130    137           implement as user-defined functions and uses the same base class. </li>
   131    138           <li>
   132    139             Full source for the entire engine and wrapper.&nbsp; No copyrights.&nbsp; 
   133    140             Public Domain.&nbsp; 100% free for commercial and non-commercial use.&nbsp;</li>
   134    141         </UL>
   135    142         <br>
   136    143         <h1 class="heading">Distributing the Binaries (Desktop)</h1>
   137         -      <p><b>System.Data.SQLite.DLL</b> is a mixed assembly signed with a strong name 
   138         -        in case you want to add it to the Global Assembly Cache (GAC). This is the only DLL required to be redistributed with 
   139         -        your SQLite.NET application(s).&nbsp; It 
   140         -        comes in&nbsp;3
   141         -        flavors: Win32, Itanium and x64 (AMD64).</p>
          144  +      <p>When using the mixed-mode assembly, the <b>System.Data.SQLite.DLL</b> file
          145  +        includes all the native and managed code. In that case, this is the only
          146  +        DLL required to be redistributed with your SQLite.NET application(s).&nbsp;
          147  +        When using separate native and managed assemblies, the
          148  +        <b>System.Data.SQLite.DLL</b> file contains all the managed code and the
          149  +        <b>SQLite.Interop.DLL</b> file contains all the native code.
          150  +        The native code comes in&nbsp;3 flavors: Win32, Itanium and x64 (AMD64).
          151  +        <br />
          152  +        <font color="red">
          153  +          Itanium processor support not currently included.
          154  +        </font>
          155  +      </p>
   142    156         <h1 class="heading">Distributing the Binaries (Compact Framework)</h1>
   143         -      <p><b>System.Data.SQLite.DLL </b>and <b>SQLite.Interop.XXX.DLL</b> must be 
   144         -        deployed on the Compact Framework.&nbsp; The XXX is the build number of the 
   145         -        System.Data.SQLite library (e.g. &quot;078&quot;).&nbsp; SQLite.Interop.XXX is a fully 
   146         -        native assembly compiled for the ARM processor, and System.Data.SQLite is the 
   147         -        fully-managed Compact Framework assembly.</p>
          157  +      <p>Both the <b>System.Data.SQLite.DLL </b>and <b>SQLite.Interop.XXX.DLL</b> files
          158  +        must be deployed on the Compact Framework.&nbsp; The XXX is the build number of
          159  +        the System.Data.SQLite library (e.g. &quot;078&quot;).&nbsp; The
          160  +        <b>SQLite.Interop.XXX.DLL</b> file is a fully native assembly compiled for
          161  +        the ARM processor, and System.Data.SQLite is the fully-managed Compact
          162  +        Framework assembly.</p>
   148    163         <hr />
   149    164         <div id="footer">
   150    165           <p>
   151    166             <a href="mailto:sqlite-users@sqlite.org?subject=SQLite.NET%20Class%20Library%20Documentation%20Feedback:%20Welcome">
   152    167             Send comments on this topic.<!--[if gte IE 5]><tool:tip element="seeAlsoToolTip" avoidmouse="false" /><tool:tip element="languageFilterToolTip" avoidmouse="false" /><![endif]-->    </div>
   153    168       </div>
   154    169     </body>
   155    170   </html>

Changes to Doc/SQLite.NET.chm.

cannot compute difference between binary files

Changes to readme.htm.

     1      1   <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
     2      2   <html>
     3      3   <head>
     4      4   <title></title>
     5      5   </head>
     6      6   <body>
     7      7   ADO.NET SQLite Data Provider<br />
     8         -Version 1.0.78.0 January XX, 2012<br />
            8  +Version 1.0.78.0 January 27, 2012<br />
     9      9   Using <a href="http://www.sqlite.org/releaselog/3_7_10.html">SQLite 3.7.10</a><br />
    10     10   Originally written by Robert Simpson<br />
    11     11   Released to the public domain, use at your own risk!<br />
    12     12   Official provider website:&nbsp;<a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br />
    13     13   Legacy versions:&nbsp;<a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br />
    14     14   <br />
    15     15   The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?y=ci">

Changes to www/features.wiki.

    35     35     <li>
    36     36       Visual Studio design-time Support, works with all versions of Visual Studio
    37     37       2005/2008/2010.  You can add a SQLite database to the Servers list, design
    38     38       queries with the Query Designer, drag-and-drop tables onto a Typed DataSet,
    39     39       etc.
    40     40       <br />
    41     41       <font color="red">
    42         -      Currently not included.  We are still updating the design-time support
    43         -      installer.  Due to Visual Studio licensing restrictions, the Express
    44         -      Editions can no longer be supported.
           42  +      Due to Visual Studio licensing restrictions, the Express Editions can no
           43  +      longer be supported.
    45     44       </font>
    46     45     </li>
    47     46   
    48     47     <li>
    49     48       Full SQLite schema editing inside Visual Studio.  You can create/edit tables,
    50     49       views, triggers, indexes, check constraints and foreign keys.
    51     50     </li>

Changes to www/news.wiki.

     1      1   <title>News</title>
     2      2   
     3      3   <b>Version History</b>
     4      4   
     5      5   <p>
     6         -    <b>1.0.78.0 - January XX, 2012 <font color="red">(release pending)</font></b>
            6  +    <b>1.0.78.0 - January 27, 2012</b>
     7      7   </p>
     8      8   <ul>
     9      9       <li>Updated to [http://www.sqlite.org/releaselog/3_7_10.html|SQLite 3.7.10]
    10     10       <li>Redesign the VS designer support installer and integrate it into the setup packages.</li>
    11     11       <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>
    12     12       <li>Add Flags connection string property to control extra behavioral flags for the connection.</li>
    13     13       <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li>