Version History

1.0.84.0 - January 9, 2013

+
1.0.85.0 - March XX, 2013 (release scheduled)
+
+
Updated to SQLite 3.7.16.
+
Add static Execute method to the SQLiteCommand class.
+
Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.
+
When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.
+
+
1.0.84.0 - January 9, 2013

Updated to SQLite 3.7.15.2.

Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].

Add Cancel method to the SQLiteConnection class to interrupt a long running query.

Improve thread safety of the SQLiteLog.LogMessage method.

-
1.0.83.0 - December 29, 2012
+
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.
Index: Doc/Extra/welcome.html ================================================================== --- Doc/Extra/welcome.html +++ Doc/Extra/welcome.html @@ -158,11 +158,11 @@

Distributing the Binaries (Compact Framework)

Both the System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL files must be deployed on the Compact Framework. The XXX is the build number of - the System.Data.SQLite library (e.g. "084"). The + the System.Data.SQLite library (e.g. "085"). The SQLite.Interop.XXX.DLL file is a fully native assembly compiled for the ARM processor, and System.Data.SQLite is the fully-managed Compact Framework assembly.

Index: Membership/Properties/AssemblyInfo.cs ================================================================== --- Membership/Properties/AssemblyInfo.cs +++ Membership/Properties/AssemblyInfo.cs @@ -31,7 +31,7 @@ // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: SQLite.Beta.nuspec ================================================================== --- SQLite.Beta.nuspec +++ SQLite.Beta.nuspec @@ -9,11 +9,11 @@ --> System.Data.SQLite.Beta System.Data.SQLite (x86/x64) Beta - 1.0.84.0 + 1.0.85.0 SQLite Development Team The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: SQLite.Designer/AssemblyInfo.cs ================================================================== --- SQLite.Designer/AssemblyInfo.cs +++ SQLite.Designer/AssemblyInfo.cs @@ -41,7 +41,7 @@ // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: SQLite.Designer/source.extension.vsixmanifest ================================================================== --- SQLite.Designer/source.extension.vsixmanifest +++ SQLite.Designer/source.extension.vsixmanifest @@ -1,11 +1,11 @@ System.Data.SQLite Designer http://system.data.sqlite.org/ - 1.0.84.0 + 1.0.85.0 ADO.NET Data Designer for SQLite 1033 false Index: SQLite.Interop/props/SQLite.Interop.2005.vsprops ================================================================== --- SQLite.Interop/props/SQLite.Interop.2005.vsprops +++ SQLite.Interop/props/SQLite.Interop.2005.vsprops @@ -17,26 +17,26 @@ Value="2005" PerformEnvironmentSet="true" /> 2010 - 084 + 085 1.0 - 1.0.84.0 - 1,0,84,0 + 1.0.85.0 + 1,0,85,0 INTEROP_DEBUG=0x31F;INTEROP_LOG=1;INTEROP_TEST_EXTENSION=1 INTEROP_EXTENSION_FUNCTIONS=1;INTEROP_CODEC=1 /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteCommand.bmp,System.Data.SQLite.SQLiteCommand.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteConnection.bmp,System.Data.SQLite.SQLiteConnection.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteDataAdapter.bmp,System.Data.SQLite.SQLiteDataAdapter.bmp $(ProjectDir)..\System.Data.SQLite\System.Data.SQLite.snk SQLite.Interop Index: SQLite.Interop/props/SQLite.Interop.2012.props ================================================================== --- SQLite.Interop/props/SQLite.Interop.2012.props +++ SQLite.Interop/props/SQLite.Interop.2012.props @@ -8,14 +8,14 @@ * --> 2012 - 084 + 085 1.0 - 1.0.84.0 - 1,0,84,0 + 1.0.85.0 + 1,0,85,0 INTEROP_DEBUG=0x31F;INTEROP_LOG=1;INTEROP_TEST_EXTENSION=1 INTEROP_EXTENSION_FUNCTIONS=1;INTEROP_CODEC=1 /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteCommand.bmp,System.Data.SQLite.SQLiteCommand.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteConnection.bmp,System.Data.SQLite.SQLiteConnection.bmp /ASSEMBLYRESOURCE:..\System.Data.SQLite\SQLiteDataAdapter.bmp,System.Data.SQLite.SQLiteDataAdapter.bmp $(ProjectDir)..\System.Data.SQLite\System.Data.SQLite.snk SQLite.Interop Index: SQLite.Interop/src/win/interop.h ================================================================== --- SQLite.Interop/src/win/interop.h +++ SQLite.Interop/src/win/interop.h @@ -4,7 +4,7 @@ * Written by Joe Mistachkin. * Released to the public domain, use at your own risk! */ #ifndef INTEROP_VERSION -#define INTEROP_VERSION "1.0.84.0" +#define INTEROP_VERSION "1.0.85.0" #endif Index: SQLite.MSIL.nuspec ================================================================== --- SQLite.MSIL.nuspec +++ SQLite.MSIL.nuspec @@ -8,11 +8,11 @@ * --> System.Data.SQLite.MSIL - 1.0.84.0 + 1.0.85.0 SQLite Development Team An ADO.NET provider for SQLite (managed-only). en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: SQLite.nuspec ================================================================== --- SQLite.nuspec +++ SQLite.nuspec @@ -9,11 +9,11 @@ --> System.Data.SQLite System.Data.SQLite (x86/x64) - 1.0.84.0 + 1.0.85.0 SQLite Development Team The official SQLite database engine for both x86 and x64 along with the ADO.NET provider. en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: SQLite.x64.nuspec ================================================================== --- SQLite.x64.nuspec +++ SQLite.x64.nuspec @@ -8,11 +8,11 @@ * --> System.Data.SQLite.x64 - 1.0.84.0 + 1.0.85.0 SQLite Development Team The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x64. en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: SQLite.x86.nuspec ================================================================== --- SQLite.x86.nuspec +++ SQLite.x86.nuspec @@ -8,11 +8,11 @@ * --> System.Data.SQLite.x86 - 1.0.84.0 + 1.0.85.0 SQLite Development Team The official SQLite database engine combined with a complete ADO.NET provider all rolled into a single mixed-mode assembly for x86. en-US http://system.data.sqlite.org/ http://system.data.sqlite.org/images/sqlite32.png Index: Setup/verify.lst ================================================================== --- Setup/verify.lst +++ Setup/verify.lst @@ -134,10 +134,11 @@ Setup/test_ce.bat Setup/updateFileInfo.tcl Setup/verify.eagle Setup/verify.lst Setup/vsSp.bat + SQLite.Beta.nuspec SQLite.Designer/ SQLite.Designer/AssemblyInfo.cs SQLite.Designer/ChangePasswordDialog.cs SQLite.Designer/ChangePasswordDialog.Designer.cs SQLite.Designer/ChangePasswordDialog.resx @@ -237,11 +238,10 @@ SQLite.Interop/src/win/AssemblyInfo.cpp SQLite.Interop/src/win/crypt.c SQLite.Interop/src/win/interop.c SQLite.Interop/src/win/interop.h SQLite.Interop/src/win/SQLite.Interop.rc - SQLite.Beta.nuspec SQLite.MSIL.nuspec SQLite.NET.2005.MSBuild.sln SQLite.NET.2005.sln SQLite.NET.2008.MSBuild.sln SQLite.NET.2008.sln Index: System.Data.SQLite.Linq/AssemblyInfo.cs ================================================================== --- System.Data.SQLite.Linq/AssemblyInfo.cs +++ System.Data.SQLite.Linq/AssemblyInfo.cs @@ -42,7 +42,7 @@ // Revision // // You can specify all the values or you can default the Build and Revision Numbers // by using the '*' as shown below: // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: System.Data.SQLite/AssemblyInfo.cs ================================================================== --- System.Data.SQLite/AssemblyInfo.cs +++ System.Data.SQLite/AssemblyInfo.cs @@ -62,9 +62,9 @@ // Build Number // Revision // // You can specify all the values or you can default the Revision and Build Numbers // by using the '*' as shown below: -[assembly: AssemblyVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] #if !PLATFORM_COMPACTFRAMEWORK -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] #endif Index: System.Data.SQLite/SQLite3.cs ================================================================== --- System.Data.SQLite/SQLite3.cs +++ System.Data.SQLite/SQLite3.cs @@ -55,11 +55,11 @@ "b621ddff5d844727418956997f475eb829429e411aff3e93f97b70de698b972640925bdd44280df0" + "a25a843266973704137cbb0e7441c1fe7cae4e2440ae91ab8cde3933febcb1ac48dd33b40e13c421" + "d8215c18a4349a436dd499e3c385cc683015f886f6c10bd90115eb2bd61b67750839e3a19941dc9c"; #if !PLATFORM_COMPACTFRAMEWORK - internal const string DesignerVersion = "1.0.84.0"; + internal const string DesignerVersion = "1.0.85.0"; #endif ///
/// The opaque pointer returned to us by the sqlite provider ///
Index: System.Data.SQLite/SQLiteCommand.cs ================================================================== --- System.Data.SQLite/SQLiteCommand.cs +++ System.Data.SQLite/SQLiteCommand.cs @@ -20,10 +20,17 @@ #if !PLATFORM_COMPACTFRAMEWORK [Designer("SQLite.Designer.SQLiteCommandDesigner, SQLite.Designer, Version=" + SQLite3.DesignerVersion + ", Culture=neutral, PublicKeyToken=db937bc2d44ff139"), ToolboxItem(true)] #endif public sealed class SQLiteCommand : DbCommand, ICloneable { + ///
+ /// The default connection string to be used when creating a temporary + /// connection to execute a command via the static + /// method. + ///
+ private static readonly string DefaultConnectionString = "Data Source=:memory:;"; + ///
/// The command text this command is based on ///
private string _commandText; ///
@@ -593,10 +600,93 @@ /// Returns a SQLiteDataReader object protected override DbDataReader ExecuteDbDataReader(CommandBehavior behavior) { return ExecuteReader(behavior); } + + ///
+ /// This method creates a new connection, executes the query using the given + /// execution type, closes the connection, and returns the results. If the + /// connection string is null, a temporary in-memory database connection will + /// be used. + ///
+ /// + /// The text of the command to be executed. + /// + /// + /// The execution type for the command. This is used to determine which method + /// of the command object to call, which then determines the type of results + /// returned, if any. + /// + /// + /// The connection string to the database to be opened, used, and closed. If + /// this parameter is null, a temporary in-memory databse will be used. + /// + /// + /// The SQL parameter values to be used when building the command object to be + /// executed, if any. + /// + /// + /// The results of the query -OR- null if no results were produced from the + /// given execution type. + /// + public static object Execute( + string commandText, + SQLiteExecuteType executeType, + string connectionString, + params object[] args + ) + { + if (connectionString == null) + connectionString = DefaultConnectionString; + + using (SQLiteConnection connection = new SQLiteConnection(connectionString)) + { + connection.Open(); + + using (SQLiteCommand command = connection.CreateCommand()) + { + command.CommandText = commandText; + + if (args != null) + { + foreach (object arg in args) + { + if (arg is SQLiteParameter) + command.Parameters.Add((SQLiteParameter)arg); + else + command.Parameters.Add(new SQLiteParameter(DbType.Object, arg)); + } + } + + switch (executeType) + { + case SQLiteExecuteType.None: + { + // + // NOTE: Do nothing. + // + break; + } + case SQLiteExecuteType.NonQuery: + { + return command.ExecuteNonQuery(); + } + case SQLiteExecuteType.Scalar: + { + return command.ExecuteScalar(); + } + case SQLiteExecuteType.Reader: + { + return command.ExecuteReader(); + } + } + } + } + + return null; + } ///
/// Overrides the default behavior to return a SQLiteDataReader specialization class ///
/// The flags to be associated with the reader Index: System.Data.SQLite/SQLiteConvert.cs ================================================================== --- System.Data.SQLite/SQLiteConvert.cs +++ System.Data.SQLite/SQLiteConvert.cs @@ -1182,10 +1182,48 @@ /// corrupt the database. FULL synchronous is very safe, but it is also /// slower. ///
Full = 2 } + + ///
+ /// The requested command execution type. This controls which method of the + /// object will be called. + ///
+ public enum SQLiteExecuteType + { + ///
+ /// Do nothing. No method will be called. + ///
+ None = 0, + + ///
+ /// The command is not expected to return a result -OR- the result is not + /// needed. The method will + /// be called. + ///
+ NonQuery = 1, + + ///
+ /// The command is expected to return a scalar result -OR- the result should + /// be limited to a scalar result. The + /// method will be called. + ///
+ Scalar = 2, + + ///
+ /// The command is expected to return result. + /// The method will be called. + ///
+ Reader = 3, + + ///
+ /// Use the default command execution type. Using this value is the same + /// as using the value. + ///
+ Default = NonQuery /* TODO: Good default? */ + } ///
/// Struct used internally to determine the datatype of a column in a resultset ///
internal class SQLiteType Index: System.Data.SQLite/SQLiteDataAdapter.cs ================================================================== --- System.Data.SQLite/SQLiteDataAdapter.cs +++ System.Data.SQLite/SQLiteDataAdapter.cs @@ -22,49 +22,105 @@ public sealed class SQLiteDataAdapter : DbDataAdapter { private static object _updatingEventPH = new object(); private static object _updatedEventPH = new object(); + /////////////////////////////////////////////////////////////////////////////////////////////// + + #region Public Constructors /// - /// This class is just a shell around the DbDataAdapter. Nothing from DbDataAdapter is overridden here, just a few constructors are defined. + /// This class is just a shell around the DbDataAdapter. Nothing from + /// DbDataAdapter is overridden here, just a few constructors are defined. /// ///
/// Default constructor. ///
public SQLiteDataAdapter() { } + /////////////////////////////////////////////////////////////////////////////////////////////// + ///
/// Constructs a data adapter using the specified select command. ///
- /// The select command to associate with the adapter. + /// + /// The select command to associate with the adapter. + /// public SQLiteDataAdapter(SQLiteCommand cmd) { SelectCommand = cmd; } + /////////////////////////////////////////////////////////////////////////////////////////////// + ///
- /// Constructs a data adapter with the supplied select command text and associated with the specified connection. + /// Constructs a data adapter with the supplied select command text and + /// associated with the specified connection. ///
- /// The select command text to associate with the data adapter. - /// The connection to associate with the select command. + /// + /// The select command text to associate with the data adapter. + /// + /// + /// The connection to associate with the select command. + /// public SQLiteDataAdapter(string commandText, SQLiteConnection connection) { SelectCommand = new SQLiteCommand(commandText, connection); } + /////////////////////////////////////////////////////////////////////////////////////////////// + + ///
+ /// Constructs a data adapter with the specified select command text, + /// and using the specified database connection string. + ///
+ /// + /// The select command text to use to construct a select command. + /// + /// + /// A connection string suitable for passing to a new SQLiteConnection, + /// which is associated with the select command. + /// + public SQLiteDataAdapter( + string commandText, + string connectionString + ) + : this(commandText, connectionString, false) + { + // do nothing. + } + + /////////////////////////////////////////////////////////////////////////////////////////////// + ///
- /// Constructs a data adapter with the specified select command text, and using the specified database connection string. + /// Constructs a data adapter with the specified select command text, + /// and using the specified database connection string. ///
- /// The select command text to use to construct a select command. - /// A connection string suitable for passing to a new SQLiteConnection, which is associated with the select command. - public SQLiteDataAdapter(string commandText, string connectionString) + /// + /// The select command text to use to construct a select command. + /// + /// + /// A connection string suitable for passing to a new SQLiteConnection, + /// which is associated with the select command. + /// + /// + /// Non-zero to parse the connection string using the built-in (i.e. + /// framework provided) parser when opening the connection. + /// + public SQLiteDataAdapter( + string commandText, + string connectionString, + bool parseViaFramework + ) { - SQLiteConnection cnn = new SQLiteConnection(connectionString); + SQLiteConnection cnn = new SQLiteConnection( + connectionString, parseViaFramework); + SelectCommand = new SQLiteCommand(commandText, cnn); } + #endregion /////////////////////////////////////////////////////////////////////////////////////////////// #region IDisposable "Pattern" Members private bool disposed; Index: System.Data.SQLite/SQLiteDataReader.cs ================================================================== --- System.Data.SQLite/SQLiteDataReader.cs +++ System.Data.SQLite/SQLiteDataReader.cs @@ -643,12 +643,12 @@ /// The name of the column to retrieve /// The int i of the column public override int GetOrdinal(string name) { CheckDisposed(); - CheckClosed(); - SQLiteCommand.Check(_command); + CheckClosed(); + if (_throwOnDisposed) SQLiteCommand.Check(_command); // // NOTE: First, check if the column name cache has been initialized yet. // If not, do it now. // @@ -851,12 +851,12 @@ } } internal DataTable GetSchemaTable(bool wantUniqueInfo, bool wantDefaultValue) { - CheckClosed(); - SQLiteCommand.Check(_command); + CheckClosed(); + if (_throwOnDisposed) SQLiteCommand.Check(_command); // // BUGFIX: We need to quickly scan all the fields in the current // "result set" to see how many distinct tables are actually // involved. This information is necessary so that some @@ -1218,12 +1218,12 @@ /// /// True if the command was successful and a new resultset is available, False otherwise. public override bool NextResult() { CheckDisposed(); - CheckClosed(); - SQLiteCommand.Check(_command); + CheckClosed(); + if (_throwOnDisposed) SQLiteCommand.Check(_command); SQLiteStatement stmt = null; int fieldCount; while (true) @@ -1344,12 +1344,12 @@ /// /// True if a new row was successfully loaded and is ready for processing public override bool Read() { CheckDisposed(); - CheckClosed(); - SQLiteCommand.Check(_command); + CheckClosed(); + if (_throwOnDisposed) SQLiteCommand.Check(_command); if (_readingState == -1) // First step was already done at the NextResult() level, so don't step again, just return true. { _readingState = 0; return true; Index: System.Data.SQLite/UnsafeNativeMethods.cs ================================================================== --- System.Data.SQLite/UnsafeNativeMethods.cs +++ System.Data.SQLite/UnsafeNativeMethods.cs @@ -506,11 +506,11 @@ // be used because it provides several workarounds to .NET Compact // Framework limitations important for proper operation of the core // System.Data.SQLite functionality (e.g. being able to bind // parameters and handle column values of types Int64 and Double). // - internal const string SQLITE_DLL = "SQLite.Interop.084.dll"; + internal const string SQLITE_DLL = "SQLite.Interop.085.dll"; #elif SQLITE_STANDARD // // NOTE: Otherwise, if the standard SQLite library is enabled, use it. // private const string SQLITE_DLL = "sqlite3"; Index: Tests/basic.eagle ================================================================== --- Tests/basic.eagle +++ Tests/basic.eagle @@ -2277,10 +2277,59 @@ {eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -match \ regexp -result {^\{0 x System#DBNull#\d+ 1\ \{System\.Reflection\.TargetInvocationException: Exception has been thrown by\ the target of an invocation\. ---> System\.InvalidCastException:.*\}\ System#DBNull#\d+\} \{0 x 1 0 1 1\}$}} + +############################################################################### + +runTest {test data-1.48 {static SQLiteCommand.Execute method} -setup { + unset -nocomplain result sql +} -body { + set sql(1) { \ + CREATE TABLE t1(x); \ + INSERT INTO t1 (x) VALUES (NULL); \ + SELECT x FROM t1 ORDER BY x; \ + } + + set sql(2) { \ + CREATE TABLE t1(x); \ + INSERT INTO t1 (x) VALUES (?); \ + SELECT x FROM t1 ORDER BY x; \ + } + + set result(1) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + "this will not execute" None null] + + set result(2) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(1) NonQuery null] + + set result(3) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(1) Scalar null] + + set result(4) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(1) Reader null] + + set result(5) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + "this will not execute" None null 1] + + set result(6) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(2) NonQuery null 1] + + set result(7) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(2) Scalar null 1] + + set result(8) [object invoke System.Data.SQLite.SQLiteCommand Execute \ + $sql(2) Reader null 1] + + list $result(1) $result(2) $result(3) $result(4) $result(5) $result(6) \ + $result(7) $result(8) +} -cleanup { + unset -nocomplain result sql +} -constraints {eagle monoBug28 SQLite System.Data.SQLite} -match regexp \ +-result {^\{\} 1 System#DBNull#\d+ System#Data#SQLite#SQLiteDataReader#\d+ \{\}\ +1 1 System#Data#SQLite#SQLiteDataReader#\d+$}} ############################################################################### unset -nocomplain systemDataSQLiteDllFile systemDataSQLiteLinqDllFile \ testExeFile testLinqExeFile northwindEfDbFile testLinqOutFile Index: Tests/version.eagle ================================================================== --- Tests/version.eagle +++ Tests/version.eagle @@ -27,11 +27,11 @@ # numbers must be manually kept synchronized with the version numbers for # the source code files, the built binaries, and the release packages. # set version(major) 1 set version(minor) 0 -set version(build) 84; # NOTE: Incremented with each release. +set version(build) 85; # NOTE: Incremented with each release. set version(revision) 0 ############################################################################### # ********************* END VOLATILE VERSION INFORMATION ********************** ############################################################################### @@ -175,10 +175,12 @@ [appendArgs [string map [list . \\.] $version(full)] \ ] \ [appendArgs [string map [list . \\.] $version(full)] \ ] \ [appendArgs [string map [list . \\.] $version(full)] \ + ] \ + [appendArgs [string map [list . \\.] $version(full)] \ ] \ [appendArgs Version= [string map [list . \\.] $version(full)] ,] \ [appendArgs "\; [format %03d $version(build)] "\;] \ [appendArgs AssemblyVersion\$\" [string map [list . \\.] \ $version(full)] \"\$] \ @@ -241,10 +243,11 @@ $version(full)] \"\\)]] set fileNames [list \ readme.htm \ SQLite.nuspec \ + SQLite.Beta.nuspec \ SQLite.MSIL.nuspec \ SQLite.x64.nuspec \ SQLite.x86.nuspec \ [file join Doc Extra dbfactorysupport.html] \ [file join Doc Extra welcome.html] \ Index: readme.htm ================================================================== --- readme.htm +++ readme.htm @@ -3,12 +3,12 @@ ADO.NET SQLite Data Provider
-Version 1.0.84.0 January 9, 2013
-Using SQLite 3.7.15.2
+Version 1.0.85.0 March XX, 2013 (release scheduled)
+Using SQLite 3.7.16
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/

@@ -144,11 +144,11 @@ <configuration> <system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite" /> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" - type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.84.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> + type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data> </configuration>
@@ -184,10 +184,19 @@

Version History
+
+ 1.0.85.0 - March XX, 2013 (release scheduled) +
+
+
Updated to SQLite 3.7.16.
+
Add static Execute method to the SQLiteCommand class.
+
Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.
+
When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.
+

1.0.84.0 - January 9, 2013

Updated to SQLite 3.7.15.2.
Index: test/AssemblyInfo.cs ================================================================== --- test/AssemblyInfo.cs +++ test/AssemblyInfo.cs @@ -36,7 +36,7 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: test/app.config ================================================================== --- test/app.config +++ test/app.config @@ -1,8 +1,8 @@ - + Index: testce/AssemblyInfo.cs ================================================================== --- testce/AssemblyInfo.cs +++ testce/AssemblyInfo.cs @@ -36,8 +36,8 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.84.0")] -// [assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +// [assembly: AssemblyFileVersion("1.0.85.0")] Index: testlinq/2008/App.config ================================================================== --- testlinq/2008/App.config +++ testlinq/2008/App.config @@ -1,12 +1,12 @@ - + Index: testlinq/2010/App.config ================================================================== --- testlinq/2010/App.config +++ testlinq/2010/App.config @@ -1,12 +1,12 @@ - + Index: testlinq/2012/App.config ================================================================== --- testlinq/2012/App.config +++ testlinq/2012/App.config @@ -1,12 +1,12 @@ - + Index: testlinq/Properties/AssemblyInfo.cs ================================================================== --- testlinq/Properties/AssemblyInfo.cs +++ testlinq/Properties/AssemblyInfo.cs @@ -39,7 +39,7 @@ // Revision // // You can specify all the values or you can default the Build and Revision Numbers // by using the '*' as shown below: // [assembly: AssemblyVersion("1.0.*")] -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: tools/install/Properties/AssemblyInfo.cs ================================================================== --- tools/install/Properties/AssemblyInfo.cs +++ tools/install/Properties/AssemblyInfo.cs @@ -26,7 +26,7 @@ // Major Version // Minor Version // Build Number // Revision // -[assembly: AssemblyVersion("1.0.84.0")] -[assembly: AssemblyFileVersion("1.0.84.0")] +[assembly: AssemblyVersion("1.0.85.0")] +[assembly: AssemblyFileVersion("1.0.85.0")] Index: www/build.wiki ================================================================== --- www/build.wiki +++ www/build.wiki @@ -122,10 +122,11 @@ following files:

<root>\readme.htm

<root>\SQLite.nuspec
+
<root>\SQLite.Beta.nuspec

<root>\SQLite.MSIL.nuspec

<root>\SQLite.x86.nuspec

<root>\SQLite.x64.nuspec

<root>\Doc\Extra\dbfactorysupport.html

<root>\Doc\Extra\welcome.html
Index: www/news.wiki ================================================================== --- www/news.wiki +++ www/news.wiki @@ -1,14 +1,23 @@ News Version History +
+ 1.0.85.0 - March XX, 2013 (release scheduled) +
+
+
Updated to [http://www.sqlite.org/src/info/trunk|SQLite 3.7.16].
+
Add static Execute method to the SQLiteCommand class.
+
Add public constructor to the SQLiteDataAdapter class that allows passing the parseViaFramework parameter to the SQLiteConnection constructor.
+
When built with the CHECK_STATE compile-time option, skip throwing exceptions from the SQLiteDataReader class when the object is being disposed.
+

1.0.84.0 - January 9, 2013

-
Updated to SQLite 3.7.15.2.
+
Updated to [http://www.sqlite.org/releaselog/3_7_15_2.html|SQLite 3.7.15.2].

Explicitly dispose of all SQLiteCommand objects managed by the DbDataAdapter class. Fix for [6434e23a0f].

Add Cancel method to the SQLiteConnection class to interrupt a long running query.

Improve thread safety of the SQLiteLog.LogMessage method.