http://sqlite.phxsoftware.com

Features:

Written from scratch on VS2005 specifically for ADO.NET 2.0, implenting all
the base classes and features recently introduced in the framework,
including automatic transaction enlistment.

Supports the Full and Compact .NET Framework, as well as native C/C++
development.  100% binary compatible with the original sqlite3.dll.

Faster than Sql Mobile, has less than half the memory footprint too.

Databases are 100% portable and are fully-contained.  Completely portable
across platforms, so just copy the file from the desktop to the Pocket PC to
deploy it.

Encrypted database support.  Encrypted databases are fully encrypted (data
and schema) and support both binary and cleartext password types.


Extensive schema support.  DbConnection.GetSchema(...) support includes the
MetaDataCollections, DataSourceInformation, Columns, Tables, Views,
ViewColumns, Catalogs, Indexes, IndexColumns and ForeignKeys keywords.

Visual Studio 2005 Design-Time Support, works with all versions of VS2005,
including all Express Editions.  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.

Single file redistributable.  The core sqlite3 codebase and the ADO.NET
wrapper are combined into one multi-module assembly.

Binaries included for Itanium, x64, x86 and ARM processors.

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.

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.

How to read OleDbSchemaGuid tables 1 record at a time ?
database connection
Can't seem to speed up Rows.Add in DataTable
Your kidding me right?
Read Word docs from Image (BLOB) Column in SQL Server