Version History
-1.0.81.0 - June XX, 2012
--
-
- Updated to SQLite 3.7.12. -
- Support compiling the interop assembly without support for the custom extension functions and the CryptoAPI based codec. -
- Add DefineConstants property to the SQLiteConnection class to return the list of define constants used when compiling the core managed assembly. -
- Add release archive verification tool to the release automation. -
- Fix subtle race condition between threads fetching connection handles from the connection pool any garbage collection (GC) threads that may be running. Fix for [996d13cd87]. -
- Add missing call to SetTimeout in the SQLite3_UTF16.Open method. -
- Add checks to prevent the SQLiteConnectionPool.Remove method from returning any connection handles that are closed or invalid. -
- Modify static SQLiteBase helper methods to prevent them from passing IntPtr.Zero to the SQLite native library. -
- Remove static locks from the static helper methods in the SQLiteBase class, replacing them with a lock on the connection handle instance being operated upon. -
- Revise CriticalHandle derived classes to make them more thread-safe. -
- Add connection pool related diagnostic messages when compiled with the DEBUG define constant. -
- Add PoolCount property to the SQLiteConnection class to return the number of pool entries for the file name associated with the connection. -
- Rename internal SQLiteLastError methods to GetLastError. -
- Add assembly file test constraints to all tests that execute the "test.exe" or "testlinq.exe" files. -
1.0.80.0 - April 1, 2012
--
-
- Updated to SQLite 3.7.11. -
- In the SQLiteFunction class, when calling user-provided methods from a delegate called by native code, avoid throwing exceptions, optionally tracing the caught exceptions. Fix for [8a426d12eb]. -
- Add Visual Studio 2005 support to all the applicable solution/project files, their associated supporting files, and the test suite. -
- Add Visual Studio 2005 support to the redesigned designer support installer. -
- Add experimental support for "pre-loading" the native SQLite library based on the processor architecture of the current process. This feature is now enabled by default at compile-time. -
- Add support for the native SQLite Online Backup API. Fix for [c71846ed57]. -
- Acquire and hold a static data lock while checking if the native SQLite library has been initialized to prevent a subtle race condition that can result in superfluous error messages. Fix for [72905c9a77]. -
- Support tracing of all parameter binding activity and use the connection flags to control what is traced. -
- When converting a DateTime instance of an "Unspecified" kind to a string, use the same kind as the connection, if available. -
- Add overload of the SQLiteDataReader.GetValues method that returns a NameValueCollection. -
- Add static ToUnixEpoch method to the SQLiteConvert class to convert a DateTime value to the number of whole seconds since the Unix epoch. -
- In the implicit conversion operators (to IntPtr) for both the SQLiteConnectionHandle and SQLiteStatementHandle classes, return IntPtr.Zero if the instance being converted is null. -
- Write warning message to the active trace listeners (for the Debug build configuration only) if a column type or type name cannot be mapped properly. See [4bbf851fa5]. -
- When tracing SQL statements to be prepared, bypass the internal length limit of the sqlite3_log function by using the SQLiteLog class directly instead. Also, detect null and/or empty strings and emit a special message in that case. -
- For the setup, the Visual Studio task should only be initially checked if the GAC task is available and vice-versa. -
- Improve compatibility with custom command processors by using __ECHO instead of _ECHO in batch tools. -
- Add OpenAndReturn method to the SQLiteConnection class to open a connection and return it. -
- Add missing CheckDisposed calls to the SQLiteConnection class. -
- Add missing throw statement to the SQLiteConnection class. -
- Make sure the interop project uses /fp:precise for Windows CE. -
- Regenerate package load key to support loading the designer package into Visual Studio 2008 without having the matching SDK installed. -
- Modify transaction object disposal so that it can never cause an exception to be thrown. -
1.0.79.0 - January 28, 2012
--
-
- Use the WoW64 registry keys when installing the VS designer components on 64-bit Windows. Fix for [d8491abd0b]. -
- Correct resource name used by the LINQ assembly to locate several key string resources. Fix for [fbebb30da9]. -
1.0.78.0 - January 27, 2012
+1.0.78.0 - January XX, 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.
- 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]. Index: Doc/Extra/welcome.html ================================================================== --- Doc/Extra/welcome.html +++ Doc/Extra/welcome.html @@ -41,131 +41,112 @@
About SQLite.NET
-This class library is an ADO.NET wrapper around the popular (and free!) - SQLite database engine. For information on SQL syntax, features of SQLite and a - good understanding of how it works and what it does, I highly recommend heading - over to sqlite.org and +
This class library is an ADO.NET wrapper around the popular (and free!) + SQLite database engine. For information on SQL syntax, features of SQLite and a + good understanding of how it works and what it does, I highly recommend heading + over to sqlite.org and reading the documentation there.
-The C# provider, the very minor C code modifications to SQLite, documentation and
- etc were written by Robert
+ The C# provider, the very minor C code modifications to SQLite, documentation and
+ etc were written by Robert
Simpson, and the SourceForge project page can be found
here. The System.Data.SQLite project is currently maintained by the
- SQLite Development Team and
- the latest source code and project information can be found
- here. Click here to see the version history of this SQLite.NET
+ Click here to see the version history of this SQLite.NET
provider The following are links to information on various aspects of the library and
+ The following are links to information on various aspects of the library and
how to use it in your application(s)
How to install Visual Studio Design-Time Support How to configure and enumerate SQLite.NET
+ How to configure and enumerate SQLite.NET
through the DbProviderFactories object Getting the best performance out of SQLite
What's New?
-
Using this library
-