System.Data.SQLite

<title>Features</title>

<ul>
  <li>
    Written from scratch on VS2008 specifically for ADO.NET 2.0, implementing all the
    base classes and features recently introduced in the framework, including automatic
    transaction enlistment.
  </li>
  <li>
    Supports the Full
    and Compact .NET Framework, and native C/C++ development.  100% binary
    compatible with the original sqlite3.dll.
  </li>
  <li>
    Full support for Mono via a &quot;managed only&quot; provider that runs against the
    official SQLite 3.6.1 or higher library.
  </li>
  <li>Full Entity Framework support (ADO.NET 3.5 SP1)</li>
  <li>
    On the Compact Framework, it is faster than SQL Server
    Mobile.  SQLite's installed size is a fraction of SQL Mobile's. It uses less memory at runtime, runs queries faster,
    and has a smaller database file size as well.
  </li>
  <li>
    Encrypted database support.  Encrypted databases are fully encrypted and
    support both binary and cleartext password types.
  </li>
  <li>
    Visual Studio 2005/2008 Design-Time Support, works with all versions of VS2005/2008,
    including all Express Editions of VS2005.  You can add a SQLite
    database to the Servers list, design queries with the Query Designer,
    drag-and-drop tables onto a Typed DataSet, etc.
  </li>
  <li>
    Full SQLite schema editing inside Visual Studio.
    You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
  </li>
  <li>
    Single file redistributable (except on Compact Framework).  The core sqlite3 codebase and the ADO.NET wrapper
    are combined into one multi-module assembly.
  </li>
  <li>
    Binaries included for Itanium, x64, x86 and ARM processors.
  </li>
  <li>
    DbProviderFactory support.
  </li>
  <li>
    Full support for ATTACH'ed databases.  Exposed as <i>Catalogs</i>
    in the schema.  When cloning a connection, all attached databases are
    automatically re-attached to the new connection.
  </li>
  <li>
    DbConnection.GetSchema(...) support includes <i>ReservedWords</i>, <i>MetaDataCollections</i>, <i>DataSourceInformation</i>,
    <i>DataTypes</i>, <i>Columns</i>, <i>Tables</i>, <i>Views</i>, <i>ViewColumns</i>, <i>Catalogs</i>, 
      <i>Indexes</i>, <i>IndexColumns</i>, <i>ForeignKeys</i> and <i>Triggers</i>.
  </li>
  <li>
    Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace
    and detailed schema information even for complex queries.
  </li>
  <li>
    Named and unnamed parameters.
  </li>
  <li>
    Full UTF-8 and UTF-16 support, each with optimized pipelines into the native
    database core.
  </li>
  <li>
    Multiple simultaneous DataReaders (one DataReader per Command however).
  </li>
  <li>
    Full support for user-defined scalar and aggregate functions, encapsulated into
    an easy-to-use base class in which only a couple of overrides are necessary to
    implement new SQL functions.
  </li>
  <li>
    Full support for user-defined collating sequences, every bit as simple to
    implement as user-defined functions and uses the same base class.
  </li>
  <li>
    Full source for the entire engine and wrapper.  No copyrights.
    Public Domain.  100% free for commercial and non-commercial use.
  </li>
</ul>

<title>About</title>

<div style="float:right">
  *  [./features.wiki | Features]
  *  [./news.wiki | News]
  *  [./support.wiki | Support]
  *  [./release.wiki | Release Procedures]
</div>

<p>This is a fork of the popular ADO.NET 4.0 adaptor for <a href="http://www.sqlite.org">SQLite</a> known 
as System.Data.SQLite. The originator of System.Data.SQLite, <a href="mailto:robert@blackcastlesoft.com">Robert Simpson</a>, 
is aware of this fork, has expressed his approval, and has commit privileges on the new Fossil repository. 
The SQLite development team intends to maintain System.Data.SQLite moving forward. </p>

