Version History
-1.0.78.0 - January XX, 2012
+1.0.78.0 - January 27, 2012
- Updated to SQLite 3.7.10.
- Redesign the VS designer support installer and integrate it into the setup packages.
- When emitting SQL for foreign keys in the VS designer, be sure to take all returned schema rows into account. Remainder of fix for [b226147b37].
- Add Flags connection string property to control extra behavioral flags for the connection. Index: Doc/Extra/welcome.html ================================================================== --- Doc/Extra/welcome.html +++ Doc/Extra/welcome.html @@ -75,11 +75,11 @@
- - Written from scratch on VS2005/2008 specifically for ADO.NET, implenting all the + Written from scratch on Visual Studio 2008 specifically for ADO.NET, 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.
- Full support for Mono via a "managed only" provider that runs against the official SQLite 3.6.1 or higher library. @@ -88,19 +88,26 @@ 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. You can add a SQLite +
- Visual Studio 2005/2008/2010 Design-Time Support. 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.
- Full SQLite schema editing inside Visual Studio. You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
- - Single file redistributable (except Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper + Available as a single file redistributable (except Compact Framework). 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. +
- Also available as separate native and managed assemblies and optionally with the Visual C++ Runtime statically linked. +
-
+ Binaries included for Itanium, x64, x86 and ARM processors.
+
+ + Itanium processor support not currently included. + + - DbProviderFactory support.
- Full support for ATTACH'ed databases. Exposed as Catalogs in the schema. When cloning a connection, all attached databases are @@ -132,24 +139,32 @@ Full source for the entire engine and wrapper. No copyrights. Public Domain. 100% free for commercial and non-commercial use.
SQLite.NET Provider Features
This SQLite provider implements every feature of the underlying SQLite database engine without omission. Here's a brief summary:
Distributing the Binaries (Desktop)
-System.Data.SQLite.DLL is a mixed assembly signed with a strong name - in case you want to add it to the Global Assembly Cache (GAC). This is the only DLL required to be redistributed with - your SQLite.NET application(s). It - comes in 3 - flavors: Win32, Itanium and x64 (AMD64).
+When using the mixed-mode assembly, the System.Data.SQLite.DLL file
+ includes all the native and managed code. In that case, this is the only
+ DLL required to be redistributed with your SQLite.NET application(s).
+ When using separate native and managed assemblies, the
+ System.Data.SQLite.DLL file contains all the managed code and the
+ SQLite.Interop.DLL file contains all the native code.
+ The native code comes in 3 flavors: Win32, Itanium and x64 (AMD64).
+
+
+ Itanium processor support not currently included.
+
+
Distributing the Binaries (Compact Framework)
-System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL must be - deployed on the Compact Framework. The XXX is the build number of the - System.Data.SQLite library (e.g. "078"). SQLite.Interop.XXX is a fully - native assembly compiled for the ARM processor, and System.Data.SQLite is the - fully-managed Compact Framework assembly.
+Both the System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL files + must be deployed on the Compact Framework. The XXX is the build number of + the System.Data.SQLite library (e.g. "078"). The + SQLite.Interop.XXX.DLL file is a fully native assembly compiled for + the ARM processor, and System.Data.SQLite is the fully-managed Compact + Framework assembly.