System. Data. SQLite (SQLite ADO. NET 2.0 provider, which already contains the SQLite engine)

Today, when studying other technologies, I checked the latest implementations of SQLite in. net. We found such a good thing. The home page is translated as follows:

System. Data. SQLite
Is an originalSQLiteEnhanced version.It will be an original versionSqlite3.dllCompletely alternative(You can even rename itSqlite3.dll ).It does not need to be linked. NetRun, so it can be detached from. NetIndependent release,However, it is embedded with a completeAdo. NET 2.0Engine, providing complete support for development.

The following is a brief introduction to its features.:

CompleteAdo. NET 2.0Implementation
The entire project is completely based onVs2005AndAdo. NET 2.0New build,AllAdo. NET FrameworkNew Features.Including the completeDbproviderfactorySupported,Automatic Distributed Transaction calling,Extensive mode support,In addition, all classes are fromAdo. NET 2.0The base class.

Complete and streamlined support. NET FrameworkAndC/C ++
This library does not need link Dependencies. NetRuntime,100%Compatible with originalSqlite3.dll, You can use an unmanagedC/C ++Development.

Portable database files
UnencryptedSQLiteDatabase files can be used freely across platforms and processors, including non-WindowsPlatform.The encrypted database can be stored in allWindowsUse on the platform.

Reliable speed, includingSQL Server mobileMost other embedded databases, including
SQLite'RelativeSQL mobileNegligible.It consumes less memory during running and generates a smaller database..

Database Encryption
You can encrypt the entire database file..Supports binary and plaintext passwords.

SupportedVisual Studio 2005Design
You canServer ExplorerAddSQLiteConnection,Use the query designer to create a query statement,Drag a table to a dataset! SQLiteDevelopers canVisual Studio 2005Next work.

The capacity of a single file re-deployment package is400kbBelow
SetSQLiteItself andAdo. netEncapsulate and bundle together.Pre-compiled binary files provideX86, IA64, x64AndArmVersion.

ExtensiveSQLLanguage Support
SQLiteSupports mostSql92Standard(See below ).You can useUTF-8AndUTF-16Encoding passed through the optimized PipelineSQLiteKernel.

User-Defined Functions and sorting
Fully supports user-defined functions and sorting methods, which means you can use your favorite. NetLanguage implementationSQLiteFeatures not provided.It would be very simple..

Provides allSource code. 100%Free.
All encapsulated database sourcesCodeAll are public.Neither individual nor commercial applications have any protocol constraints..

Home: http://sqlite.phxsoftware.com/

(Latest Version 1.0.38.0): http://sourceforge.net/project/showfiles.php? Group_id = 132486 & package_id = 145568

This providesProgramMore importantly, it provides support for ADO. Net vnext: http://sqlite.phxsoftware.com/blogs/sqlite/archive/2006/09/06/1949.aspx