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: |
a42ef66d86d72a7649fe4be56b0a8f1d |
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
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 | <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 "managed only" 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. | > > > > > > > > > > > | > > > > > > > > > > | 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 "managed only" 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> |