Index: www/features.wiki
==================================================================
--- www/features.wiki
+++ www/features.wiki
@@ -1,95 +1,116 @@
Features
+Features
+
-
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.
+
-
Supports the Full
and Compact .NET Framework, and native C/C++ development. 100% binary
compatible with the original sqlite3.dll.
Compact framework not currently not included.
We hope to have this feature included again soon.
+
-
Full support for Mono via a "managed only" provider that runs against the
official SQLite 3.6.1 or higher library.
+
- Full Entity Framework support (ADO.NET 3.5 SP1)
+
-
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.
+
-
Encrypted database support. Encrypted databases are fully encrypted and
support both binary and cleartext password types.
+
-
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.
Currently not included. We are still updating the Design-Time
support installer.
+
-
Full SQLite schema editing inside Visual Studio.
You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
+
-
Single file redistributable (except on Compact Framework).
The core sqlite3 codebase and the ADO.NET wrapper
are combined into one multi-module assembly.
Currently all versions provided as System.Data.SQLite.dll and SQLite.Interop.dll.
This provides consistency across all packages, including Compact and Mono.
+
-
Binaries included for Itanium, x64, x86 and ARM processors.
Currently only x64 and x86 included.
- We hope to have more processorts included again soon.
+ We hope to have more processors included again soon.
+
-
DbProviderFactory support.
+
-
Full support for ATTACH'ed databases. Exposed as Catalogs
in the schema. When cloning a connection, all attached databases are
automatically re-attached to the new connection.
+
-
DbConnection.GetSchema(...) support includes ReservedWords, MetaDataCollections, DataSourceInformation,
DataTypes, Columns, Tables, Views, ViewColumns, Catalogs,
Indexes, IndexColumns, ForeignKeys and Triggers.
+
-
Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace
and detailed schema information even for complex queries.
+
-
Named and unnamed parameters.
+
-
Full UTF-8 and UTF-16 support, each with optimized pipelines into the native
database core.
+
-
Multiple simultaneous DataReaders (one DataReader per Command however).
+
-
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.
+
-
Full support for user-defined collating sequences, every bit as simple to
implement as user-defined functions and uses the same base class.
+
-
Full source for the entire engine and wrapper. No copyrights.
Public Domain. 100% free for commercial and non-commercial use.