Version History
+1.0.78.0 - January XX, 2012
+-
+
- Updated to SQLite 3.7.10 [ebd01a8def]. +
- Redesign the VS designer support installer and integrate it into the setup packages. +
- Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances. +
- Even more enhancements to the build and test automation. +
- Support parameter binding to more primitive types, including unsigned integer types. +
- Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457]. +
- Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be]. +
- Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066]. +
- Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. ** Potentially Incompatible Change ** +
1.0.77.0 - November 28, 2011
- Updated to SQLite 3.7.9 [a499ae3835].
- More enhancements to the build and test automation.
- Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason. @@ -56,11 +68,11 @@
- Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].
- When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for [7e3fa93744].
- When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for [343d392b51].
- Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.
- Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite. -
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. +
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. ** Potentially Incompatible Change **
- Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.
- Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for [737ca4ff74].
- Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].
- Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].
-Version 1.0.77.0 November 28, 2011
-Using SQLite 3.7.9 [c7c6050ef0]
+Version 1.0.78.0 January XX, 2012
+Using SQLite 3.7.10 [ebd01a8def]
Originally written by Robert Simpson
Released to the public domain, use at your own risk!
-Official provider website: http://system.data.sqlite.org/
-Legacy versions: http://sqlite.phxsoftware.com/
+Official provider website: http://system.data.sqlite.org/
+Legacy versions: http://sqlite.phxsoftware.com/
-The current development version can be downloaded from -http://system.data.sqlite.org/index.html/timeline?n=20&y=ci +The current development version can be downloaded from +http://system.data.sqlite.org/index.html/timeline?y=ci
Features
@@ -54,13 +54,12 @@ 2005/2008/2010. 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.- Currently not included. We are still updating the design-time support - installer. Due to Visual Studio licensing restrictions, the Express - Editions can no longer be supported. + Due to Visual Studio licensing restrictions, the Express Editions can no + longer be supported.
Version History
++ 1.0.78.0 - January XX, 2012 +
+-
+
- Updated to SQLite 3.7.10 [ebd01a8def]. +
- Redesign the VS designer support installer and integrate it into the setup packages. +
- Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances. +
- Even more enhancements to the build and test automation. +
- Support parameter binding to more primitive types, including unsigned integer types. +
- Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457]. +
- Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be]. +
- Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066]. +
- Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. ** Potentially Incompatible Change ** +
1.0.77.0 - November 28, 2011
- Updated to SQLite 3.7.9 [a499ae3835]. @@ -204,11 +217,11 @@
- Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].
- When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for [7e3fa93744].
- When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for [343d392b51].
- Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.
- Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite. -
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. +
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. ** Potentially Incompatible Change **
- Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.
- Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for [737ca4ff74].
- Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].
- Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].
+ 1.0.78.0 - January XX, 2012 (release pending) +
+-
+
- Updated to SQLite 3.7.10 [ebd01a8def]. +
- Redesign the VS designer support installer and integrate it into the setup packages. +
- Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances. +
- Even more enhancements to the build and test automation. +
- Support parameter binding to more primitive types, including unsigned integer types. +
- Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457]. +
- Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be]. +
- Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066]. +
- Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. ** Potentially Incompatible Change ** +
1.0.77.0 - November 28, 2011
- Updated to SQLite 3.7.9 [a499ae3835]. @@ -17,11 +31,11 @@
- Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].
- When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for [7e3fa93744].
- When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for [343d392b51].
- Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.
- Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite. -
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. +
- Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. ** Potentially Incompatible Change **
- Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.
- Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for [737ca4ff74].
- Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].
- Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].