Monday, September 22, 2008

SQLite for ADO.Net 1.0.59.0 Released

ADO.NET 2.0 Provider for SQLite - 1.0.59.0

“Code merge with SQLite 3.6.3. Solves a couple different EF issues that were either giving inconsistent results or crashing the engine. Fixed the parsing of literal binaries in the EF SqlGen code. SQLite now passes nearly all the testcases in Microsoft's EF Query Samples application -- the exception being the datetimeoffset and time constants tests, and tests that use the APPLY keyword which are unsupported for now. Revamped the Compact Framework mixed-mode assembly. Tired of playing cat and mouse with the Compact Framework's support for mixed-mode assemblies. The CF build now requires that you distribute both the System.Data.SQLite library and the paired SQLite.Interop.XXX library. The XXX denotes the build number of the library. Implemented a workaround for Vista's overzealous caching by turning off FILE_FLAG_RANDOM_ACCESS for OS versions above XP. This is implemented as a custom (default override) VFS in the interop.c file, so no changes are made to the SQLite source code. Fixed some registry issues in the designer install.exe, which prevented some design-time stuff from working on the Compact Framework when .NET 3.5 was installed.

…”

System.Data.SQLite (An open source ADO.NET provider for the SQLite database engine)

System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0 provider all rolled into a single mixed mode assembly.  It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll).  Unlike normal mixed assemblies, it has no linker dependency on the .NET runtime so it can be distributed independently of .NET.

Here is a brief overview of its features:

Complete ADO.NET 2.0 Implementation
The provider was written from scratch on VS2005/2008 specifically for ADO.NET 2.0, using all the most recent changes to the ADO.NET framework.  That includes full DbProviderFactory support, automatic distributed transaction enlistment, connection pooling, extensive schema support, Entity Framework support and more.

Supports the Full and Compact .NET Framework as well as native C/C++
Whether you're programming in .NET or straight C/C++ on the desktop or a mobile device, we've got a build for you.

Mono support
A managed-only version of the provider is also available that works on Mono against the official SQLite library from http://www.sqlite.org/.  Requires 3.6.1 or higher.

Support for the ADO.NET 3.5 Entity Framework
SQLite's EF provider is still in beta for now, but go ahead and kick the tires!

…”

Google’s Chrome using SQLite has reignited my interest in this project making this ADO.Net provider for SQLite seem like a no-brainer place for me to start…

This is now a pretty active project, with releases coming quite often, so if you are interested, subscribe to the SourceForge release feed to keep up.

 

Related Past Post XRef:
Your Three Minute Guide to SQLite and .Net

No comments: