System.Data.SQLite

Check-in [a42ef66d86]
Login

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

Overview
Comment:Fix typo on features.wiki page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a42ef66d86d72a7649fe4be56b0a8f1dfe53388c
User & Date: shaneh 2011-04-12 17:07:42.944
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
Unified Diff Ignore Whitespace Patch
Changes to www/features.wiki.
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
<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.<br>
    <font color="red">Compact framework not currently not included.  
    We hope to have this feature included again soon.</font>
  </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.<br>
    <font color="red">Currently not included.  We are still updating the Design-Time
    support installer.</font>
  </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.<br>
    <font color="red">Currently all versions provided as System.Data.SQLite.dll and SQLite.Interop.dll.
    This provides consistency across all packages, including Compact and Mono.</font>
  </li>

  <li>
    Binaries included for Itanium, x64, x86 and ARM processors.<br>
    <font color="red">Currently only x64 and x86 included.  
    We hope to have more processorts included again soon.</font>
  </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>


>
>






>







>




>

>






>




>








>




>







>



|

>



>





>





>




>



>




>



>





>




>





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>Features</title>

<h2>Features</h2>

<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.<br>
    <font color="red">Compact framework not currently not included.  
    We hope to have this feature included again soon.</font>
  </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.<br>
    <font color="red">Currently not included.  We are still updating the Design-Time
    support installer.</font>
  </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.<br>
    <font color="red">Currently all versions provided as System.Data.SQLite.dll and SQLite.Interop.dll.
    This provides consistency across all packages, including Compact and Mono.</font>
  </li>

  <li>
    Binaries included for Itanium, x64, x86 and ARM processors.<br>
    <font color="red">Currently only x64 and x86 included.  
    We hope to have more processors included again soon.</font>
  </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>