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

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

Overview
Comment:Fix typo on features.wiki page.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a42ef66d86d72a7649fe4be56b0a8f1dfe53388c
User & Date: shaneh 2011-04-12 17:07:42
Context
2011-04-12
17:14
Add matching workaround for VS 2010. check-in: da4c823012 user: mistachkin tags: trunk
17:07
Fix typo on features.wiki page. check-in: a42ef66d86 user: shaneh tags: trunk
16:54
Updates to supported features. check-in: 75741af49d user: shaneh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/features.wiki.

     1      1   <title>Features</title>
     2      2   
            3  +<h2>Features</h2>
            4  +
     3      5   <ul>
     4      6     <li>
     5      7       Written from scratch on VS2008 specifically for ADO.NET 2.0, implementing all the
     6      8       base classes and features recently introduced in the framework, including automatic
     7      9       transaction enlistment.
     8     10     </li>
           11  +
     9     12     <li>
    10     13       Supports the Full
    11     14       and Compact .NET Framework, and native C/C++ development.  100% binary
    12     15       compatible with the original sqlite3.dll.<br>
    13     16       <font color="red">Compact framework not currently not included.  
    14     17       We hope to have this feature included again soon.</font>
    15     18     </li>
           19  +
    16     20     <li>
    17     21       Full support for Mono via a &quot;managed only&quot; provider that runs against the
    18     22       official SQLite 3.6.1 or higher library.
    19     23     </li>
           24  +
    20     25     <li>Full Entity Framework support (ADO.NET 3.5 SP1)</li>
           26  +
    21     27     <li>
    22     28       On the Compact Framework, it is faster than SQL Server
    23     29       Mobile.  SQLite's installed size is a fraction of SQL Mobile's. 
    24     30       It uses less memory at runtime, runs queries faster,
    25     31       and has a smaller database file size as well.
    26     32     </li>
           33  +
    27     34     <li>
    28     35       Encrypted database support.  Encrypted databases are fully encrypted and
    29     36       support both binary and cleartext password types.
    30     37     </li>
           38  +
    31     39     <li>
    32     40       Visual Studio 2005/2008 Design-Time Support, works with all versions of VS2005/2008,
    33     41       including all Express Editions of VS2005.  You can add a SQLite
    34     42       database to the Servers list, design queries with the Query Designer,
    35     43       drag-and-drop tables onto a Typed DataSet, etc.<br>
    36     44       <font color="red">Currently not included.  We are still updating the Design-Time
    37     45       support installer.</font>
    38     46     </li>
           47  +
    39     48     <li>
    40     49       Full SQLite schema editing inside Visual Studio.
    41     50       You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
    42     51     </li>
           52  +
    43     53     <li>
    44     54       Single file redistributable (except on Compact Framework).  
    45     55       The core sqlite3 codebase and the ADO.NET wrapper
    46     56       are combined into one multi-module assembly.<br>
    47     57       <font color="red">Currently all versions provided as System.Data.SQLite.dll and SQLite.Interop.dll.
    48     58       This provides consistency across all packages, including Compact and Mono.</font>
    49     59     </li>
           60  +
    50     61     <li>
    51     62       Binaries included for Itanium, x64, x86 and ARM processors.<br>
    52     63       <font color="red">Currently only x64 and x86 included.  
    53         -    We hope to have more processorts included again soon.</font>
           64  +    We hope to have more processors included again soon.</font>
    54     65     </li>
           66  +
    55     67     <li>
    56     68       DbProviderFactory support.
    57     69     </li>
           70  +
    58     71     <li>
    59     72       Full support for ATTACH'ed databases.  Exposed as <i>Catalogs</i>
    60     73       in the schema.  When cloning a connection, all attached databases are
    61     74       automatically re-attached to the new connection.
    62     75     </li>
           76  +
    63     77     <li>
    64     78       DbConnection.GetSchema(...) support includes <i>ReservedWords</i>, <i>MetaDataCollections</i>, <i>DataSourceInformation</i>,
    65     79       <i>DataTypes</i>, <i>Columns</i>, <i>Tables</i>, <i>Views</i>, <i>ViewColumns</i>, <i>Catalogs</i>, 
    66     80         <i>Indexes</i>, <i>IndexColumns</i>, <i>ForeignKeys</i> and <i>Triggers</i>.
    67     81     </li>
           82  +
    68     83     <li>
    69     84       Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace
    70     85       and detailed schema information even for complex queries.
    71     86     </li>
           87  +
    72     88     <li>
    73     89       Named and unnamed parameters.
    74     90     </li>
           91  +
    75     92     <li>
    76     93       Full UTF-8 and UTF-16 support, each with optimized pipelines into the native
    77     94       database core.
    78     95     </li>
           96  +
    79     97     <li>
    80     98       Multiple simultaneous DataReaders (one DataReader per Command however).
    81     99     </li>
          100  +
    82    101     <li>
    83    102       Full support for user-defined scalar and aggregate functions, encapsulated into
    84    103       an easy-to-use base class in which only a couple of overrides are necessary to
    85    104       implement new SQL functions.
    86    105     </li>
          106  +
    87    107     <li>
    88    108       Full support for user-defined collating sequences, every bit as simple to
    89    109       implement as user-defined functions and uses the same base class.
    90    110     </li>
          111  +
    91    112     <li>
    92    113       Full source for the entire engine and wrapper.  No copyrights.
    93    114       Public Domain.  100% free for commercial and non-commercial use.
    94    115     </li>
    95    116   </ul>