The ADO.NET 2.0 Provider for SQLite
Here is a brief overview of the major features of
the ADO.NET provider for SQLite:
Complete ADO.NET 2.0 Implementation
The provider was written from scratch on VS2005 specifically for ADO.NET 2.0,
using all the new changes in the ADO.NET framework. That includes full
DbProviderFactory support, automatic distributed transaction enlistment, extensive schema support, and all the classes
inherit from the ADO.NET 2.0 base classes.
Supports the Full and Compact .NET
Framework as well as native C/C++
The library is 100% binary compatible with the original sqlite3.dll for full
unmanaged C/C++ development.
Completely portable database files
Unencrypted SQLite databases can be freely shared across all platforms and CPU types, including non-Windows platforms. Encrypted databases can be shared across all Windows platforms and processors.
Incredibly fast, faster than most every other embedded database, including 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.
Fully encrypted databases
The entire database file can be encrypted. Binary and cleartext passwords
are supported.
Visual Studio 2005 Design-Time Support
You can add a SQLite connection to the Server Explorer, create queries with the
query designer, drag-and-drop tables onto a Typed DataSet and more! SQLite's designer works on all editions of Visual Studio 2005, including all Express Editions.
Single file redistributable under 400kb
The native SQLite library and the ADO.NET wrapper are combined into one
multi-module assembly. Precompiled binaries are available for x86, IA64,
x64 and ARM processors.
Extensive SQL support
SQLite implements most of the SQL92 standard (see below). Supports named
and unnamed parameters along with full UTF-8 and UTF-16 support each with
optimized pipelines into the SQLite core.
User-Defined Functions & Collating
Sequences
Full support for user-defined functions and collating sequences means that in
many cases if SQLite doesn't have a feature, you can write it yourself in your
favorite .NET language. Writing UDF's and collating sequences has never
been easier.
Full Source Included. 100% Free.
The full source to the wrapper and SQLite engine is in the public
domain. There are zero licensing restrictions for private or
commercial use.
SQLite is a small C library that
implements a self-contained, embeddable, zero-configuration SQL database
engine. Features include:
-
Transactions are atomic, consistent, isolated, and durable (ACID) even after
system crashes and power failures.
-
Zero-configuration - no setup or administration needed.
-
Implements most of SQL92. (Features
not supported)
-
A complete database is stored in a single disk file.
-
Database files can be freely shared between machines with different byte
orders.
-
Supports databases up to 2 terabytes (241
bytes) in size.
-
Sizes of strings and BLOBs limited only by available memory.
-
Small code footprint: less than 30K lines of C code, less than 250KB code space
(gcc on i486)
-
Faster
than popular client/server database engines for most common operations.
-
Simple, easy to use API.
-
TCL bindings included.
Bindings for many other languages
available separately.
-
Well-commented source code with over 95% test coverage.
-
Self-contained: no external dependencies.
-
Sources are in the public domain.
Use for any purpose.
|