System.Data.Sqlite已于2012-12-29升级到1.0.83

System.Data.Sqlite是用于.Net Framework环境下的Sqlite数据库管理系统。

话说Sqlite成为Android操作系统的默认数据库管理系统后，其配置简单、查询速度快等各种优势也渐渐被.net framework开发者重视。开发一个轻量级数据库应用的Windows软件，使用Sql Server Experss 或者 Access 数据库实在是令我有过非常不爽甚至悲催的经历啊！反正我是铁了心决定在单机环境或者其它轻量级数据库应用环境中使用Sqlite数据库了！目前我已有两个运行于.net framwrowk环境下的软件使用了Sqlite数据库，效果非常好！至少数据库环境的”零配置“就已经让我很省心了！再说了，说不定哪天我决定把自己开发的某款Windows软件移植到Android环境下（移动开发是主流啊！什么什么？Windows 8? 呃，还是看看再说吧！），至少数据库不用再费神了吧！

System.Data.Sqlite就是这样一个提供.net framwork环境下的Sqlite 数据库管理系统的开源项目。最新的1.0.83已经可以支持Visual Stuidio 2012和.net framwork 4.5了哦！

System.Data.Sqlite 1.0.83下载地址：http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

1.0.83的新特性：

1.0.83.0 - December 29, 2012

• Updated to SQLite 3.7.15.1.
• Add Visual Studio 2012 support to all the applicable solution/project files, their associated supporting files, and the test suite.
• Add Visual Studio 2012 support to the redesigned designer support installer.
• Allow opened connections to skip adding the extension functions included in the interop assembly via the new NoExtensionFunctions connection flag.
• Support loading of SQLite extensions via the new EnableExtensions and LoadExtension methods of the SQLiteConnection class. Pursuant to [17045010df].
• Remove one set of surrounding single or double quotes from property names and values parsed from the connection string. Fix for [b4cc611998].
• Modify parsing of connection strings to allow property names and values to be quoted. ** Potentially Incompatible Change **
• Add ParseViaFramework property to the SQLiteConnection class to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Pursuant to [b4cc611998].
• Add notifications before and after any connection is opened and closed, as well as other related notifications, via the new static Changed event.
• Add an overload of the SQLiteLog.LogMessage method that takes a single string parameter.
• Add an overload of the SQLiteConnection.LogMessage method that takes a SQLiteErrorCode parameter.
• All applicable calls into the SQLite core library now return a SQLiteErrorCode instead of an integer error code.
• Make sure the error code of the SQLiteException class gets serialized.
• Make the test project for the .NET Compact Framework more flexible.
• When available, the new sqlite3_errstr function from the core library is used to get the error message for a specific return code.
• The SetMemoryStatus, Shutdown, ResultCode, ExtendedResultCode, and SetAvRetry methods of the SQLiteConnection class now return a SQLiteErrorCode instead of an integer error code. ** Potentially Incompatible Change **
• The public constructor for the SQLiteException now takes a SQLiteErrorCode instead of an integer error code. ** Potentially Incompatible Change **
• The ErrorCode property of the SQLiteException is now an Int32, to allow the property inherited from the base class to be properly overridden. ** Potentially Incompatible Change **
• The ErrorCode field of the LogEventArgs is now an object instead of an integer. ** Potentially Incompatible Change **
• The names and messages associated with the SQLiteErrorCode enumeration values have been normalized to match those in the SQLite core library. ** Potentially Incompatible Change **
• Implement more robust locking semantics for the CriticalHandle derived classes when compiled for the .NET Compact Framework.
• Cache column indexes as they are looked up when using the SQLiteDataReader to improve performance.
• Prevent the SQLiteConnection.Close method from throwing non-fatal exceptions during its disposal.
• Rename the interop assembly functions sqlite3_cursor_rowid, sqlite3_context_collcompare, sqlite3_context_collseq, sqlite3_cursor_rowid, and sqlite3_table_cursor to include an "_interop" suffix. ** Potentially Incompatible Change **
• Prevent the LastInsertRowId, MemoryUsed, and MemoryHighwater connection properties from throwing NotSupportedException when running on the .NET Compact Framework. Fix for [dd45aba387].
• Improve automatic detection of the sqlite3_close_v2 function when compiled to use the standard SQLite library.
• Add protection against ThreadAbortException asynchronously interrupting native resource initialization and finalization.
• Add native logging callback for use with the sqlite3_log function to the interop assembly, enabled via the INTEROP_LOG preprocessor definition.
• Add various diagnostic messages to the interop assembly, enabled via flags in the INTEROP_DEBUG preprocessor definition.
• Further enhancements to the build and test automation.
• Add test automation for the Windows CE binaries.