<p>Historical versions, as well as the original support forums, may still be found
at <a href="http://sqlite.phxsoftware.com">http://sqlite.phxsoftware.com</a>, though
there have been no updates to this version since April of 2010.</p>

<title>News</title>

<b>Version History</b>

<p>
  <b>1.0.68.0 - February 2011</b>
</p>
<ul>
  <li>Code merge with 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 SQLite 3.7.4</li>
  <li>Continuing work on supporting Visual Studio 2010</li>
</ul>

<title>Release Procedures</title>

<p>Follow these steps to build a new release of SQLite.NET.  Unless otherwise noted, all steps need to be done in the order specified.</p>

<p>You will need a Visual Studio 2010 development environment for this build.</p>

<ol type="A">

  <li><b>Build runtime components</b>

  <ol type="1">

    <li>Build SQLite.NET.sln for Release/ia64

    <li>Change to Release/x64 and rebuild

    <li>Change to Release/x86 and rebuild

  </ol>

  <li><b>Build designer components</b>

  <ol type="1">

    <li>Build SQLite.Designer.sln for Release

  </ol>

  <li><b>Update documentation</b>

  <ol type="1">

    <li>Update the readme.htm file with the latest version changes

    <li>Copy the version changes from readme.htm into doc\extra\version.html

    <li>Update doc\extra\dbfactorysupport.html to reflect the latest version # of the DLL

    <li>Copy over doc\extra\dbfactorysupport.html and version.html to my temp
    ndoc2 location where all my intermediate files are for the CHM

    <li>Run HTML Help Workshop on the HHP project to get my CHM

    <li>Copy the CHM file over to \doc

  </ol>

  <li><b>Build install and setup packages</b>

  <ol type="1">

    <li>Load up the \tools\setup\sqlite_setup.sln solution

    <li>Change the "Version" property of the sqlite project (this is the MSI
    file project) to reflect the new version of the release.

    <li>Edit the setup.rc file of the setup project, drilling down to the
    Version resource, and editing VS_VERSION_INFO, and populating the version
    info with the newest version #.

    <li>Build both projects.

    <li>Copy the and rename the resulting \tools\setup\release\setup.exe to
    SQLite-1.0.xx.0-setup.exe

  </ol>

</ol>

<title>Support</title>

<h3>Mailing Lists</h3>

<p>SQLite has an active mailing list and support community, and users of this version of
System.Data.SQLite are encouraged to use these for support questions.</p>

<p>Three separate mailing lists have been established to help support
SQLite:</p>

<ul>
<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
sqlite-announce</a> - announcements of new releases or significant developments.</li>
<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
sqlite-users</a> - general user discussion; most postings belong here.</li>
<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
sqlite-dev</a> - developer conversations; for people who have or aspire to
have write permission on the SQLite source code repository.</li>
</ul>

<p>
Most users of SQLite will want to join the
<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
sqlite-announce</a> list and many will want to join the
<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
sqlite-users</a> list.  The
<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
sqlite-dev</a> list is more specialized and appeals to a narrower audience.
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="http://www.mail-archive.com/sqlite-users%40sqlite.org/">http://www.mail-archive.com/sqlite-users%40sqlite.org/</a><br>
<li><a href="http://marc.info/?l">http://marc.info/?l=sqlite-users&r=1&w=2</a><br>
<li><a href="http://news.gmane.org/gmane.comp.db.sqlite.general">http://news.gmane.org/gmane.comp.db.sqlite.general</a>
</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 href="http://www.sqlite.org/draft/support.html">professional support contract</a>
<li>You are working on an open source project.
</ul>

<p>You are welcomed to use SQLite in closed source, proprietary, and/or commercial projects and to 
ask questions about such use on the public mailing list. But please do not ask to receive free direct 
technical support. The software is free; direct technical support is not.</p>


              <h1>Documentation</h1>

  *  [./release.wiki | Release Procedures]