System.Data.SQLite
Check-in [63d2c28b37]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Merge updates from trunk.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | preRelease
Files: files | file ages | folders
SHA1: 63d2c28b37ca66c3a3dc63c1ac1a0c2b90156367
User & Date: mistachkin 2015-02-13 21:31:37
Context
2015-02-20
19:15
Merge updates from trunk. check-in: 3e7ed06ca5 user: mistachkin tags: preRelease
2015-02-13
21:31
Merge updates from trunk. check-in: 63d2c28b37 user: mistachkin tags: preRelease
21:30
Refactor NuGet packages. check-in: 126b7c1987 user: mistachkin tags: trunk
2015-02-09
23:19
Merge updates from trunk. check-in: ae3b0b3c66 user: mistachkin tags: preRelease
Changes
Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to Doc/Extra/Provider/version.html.

44
45
46
47
48
49
50



51
52
53
54
55
56
57
..
58
59
60
61
62
63
64

65
66
67
68
69
70
71
    <div id="mainBody">
    <h1 class="heading">Version History</h1>
    <p><b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li>
      <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li>
      <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for <a href="https://system.data.sqlite.org/index.html/info/2be4298631">[2be4298631]</a>, <a href="https://system.data.sqlite.org/index.html/info/abad7c577d">[abad7c577d]</a>, and <a href="https://system.data.sqlite.org/index.html/info/417d669435">[417d669435]</a>.</li>



      <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
      <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for <a href="https://system.data.sqlite.org/index.html/info/56f511d268">[56f511d268]</a>.</li>
      <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for <a href="https://system.data.sqlite.org/index.html/info/85b824b736">[85b824b736]</a>.</li>
      <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e122d26e70">[e122d26e70]</a>.</li>
      <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for <a href="https://system.data.sqlite.org/index.html/info/daeaf3150a">[daeaf3150a]</a>.</li>
      <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for <a href="https://system.data.sqlite.org/index.html/info/0a32885109">[0a32885109]</a>.</li>
      <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for <a href="https://system.data.sqlite.org/index.html/info/c5cc2fb334">[c5cc2fb334]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
      <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for <a href="https://system.data.sqlite.org/index.html/info/3e783eecbe">[3e783eecbe]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for <a href="https://system.data.sqlite.org/index.html/info/e796ac82c1">[e796ac82c1]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Make sure the interop files are copied before the PostBuildEvent. Fix for <a href="https://system.data.sqlite.org/index.html/info/f16c93a932">[f16c93a932]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for <a href="https://system.data.sqlite.org/index.html/info/47c6fa04d3">[47c6fa04d3]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
      <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
      <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for <a href="https://system.data.sqlite.org/index.html/info/8d928c3e88">[8d928c3e88]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>

    </ul>
    <p><b>1.0.94.0 - September 9, 2014</b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li>
      <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li>
      <li>Refactor and simplify NuGet packages in order to support per-solution SQLite interop assembly files.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Add RefreshFlags method to the SQLiteDataReader class to forcibly refresh its connection flags.</li>







>
>
>







 







>







44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
..
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
    <div id="mainBody">
    <h1 class="heading">Version History</h1>
    <p><b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li>
      <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li>
      <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for <a href="https://system.data.sqlite.org/index.html/info/2be4298631">[2be4298631]</a>, <a href="https://system.data.sqlite.org/index.html/info/abad7c577d">[abad7c577d]</a>, and <a href="https://system.data.sqlite.org/index.html/info/417d669435">[417d669435]</a>.</li>
      <li>The &quot;System.Data.SQLite.EF6*&quot; and &quot;System.Data.SQLite.Linq*&quot; NuGet packages no longer depend on the &quot;System.Data.SQLite.Core*&quot; packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>The &quot;System.Data.SQLite.MSIL*&quot; NuGet packages no longer directly include any files; they are now meta-packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>The &quot;System.Data.SQLite.x86*&quot; and &quot;System.Data.SQLite.x64*&quot; NuGet packages now depend on the &quot;System.Data.SQLite.Linq&quot; and &quot;System.Data.SQLite.EF6&quot; NuGet packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
      <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for <a href="https://system.data.sqlite.org/index.html/info/56f511d268">[56f511d268]</a>.</li>
      <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for <a href="https://system.data.sqlite.org/index.html/info/85b824b736">[85b824b736]</a>.</li>
      <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to <a href="https://system.data.sqlite.org/index.html/info/e122d26e70">[e122d26e70]</a>.</li>
      <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for <a href="https://system.data.sqlite.org/index.html/info/daeaf3150a">[daeaf3150a]</a>.</li>
      <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for <a href="https://system.data.sqlite.org/index.html/info/0a32885109">[0a32885109]</a>.</li>
      <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for <a href="https://system.data.sqlite.org/index.html/info/c5cc2fb334">[c5cc2fb334]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
      <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for <a href="https://system.data.sqlite.org/index.html/info/3e783eecbe">[3e783eecbe]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for <a href="https://system.data.sqlite.org/index.html/info/e796ac82c1">[e796ac82c1]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Make sure the interop files are copied before the PostBuildEvent. Fix for <a href="https://system.data.sqlite.org/index.html/info/f16c93a932">[f16c93a932]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for <a href="https://system.data.sqlite.org/index.html/info/47c6fa04d3">[47c6fa04d3]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
      <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
      <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for <a href="https://system.data.sqlite.org/index.html/info/8d928c3e88">[8d928c3e88]</a>.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Add PrepareRetries connection string property to allow the maximum number of retries when preparing a query to be overridden. Fix for <a href="https://system.data.sqlite.org/index.html/info/647d282d11">[647d282d11]</a>.</li>
    </ul>
    <p><b>1.0.94.0 - September 9, 2014</b></p>
    <ul>
      <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li>
      <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li>
      <li>Refactor and simplify NuGet packages in order to support per-solution SQLite interop assembly files.&nbsp;<b>** Potentially Incompatible Change **</b></li>
      <li>Add RefreshFlags method to the SQLiteDataReader class to forcibly refresh its connection flags.</li>

Changes to NuGet/SQLite.EF6.Beta.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">







<
<
<
<
<
<
<
<
<







17
18
19
20
21
22
23









24
25
26
27
28
29
30
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>









      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">

Changes to NuGet/SQLite.EF6.Test.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">







<
<
<
<
<
<
<
<
<







17
18
19
20
21
22
23









24
25
26
27
28
29
30
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>









      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">

Changes to NuGet/SQLite.EF6.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">







<
<
<
<
<
<
<
<
<







17
18
19
20
21
22
23









24
25
26
27
28
29
30
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>









      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">

Changes to NuGet/SQLite.Linq.Beta.nuspec.

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    <description>This is a &quot;beta&quot; package and is not intended for production use.  Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.Beta" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />







<
<
<
<
<
<
<
<
<
<
<
<
<
<







16
17
18
19
20
21
22














23
24
25
26
27
28
29
    <description>This is a &quot;beta&quot; package and is not intended for production use.  Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>














  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />

Changes to NuGet/SQLite.Linq.Test.nuspec.

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    <description>This is a pre-release package and is not intended for production use.  Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.Test" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />







<
<
<
<
<
<
<
<
<
<
<
<
<
<







16
17
18
19
20
21
22














23
24
25
26
27
28
29
    <description>This is a pre-release package and is not intended for production use.  Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>














  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />

Changes to NuGet/SQLite.Linq.nuspec.

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    <description>Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />







<
<
<
<
<
<
<
<
<
<
<
<
<
<







16
17
18
19
20
21
22














23
24
25
26
27
28
29
    <description>Support for LINQ using System.Data.SQLite.</description>
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>














  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />

Changes to NuGet/SQLite.MSIL.Beta.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />
    <file src="shared\Core\content\config.transform" target="content\net20\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\web.config.transform" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net40\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net45\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net451\install.ps1" />
  </files>
</package>







|
|

|
|

|
|

|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<
<
<
|

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58



59
60
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core.MSIL.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.MSIL.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.MSIL.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.MSIL.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Linq.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Linq.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Linq.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Linq.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.EF6.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.EF6.Beta" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.EF6.Beta" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>



  <files />
</package>

Changes to NuGet/SQLite.MSIL.Test.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />
    <file src="shared\Core\content\config.transform" target="content\net20\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\web.config.transform" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net40\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net45\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net451\install.ps1" />
  </files>
</package>







|
|

|
|

|
|

|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<
<
<
|

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58



59
60
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core.MSIL.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.MSIL.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.MSIL.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.MSIL.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Linq.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Linq.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Linq.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Linq.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.EF6.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.EF6.Test" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.EF6.Test" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>



  <files />
</package>

Changes to NuGet/SQLite.MSIL.nuspec.

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />
    <file src="shared\Core\content\config.transform" target="content\net20\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\web.config.transform" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net40\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net45\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net451\install.ps1" />
  </files>
</package>







|
|

|
|

|
|

|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
<
<
<
|

17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58



59
60
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Core.MSIL" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Core.MSIL" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Core.MSIL" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Core.MSIL" version="1.0.95.0" />
      </group>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>



  <files />
</package>

Changes to NuGet/SQLite.x64.nuspec.

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30












31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="EntityFramework" version="6.1.2.0" />












      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />
    <file src="shared\Core\content\config.transform" target="content\net20\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\web.config.transform" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net40\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net45\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net451\install.ps1" />
  </files>
</package>







|
|

|
|

|
|
>
>
>
>
>
>
>
>
>
>
>
>












<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<


16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54


















55
56
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\x64\ReleaseStatic\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />


















  </files>
</package>

Changes to NuGet/SQLite.x86.nuspec.

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30












31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net40">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="EntityFramework" version="6.1.2.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="EntityFramework" version="6.1.2.0" />












      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net20" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.Linq.dll" target="lib\net451" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net40" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net45" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.EF6.dll" target="lib\net451" />
    <file src="shared\Core\content\config.transform" target="content\net20\app.config.transform" />
    <file src="shared\Core\content\config.transform" target="content\net20\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net40\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net45\web.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\app.config.transform" />
    <file src="net40\EF6\content\config.transform" target="content\net451\web.config.transform" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net40\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net45\install.ps1" />
    <file src="net40\EF6\tools\provider.ps1" target="tools\net451\install.ps1" />
  </files>
</package>







|
|

|
|

|
|
>
>
>
>
>
>
>
>
>
>
>
>












<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<


16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54


















55
56
    <language>en-US</language>
    <projectUrl>https://system.data.sqlite.org/</projectUrl>
    <iconUrl>https://system.data.sqlite.org/images/sqlite128.png</iconUrl>
    <licenseUrl>https://www.sqlite.org/copyright.html</licenseUrl>
    <tags>sqlite database ado.net provider interop</tags>
    <copyright>Public Domain</copyright>
    <dependencies>
      <group targetFramework="net20">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.Linq" version="1.0.95.0" />
      </group>
      <group targetFramework="net40">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net45">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
      <group targetFramework="net451">
        <dependency id="System.Data.SQLite.EF6" version="1.0.95.0" />
      </group>
    </dependencies>
  </metadata>
  <files>
    <file src="..\bin\2008\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net20" />
    <file src="..\bin\2008\Release\bin\System.Data.SQLite.xml" target="lib\net20" />
    <file src="..\bin\2010\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net40" />
    <file src="..\bin\2010\Release\bin\System.Data.SQLite.xml" target="lib\net40" />
    <file src="..\bin\2012\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net45" />
    <file src="..\bin\2012\Release\bin\System.Data.SQLite.xml" target="lib\net45" />
    <file src="..\bin\2013\Win32\ReleaseStatic\System.Data.SQLite.dll" target="lib\net451" />
    <file src="..\bin\2013\Release\bin\System.Data.SQLite.xml" target="lib\net451" />


















  </files>
</package>

Changes to SQLite.Interop/src/win/interop.c.

4
5
6
7
8
9
10












11
12
13
14
15
16
17
..
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
..
85
86
87
88
89
90
91






92
93
94
95
96
97
98
 *
 * Released to the public domain, use at your own risk!
 ********************************************************/

#define SQLITE_API __declspec(dllexport)

#include "../core/sqlite3.c"













#if defined(INTEROP_VIRTUAL_TABLE) && SQLITE_VERSION_NUMBER >= 3004001
#include "../ext/vtshim.c"
#endif

#if defined(INTEROP_PERCENTILE_EXTENSION)
#include "../ext/percentile.c"
................................................................................

#if defined(INTEROP_EXTENSION_FUNCTIONS)
#include "../contrib/extension-functions.c"
extern int RegisterExtensionFunctions(sqlite3 *db);
#endif

#if defined(SQLITE_OS_WIN)
#if defined(INTEROP_CODEC)
#include "crypt.c"
#elif defined(INTEROP_INCLUDE_SEE)
#include "../ext/see.c"
#endif

#include "interop.h"

#define INTEROP_DEBUG_NONE           (0x0000)
#define INTEROP_DEBUG_CLOSE          (0x0001)
#define INTEROP_DEBUG_FINALIZE       (0x0002)
................................................................................
  "CODEC",
#endif
#ifdef INTEROP_DEBUG
  "DEBUG=" CTIMEOPT_VAL(INTEROP_DEBUG),
#endif
#ifdef INTEROP_EXTENSION_FUNCTIONS
  "EXTENSION_FUNCTIONS",






#endif
#ifdef INTEROP_INCLUDE_SEE
  "INCLUDE_SEE",
#endif
#ifdef INTEROP_LEGACY_CLOSE
  "LEGACY_CLOSE",
#endif







>
>
>
>
>
>
>
>
>
>
>
>







 







|

<
<







 







>
>
>
>
>
>







4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
..
39
40
41
42
43
44
45
46
47


48
49
50
51
52
53
54
..
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
 *
 * Released to the public domain, use at your own risk!
 ********************************************************/

#define SQLITE_API __declspec(dllexport)

#include "../core/sqlite3.c"

#if defined(INTEROP_INCLUDE_EXTRA)
#include "../ext/extra.c"
#endif

#if defined(INTEROP_INCLUDE_CEROD)
#include "../ext/cerod.c"
#endif

#if defined(INTEROP_INCLUDE_SEE)
#include "../ext/see.c"
#endif

#if defined(INTEROP_VIRTUAL_TABLE) && SQLITE_VERSION_NUMBER >= 3004001
#include "../ext/vtshim.c"
#endif

#if defined(INTEROP_PERCENTILE_EXTENSION)
#include "../ext/percentile.c"
................................................................................

#if defined(INTEROP_EXTENSION_FUNCTIONS)
#include "../contrib/extension-functions.c"
extern int RegisterExtensionFunctions(sqlite3 *db);
#endif

#if defined(SQLITE_OS_WIN)
#if defined(INTEROP_CODEC) && !defined(INTEROP_INCLUDE_SEE)
#include "crypt.c"


#endif

#include "interop.h"

#define INTEROP_DEBUG_NONE           (0x0000)
#define INTEROP_DEBUG_CLOSE          (0x0001)
#define INTEROP_DEBUG_FINALIZE       (0x0002)
................................................................................
  "CODEC",
#endif
#ifdef INTEROP_DEBUG
  "DEBUG=" CTIMEOPT_VAL(INTEROP_DEBUG),
#endif
#ifdef INTEROP_EXTENSION_FUNCTIONS
  "EXTENSION_FUNCTIONS",
#endif
#ifdef INTEROP_INCLUDE_CEROD
  "INCLUDE_CEROD",
#endif
#ifdef INTEROP_INCLUDE_EXTRA
  "INCLUDE_EXTRA",
#endif
#ifdef INTEROP_INCLUDE_SEE
  "INCLUDE_SEE",
#endif
#ifdef INTEROP_LEGACY_CLOSE
  "LEGACY_CLOSE",
#endif

Changes to SQLite.Interop/src/win/interop.h.

6
7
8
9
10
11
12
13
14
15
16
17
18
 */

#ifndef INTEROP_VERSION
#define INTEROP_VERSION          "1.0.95.0"
#endif

#ifndef INTEROP_SOURCE_ID
#define INTEROP_SOURCE_ID        "c0f67d5d98a67b7f411873193fb9fe934d5be125"
#endif

#ifndef INTEROP_SOURCE_TIMESTAMP
#define INTEROP_SOURCE_TIMESTAMP "2015-01-30 17:59:12 UTC"
#endif







|



|

6
7
8
9
10
11
12
13
14
15
16
17
18
 */

#ifndef INTEROP_VERSION
#define INTEROP_VERSION          "1.0.95.0"
#endif

#ifndef INTEROP_SOURCE_ID
#define INTEROP_SOURCE_ID        "0000000000000000000000000000000000000000"
#endif

#ifndef INTEROP_SOURCE_TIMESTAMP
#define INTEROP_SOURCE_TIMESTAMP "0000-00-00 00:00:00 UTC"
#endif

Changes to System.Data.SQLite/SQLite3.cs.

974
975
976
977
978
979
980

981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
      }

      IntPtr stmt = IntPtr.Zero;
      IntPtr ptr = IntPtr.Zero;
      int len = 0;
      SQLiteErrorCode n = SQLiteErrorCode.Schema;
      int retries = 0;

      byte[] b = ToUTF8(strSql);
      string typedefs = null;
      SQLiteStatement cmd = null;
      Random rnd = null;
      uint starttick = (uint)Environment.TickCount;

      GCHandle handle = GCHandle.Alloc(b, GCHandleType.Pinned);
      IntPtr psql = handle.AddrOfPinnedObject();
      SQLiteStatementHandle statementHandle = null;
      try
      {
        while ((n == SQLiteErrorCode.Schema || n == SQLiteErrorCode.Locked || n == SQLiteErrorCode.Busy) && retries < 3)
        {
          try
          {
            // do nothing.
          }
          finally /* NOTE: Thread.Abort() protection. */
          {







>











|







974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
      }

      IntPtr stmt = IntPtr.Zero;
      IntPtr ptr = IntPtr.Zero;
      int len = 0;
      SQLiteErrorCode n = SQLiteErrorCode.Schema;
      int retries = 0;
      int maximumRetries = (cnn != null) ? cnn._prepareRetries : SQLiteConnection.DefaultPrepareRetries;
      byte[] b = ToUTF8(strSql);
      string typedefs = null;
      SQLiteStatement cmd = null;
      Random rnd = null;
      uint starttick = (uint)Environment.TickCount;

      GCHandle handle = GCHandle.Alloc(b, GCHandleType.Pinned);
      IntPtr psql = handle.AddrOfPinnedObject();
      SQLiteStatementHandle statementHandle = null;
      try
      {
        while ((n == SQLiteErrorCode.Schema || n == SQLiteErrorCode.Locked || n == SQLiteErrorCode.Busy) && retries < maximumRetries)
        {
          try
          {
            // do nothing.
          }
          finally /* NOTE: Thread.Abort() protection. */
          {

Changes to System.Data.SQLite/SQLiteConnection.cs.

373
374
375
376
377
378
379

380
381
382
383
384
385
386
...
513
514
515
516
517
518
519
520







521
522
523
524
525
526
527
....
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
....
2537
2538
2539
2540
2541
2542
2543

2544
2545
2546
2547
2548
2549
2550
....
2753
2754
2755
2756
2757
2758
2759











2760
2761
2762
2763
2764
2765
2766
    private const bool DefaultUseUTF16Encoding = false;
    private const bool DefaultToFullPath = true;
    private const bool DefaultPooling = false; // TODO: Maybe promote this to static property?
    private const bool DefaultLegacyFormat = false;
    private const bool DefaultForeignKeys = false;
    private const bool DefaultEnlist = true;
    private const bool DefaultSetDefaults = true;


    private const int SQLITE_FCNTL_CHUNK_SIZE = 6;
    private const int SQLITE_FCNTL_WIN32_AV_RETRY = 9;

    private const string _dataDirectory = "|DataDirectory|";
    private const string _masterdb = "sqlite_master";
    private const string _tempmasterdb = "sqlite_temp_master";
................................................................................
    /// flag is set.
    /// </summary>
    private string _defaultTypeName;

    /// <summary>
    /// Default command timeout
    /// </summary>
    private int _defaultTimeout = 30;








    /// <summary>
    /// Non-zero if the built-in (i.e. framework provided) connection string
    /// parser should be used when opening the connection.
    /// </summary>
    private bool _parseViaFramework;

................................................................................
    /// Obsolete
    /// </summary>
    public override int ConnectionTimeout
    {
      get
      {
        CheckDisposed();
        return 30;
      }
    }
#endif

    /// <summary>
    /// Creates a clone of the connection.  All attached databases and user-defined functions are cloned.  If the existing connection is open, the cloned connection
    /// will also be opened.
................................................................................

      try
      {
        bool usePooling = SQLiteConvert.ToBoolean(FindKey(opts, "Pooling", GetDefaultPooling().ToString()));
        int maxPoolSize = Convert.ToInt32(FindKey(opts, "Max Pool Size", DefaultMaxPoolSize.ToString()), CultureInfo.InvariantCulture);

        _defaultTimeout = Convert.ToInt32(FindKey(opts, "Default Timeout", DefaultConnectionTimeout.ToString()), CultureInfo.InvariantCulture);


        enumValue = TryParseEnum(typeof(IsolationLevel), FindKey(opts, "Default IsolationLevel", DefaultIsolationLevel.ToString()), true);
        _defaultIsolation = (enumValue is IsolationLevel) ? (IsolationLevel)enumValue : DefaultIsolationLevel;
        _defaultIsolation = GetEffectiveIsolationLevel(_defaultIsolation);

        if (_defaultIsolation != ImmediateIsolationLevel && _defaultIsolation != DeferredIsolationLevel)
          throw new NotSupportedException("Invalid Default IsolationLevel specified");
................................................................................
    /// This can also be set in the ConnectionString with "Default Timeout"
    /// </summary>
    public int DefaultTimeout
    {
      get { CheckDisposed(); return _defaultTimeout; }
      set { CheckDisposed(); _defaultTimeout = value; }
    }












    /// <summary>
    /// Non-zero if the built-in (i.e. framework provided) connection string
    /// parser should be used when opening the connection.
    /// </summary>
    public bool ParseViaFramework
    {







>







 







|
>
>
>
>
>
>
>







 







|







 







>







 







>
>
>
>
>
>
>
>
>
>
>







373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
...
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
....
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
....
2545
2546
2547
2548
2549
2550
2551
2552
2553
2554
2555
2556
2557
2558
2559
....
2762
2763
2764
2765
2766
2767
2768
2769
2770
2771
2772
2773
2774
2775
2776
2777
2778
2779
2780
2781
2782
2783
2784
2785
2786
    private const bool DefaultUseUTF16Encoding = false;
    private const bool DefaultToFullPath = true;
    private const bool DefaultPooling = false; // TODO: Maybe promote this to static property?
    private const bool DefaultLegacyFormat = false;
    private const bool DefaultForeignKeys = false;
    private const bool DefaultEnlist = true;
    private const bool DefaultSetDefaults = true;
    internal const int DefaultPrepareRetries = 3;

    private const int SQLITE_FCNTL_CHUNK_SIZE = 6;
    private const int SQLITE_FCNTL_WIN32_AV_RETRY = 9;

    private const string _dataDirectory = "|DataDirectory|";
    private const string _masterdb = "sqlite_master";
    private const string _tempmasterdb = "sqlite_temp_master";
................................................................................
    /// flag is set.
    /// </summary>
    private string _defaultTypeName;

    /// <summary>
    /// Default command timeout
    /// </summary>
    private int _defaultTimeout = DefaultConnectionTimeout;

    /// <summary>
    /// The maximum number of retries when preparing SQL to be executed.  This
    /// normally only applies to preparation errors resulting from the database
    /// schema being changed.
    /// </summary>
    internal int _prepareRetries = DefaultPrepareRetries;

    /// <summary>
    /// Non-zero if the built-in (i.e. framework provided) connection string
    /// parser should be used when opening the connection.
    /// </summary>
    private bool _parseViaFramework;

................................................................................
    /// Obsolete
    /// </summary>
    public override int ConnectionTimeout
    {
      get
      {
        CheckDisposed();
        return DefaultConnectionTimeout;
      }
    }
#endif

    /// <summary>
    /// Creates a clone of the connection.  All attached databases and user-defined functions are cloned.  If the existing connection is open, the cloned connection
    /// will also be opened.
................................................................................

      try
      {
        bool usePooling = SQLiteConvert.ToBoolean(FindKey(opts, "Pooling", GetDefaultPooling().ToString()));
        int maxPoolSize = Convert.ToInt32(FindKey(opts, "Max Pool Size", DefaultMaxPoolSize.ToString()), CultureInfo.InvariantCulture);

        _defaultTimeout = Convert.ToInt32(FindKey(opts, "Default Timeout", DefaultConnectionTimeout.ToString()), CultureInfo.InvariantCulture);
        _prepareRetries = Convert.ToInt32(FindKey(opts, "PrepareRetries", DefaultPrepareRetries.ToString()), CultureInfo.InvariantCulture);

        enumValue = TryParseEnum(typeof(IsolationLevel), FindKey(opts, "Default IsolationLevel", DefaultIsolationLevel.ToString()), true);
        _defaultIsolation = (enumValue is IsolationLevel) ? (IsolationLevel)enumValue : DefaultIsolationLevel;
        _defaultIsolation = GetEffectiveIsolationLevel(_defaultIsolation);

        if (_defaultIsolation != ImmediateIsolationLevel && _defaultIsolation != DeferredIsolationLevel)
          throw new NotSupportedException("Invalid Default IsolationLevel specified");
................................................................................
    /// This can also be set in the ConnectionString with "Default Timeout"
    /// </summary>
    public int DefaultTimeout
    {
      get { CheckDisposed(); return _defaultTimeout; }
      set { CheckDisposed(); _defaultTimeout = value; }
    }

    /// <summary>
    /// The maximum number of retries when preparing SQL to be executed.  This
    /// normally only applies to preparation errors resulting from the database
    /// schema being changed.
    /// </summary>
    public int PrepareRetries
    {
        get { CheckDisposed(); return _prepareRetries; }
        set { CheckDisposed(); _prepareRetries = value; }
    }

    /// <summary>
    /// Non-zero if the built-in (i.e. framework provided) connection string
    /// parser should be used when opening the connection.
    /// </summary>
    public bool ParseViaFramework
    {

Changes to System.Data.SQLite/SQLiteConnectionStringBuilder.cs.

247
248
249
250
251
252
253






















254
255
256
257
258
259
260
        return Convert.ToInt32(value, CultureInfo.CurrentCulture);
      }
      set
      {
        this["default timeout"] = value;
      }
    }























    /// <summary>
    /// Determines whether or not the connection will automatically participate
    /// in the current distributed transaction (if one exists)
    /// </summary>
    [Browsable(true)]
    [DefaultValue(true)]







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
        return Convert.ToInt32(value, CultureInfo.CurrentCulture);
      }
      set
      {
        this["default timeout"] = value;
      }
    }

    /// <summary>
    /// Gets/sets the maximum number of retries when preparing SQL to be executed.
    /// This normally only applies to preparation errors resulting from the database
    /// schema being changed.
    /// </summary>
    [DisplayName("Prepare Retries")]
    [Browsable(true)]
    [DefaultValue(3)]
    public int PrepareRetries
    {
        get
        {
            object value;
            TryGetValue("prepareretries", out value);
            return Convert.ToInt32(value, CultureInfo.CurrentCulture);
        }
        set
        {
            this["prepareretries"] = value;
        }
    }

    /// <summary>
    /// Determines whether or not the connection will automatically participate
    /// in the current distributed transaction (if one exists)
    /// </summary>
    [Browsable(true)]
    [DefaultValue(true)]

Changes to System.Data.SQLite/SQLiteDefineConstants.cs.

31
32
33
34
35
36
37








38
39
40
41
42
43
44
#if INTEROP_DEBUG
            "INTEROP_DEBUG",
#endif

#if INTEROP_EXTENSION_FUNCTIONS
            "INTEROP_EXTENSION_FUNCTIONS",
#endif









#if INTEROP_INCLUDE_SEE
            "INTEROP_INCLUDE_SEE",
#endif

#if INTEROP_LEGACY_CLOSE
            "INTEROP_LEGACY_CLOSE",







>
>
>
>
>
>
>
>







31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
#if INTEROP_DEBUG
            "INTEROP_DEBUG",
#endif

#if INTEROP_EXTENSION_FUNCTIONS
            "INTEROP_EXTENSION_FUNCTIONS",
#endif

#if INTEROP_INCLUDE_CEROD
            "INTEROP_INCLUDE_CEROD",
#endif

#if INTEROP_INCLUDE_EXTRA
            "INTEROP_INCLUDE_EXTRA",
#endif

#if INTEROP_INCLUDE_SEE
            "INTEROP_INCLUDE_SEE",
#endif

#if INTEROP_LEGACY_CLOSE
            "INTEROP_LEGACY_CLOSE",

Changes to System.Data.SQLite/SQLitePatchLevel.cs.

5
6
7
8
9
10
11
12
13
14
15
16
 * Released to the public domain, use at your own risk!
 ********************************************************/

using System.Data.SQLite;

///////////////////////////////////////////////////////////////////////////////

[assembly: AssemblySourceId("c0f67d5d98a67b7f411873193fb9fe934d5be125")]

///////////////////////////////////////////////////////////////////////////////

[assembly: AssemblySourceTimeStamp("2015-01-30 17:59:12 UTC")]







|



|
5
6
7
8
9
10
11
12
13
14
15
16
 * Released to the public domain, use at your own risk!
 ********************************************************/

using System.Data.SQLite;

///////////////////////////////////////////////////////////////////////////////

[assembly: AssemblySourceId(null)]

///////////////////////////////////////////////////////////////////////////////

[assembly: AssemblySourceTimeStamp(null)]

Changes to System.Data.SQLite/Targets/System.Data.SQLite.Properties.targets.

93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
...
160
161
162
163
164
165
166

















167
168
169
170
171
172
173
  -->
  <PropertyGroup Condition="'$(TrackMemoryBytes)' != 'false'">
    <DefineConstants>$(DefineConstants);TRACK_MEMORY_BYTES</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: For interaction with the native SQLite implementation, use the
            custom build interop DLL (i.e. "SQLite.Interop.DLL")?
  -->
  <PropertyGroup Condition="'$(UseInteropDll)' != 'false'">
    <DefineConstants>$(DefineConstants);USE_INTEROP_DLL</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: For interaction with the native SQLite implementation, use the
................................................................................
      NOTE: Enable support (in the managed assemblies) for encrypted databases
            using SEE?
  -->
  <PropertyGroup Condition="'$(InteropIncludeSee)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_INCLUDE_SEE</DefineConstants>
  </PropertyGroup>


















  <!--
      NOTE: Enable extra diagnostics from the custom built interop DLL (see the
            "SQLite.NET.Settings.targets" file for more information)?
  -->
  <PropertyGroup Condition="'$(InteropDebug)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_DEBUG</DefineConstants>
  </PropertyGroup>







|







 







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
...
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
  -->
  <PropertyGroup Condition="'$(TrackMemoryBytes)' != 'false'">
    <DefineConstants>$(DefineConstants);TRACK_MEMORY_BYTES</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: For interaction with the native SQLite implementation, use the
            custom built interop DLL (i.e. "SQLite.Interop.DLL")?
  -->
  <PropertyGroup Condition="'$(UseInteropDll)' != 'false'">
    <DefineConstants>$(DefineConstants);USE_INTEROP_DLL</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: For interaction with the native SQLite implementation, use the
................................................................................
      NOTE: Enable support (in the managed assemblies) for encrypted databases
            using SEE?
  -->
  <PropertyGroup Condition="'$(InteropIncludeSee)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_INCLUDE_SEE</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: Enable support (in the managed assemblies) for compressed and
            encrypted databases using CEROD?
  -->
  <PropertyGroup Condition="'$(InteropIncludeCerod)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_INCLUDE_CEROD</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: Enable support (in the managed assemblies) for whatever "extra"
            code (e.g. "extensions") may be included by the custom built
            interop DLL (i.e. "SQLite.Interop.DLL")?
  -->
  <PropertyGroup Condition="'$(InteropIncludeExtra)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_INCLUDE_EXTRA</DefineConstants>
  </PropertyGroup>

  <!--
      NOTE: Enable extra diagnostics from the custom built interop DLL (see the
            "SQLite.NET.Settings.targets" file for more information)?
  -->
  <PropertyGroup Condition="'$(InteropDebug)' != 'false'">
    <DefineConstants>$(DefineConstants);INTEROP_DEBUG</DefineConstants>
  </PropertyGroup>

Changes to Targets/SQLite.NET.Settings.targets.

352
353
354
355
356
357
358



































359
360
361
362
363
364
365

                  "SQLite.Interop\props\SQLite.Interop.20YY.[vs]props"

              both for the corresponding version(s) of Visual Studio.
    -->
    <InteropIncludeSee Condition="'$(InteropIncludeSee)' == ''">false</InteropIncludeSee>




































    <!--
        NOTE: Enable extra diagnostics from the custom built interop DLL (i.e.
              "SQLite.Interop.dll")?  By default, this is enabled in the Debug
              build configuration.  If this is disabled, no extra diagnostics
              will be emitted.  If this is enabled, it must also be enabled via
              the "INTEROP_DEBUG=XX" preprocessor define being present in the
              "INTEROP_DEBUG_DEFINES" macro in the build properties file:







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400

                  "SQLite.Interop\props\SQLite.Interop.20YY.[vs]props"

              both for the corresponding version(s) of Visual Studio.
    -->
    <InteropIncludeSee Condition="'$(InteropIncludeSee)' == ''">false</InteropIncludeSee>

    <!--
        NOTE: Enable including CEROD with the custom built interop DLL (i.e.
              "SQLite.Interop.dll")?  By default, this is disabled.  If this is
              enabled, the "cerod.c" file will be included from the extensions
              directory.  If this is enabled, it must also be enabled via the
              "SQLITE_HAS_CODEC=1" preprocessor define being present in the
              "SQLITE_EXTRA_DEFINES" macro in the build properties file:

                  "SQLite.Interop\props\sqlite3.[vs]props"

              AND via the "INTEROP_INCLUDE_CEROD=1" preprocessor define being
              present in the "INTEROP_EXTRA_DEFINES" macro in the build
              properties file:

                  "SQLite.Interop\props\SQLite.Interop.20YY.[vs]props"

              both for the corresponding version(s) of Visual Studio.
    -->
    <InteropIncludeCerod Condition="'$(InteropIncludeCerod)' == ''">false</InteropIncludeCerod>

    <!--
        NOTE: Enable including "extra" code with the custom built interop DLL
              (i.e. "SQLite.Interop.dll")?  By default, this is disabled.  If
              this is enabled, the "extra.c" file will be included from the
              extensions directory.  If this is enabled, it must also be
              enabled via the "INTEROP_INCLUDE_EXTRA=1" preprocessor define
              being present in the "INTEROP_EXTRA_DEFINES" macro in the build
              properties file:

                  "SQLite.Interop\props\SQLite.Interop.20YY.[vs]props"

              for the corresponding version(s) of Visual Studio.
    -->
    <InteropIncludeExtra Condition="'$(InteropIncludeExtra)' == ''">false</InteropIncludeExtra>

    <!--
        NOTE: Enable extra diagnostics from the custom built interop DLL (i.e.
              "SQLite.Interop.dll")?  By default, this is enabled in the Debug
              build configuration.  If this is disabled, no extra diagnostics
              will be emitted.  If this is enabled, it must also be enabled via
              the "INTEROP_DEBUG=XX" preprocessor define being present in the
              "INTEROP_DEBUG_DEFINES" macro in the build properties file:

Changes to Tests/basic.eagle.

1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
....
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
    set keys [list null Version Synchronous UseUTF16Encoding Pooling \
                   BinaryGUID "Data Source" Uri FullUri "Default Timeout" \
                   Enlist FailIfMissing "Legacy Format" "Read Only" \
                   Password "Page Size" "Max Page Count" "Cache Size" \
                   DateTimeFormat DateTimeKind DateTimeFormatString \
                   BaseSchemaName "Journal Mode" "Default IsolationLevel" \
                   "Foreign Keys" Flags SetDefaults ToFullPath HexPassword \
                   DefaultDbType DefaultTypeName NoSharedFlags]

    set values [list null 3 Normal True False \
                     True test.db test.db file:test.db 60 \
                     False True False True \
                     secret 4096 1024 8192 \
                     UnixEpoch Utc yyyy-MM-dd sqlite_schema \
                     Memory Serializable False \
                     Default False False 736563726574 String \
                     TEXT True]

    set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \
                            BinaryGUID DataSource Uri FullUri DefaultTimeout \
                            Enlist FailIfMissing LegacyFormat ReadOnly \
                            Password PageSize MaxPageCount CacheSize \
                            DateTimeFormat DateTimeKind DateTimeFormatString \
                            BaseSchemaName JournalMode DefaultIsolationLevel \
                            ForeignKeys Flags SetDefaults ToFullPath \
                            HexPassword DefaultDbType DefaultTypeName \
                            NoSharedFlags]

    foreach key $keys value $values propertyName $propertyNames {
      set code [catch {
        object invoke _Dynamic${id}.Test${id} GetConnectionString \
            $key $value $propertyName
      } result]

................................................................................
DateTimeFormatString=yyyy-MM-dd\} 0 \{sqlite_schema,\
BaseSchemaName=sqlite_schema\} 0 \{Memory, Journal Mode=Memory\} 0\
\{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\
Keys=False\} 0 \{(?:Default|LogCallbackException),\
Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\
\{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574} 0\
\{String, DefaultDbType=String\} 0 \{TEXT, DefaultTypeName=TEXT\} 0 \{True,\
NoSharedFlags=True\}$}}

###############################################################################

runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body {
  set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \
      ToDateTime 2455928.0 Utc]








|








|









|







 







|







1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
....
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
    set keys [list null Version Synchronous UseUTF16Encoding Pooling \
                   BinaryGUID "Data Source" Uri FullUri "Default Timeout" \
                   Enlist FailIfMissing "Legacy Format" "Read Only" \
                   Password "Page Size" "Max Page Count" "Cache Size" \
                   DateTimeFormat DateTimeKind DateTimeFormatString \
                   BaseSchemaName "Journal Mode" "Default IsolationLevel" \
                   "Foreign Keys" Flags SetDefaults ToFullPath HexPassword \
                   DefaultDbType DefaultTypeName NoSharedFlags PrepareRetries]

    set values [list null 3 Normal True False \
                     True test.db test.db file:test.db 60 \
                     False True False True \
                     secret 4096 1024 8192 \
                     UnixEpoch Utc yyyy-MM-dd sqlite_schema \
                     Memory Serializable False \
                     Default False False 736563726574 String \
                     TEXT True 20]

    set propertyNames [list null Version SyncMode UseUTF16Encoding Pooling \
                            BinaryGUID DataSource Uri FullUri DefaultTimeout \
                            Enlist FailIfMissing LegacyFormat ReadOnly \
                            Password PageSize MaxPageCount CacheSize \
                            DateTimeFormat DateTimeKind DateTimeFormatString \
                            BaseSchemaName JournalMode DefaultIsolationLevel \
                            ForeignKeys Flags SetDefaults ToFullPath \
                            HexPassword DefaultDbType DefaultTypeName \
                            NoSharedFlags PrepareRetries]

    foreach key $keys value $values propertyName $propertyNames {
      set code [catch {
        object invoke _Dynamic${id}.Test${id} GetConnectionString \
            $key $value $propertyName
      } result]

................................................................................
DateTimeFormatString=yyyy-MM-dd\} 0 \{sqlite_schema,\
BaseSchemaName=sqlite_schema\} 0 \{Memory, Journal Mode=Memory\} 0\
\{Serializable, Default IsolationLevel=Serializable\} 0 \{False, Foreign\
Keys=False\} 0 \{(?:Default|LogCallbackException),\
Flags=(?:Default|LogCallbackException)\} 0 \{False, SetDefaults=False\} 0\
\{False, ToFullPath=False\} 0 {736563726574, HexPassword=736563726574} 0\
\{String, DefaultDbType=String\} 0 \{TEXT, DefaultTypeName=TEXT\} 0 \{True,\
NoSharedFlags=True\} 0 \{20, PrepareRetries=20\}$}}

###############################################################################

runTest {test data-1.18 {SQLiteConvert ToDateTime (Julian Day)} -body {
  set dateTime [object invoke -create System.Data.SQLite.SQLiteConvert \
      ToDateTime 2455928.0 Utc]

Changes to Tests/common.eagle.

3152
3153
3154
3155
3156
3157
3158
3159

3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
        #       are some compile-time options that must also have been enabled
        #       for the interop assembly in order to be effective.  For those
        #       options, it will be assumed that it was enabled for the interop
        #       assembly if it was enabled for the managed assembly.
        #
        foreach defineConstant [list \
            CHECK_STATE COUNT_HANDLE DEBUG INTEROP_CODEC INTEROP_DEBUG \
            INTEROP_EXTENSION_FUNCTIONS INTEROP_INCLUDE_SEE \

            INTEROP_LEGACY_CLOSE INTEROP_LOG INTEROP_TEST_EXTENSION \
            INTEROP_VIRTUAL_TABLE NET_20 NET_35 NET_40 NET_45 NET_451 \
            NET_COMPACT_20 PLATFORM_COMPACTFRAMEWORK PRELOAD_NATIVE_LIBRARY \
            RETARGETABLE SQLITE_STANDARD THROW_ON_DISPOSED TRACE \
            TRACE_CONNECTION TRACE_DETECTION TRACE_HANDLE TRACE_PRELOAD \
            TRACE_SHARED TRACE_STATEMENT TRACE_WARNING TRACK_MEMORY_BYTES \
            USE_ENTITY_FRAMEWORK_6 USE_INTEROP_DLL USE_PREPARE_V2 WINDOWS] {
          #
          # NOTE: Check if the compile-time option is listed in the list of
          #       "define constants" kept track of by the managed assembly.
          #
          checkForSQLiteDefineConstant $::test_channel $defineConstant
        }







|
>
|
|
|
|
|
|







3152
3153
3154
3155
3156
3157
3158
3159
3160
3161
3162
3163
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
        #       are some compile-time options that must also have been enabled
        #       for the interop assembly in order to be effective.  For those
        #       options, it will be assumed that it was enabled for the interop
        #       assembly if it was enabled for the managed assembly.
        #
        foreach defineConstant [list \
            CHECK_STATE COUNT_HANDLE DEBUG INTEROP_CODEC INTEROP_DEBUG \
            INTEROP_EXTENSION_FUNCTIONS INTEROP_INCLUDE_CEROD \
            INTEROP_INCLUDE_EXTRA INTEROP_INCLUDE_SEE INTEROP_LEGACY_CLOSE \
            INTEROP_LOG INTEROP_TEST_EXTENSION INTEROP_VIRTUAL_TABLE NET_20 \
            NET_35 NET_40 NET_45 NET_451 NET_COMPACT_20 \
            PLATFORM_COMPACTFRAMEWORK PRELOAD_NATIVE_LIBRARY RETARGETABLE \
            SQLITE_STANDARD THROW_ON_DISPOSED TRACE TRACE_CONNECTION \
            TRACE_DETECTION TRACE_HANDLE TRACE_PRELOAD TRACE_SHARED \
            TRACE_STATEMENT TRACE_WARNING TRACK_MEMORY_BYTES \
            USE_ENTITY_FRAMEWORK_6 USE_INTEROP_DLL USE_PREPARE_V2 WINDOWS] {
          #
          # NOTE: Check if the compile-time option is listed in the list of
          #       "define constants" kept track of by the managed assembly.
          #
          checkForSQLiteDefineConstant $::test_channel $defineConstant
        }

Added Tests/tkt-647d282d11.eagle.

























































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
###############################################################################
#
# tkt-647d282d11.eagle --
#
# Written by Joe Mistachkin.
# Released to the public domain, use at your own risk!
#
###############################################################################

package require Eagle
package require Eagle.Library
package require Eagle.Test

runTestPrologue

###############################################################################

package require System.Data.SQLite.Test
runSQLiteTestPrologue

###############################################################################

runTest {test tkt-647d282d11-1.1 {Open with PrepareRetries} -setup {
  setupDb [set fileName tkt-647d282d11-1.1.db] "" "" "" "" PrepareRetries=10
} -body {
  set connection [getDbConnection]

  list [object invoke $connection PrepareRetries] \
      [object invoke $connection PrepareRetries 20] \
      [object invoke $connection PrepareRetries]
} -cleanup {
  cleanupDb $fileName

  freeDbConnection

  unset -nocomplain db fileName
} -constraints \
{eagle monoBug28 command.sql compile.DATA SQLite System.Data.SQLite} -result \
{10 {} 20}}

###############################################################################

runSQLiteTestEpilogue
runTestEpilogue

Changes to Tests/version.eagle.

29
30
31
32
33
34
35









36
37
38
39
40
41
42
..
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
...
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
...
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
...
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392

393
394

395
396

397
398
399
400
401
402
403
404
405
406

407
408

409
410

411
412
413
414
415
416
417
418
419
420

421
422

423
424

425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480


481






























482
483
484
485
486
487
488
































489
490
491
492
493
494
495
496
































497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
...
538
539
540
541
542
543
544
545
546




















547
548
549
550
551
552
553
554





















555
556
557
558
559
560
561
...
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862





















863
864
865
866
867
868
869
...
870
871
872
873
874
875
876














877
878
879
880
881
882
883
#       the source code files, the built binaries, and the release packages.
#       The revision number is reserved for NuGet package versioning.
#
set version(major)             1
set version(minor)             0
set version(build)            95; # NOTE: Incremented with each release.
set version(revision)          0










###############################################################################
# ********************* END VOLATILE VERSION INFORMATION **********************
###############################################################################

#
# NOTE: Build the full version number using the components setup above.  This
................................................................................
#
set version(full) [appendArgs $version(major) . $version(minor) . \
                              $version(build) . $version(revision)]

###############################################################################

#
# NOTE: Build the version number used for the NuGet packages.  This should
#       be the same as the above version number, with the exception of the
#       revision, which may differ.
#
set version(nuget) [appendArgs $version(major) . $version(minor) . \
                               $version(build) . \\d+]

###############################################################################

runTest {test version-1.1 {'System.Data.SQLite' binary version} -body {
  file version $systemDataSQLiteDllFile
} -constraints {eagle file_System.Data.SQLite.dll} -result $version(full)}

................................................................................
    [appendArgs &quot\; [format %03d $version(build)] &quot\;]

###############################################################################
# SQLite.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        "\" "]

###############################################################################
# SQLite.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        $version(nuget) "\" "]

###############################################################################
# SQLite.Core.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.Core.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.Core.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.Core.MSIL.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.Core.MSIL.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.Core.MSIL.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]

###############################################################################
# SQLite.EF6.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \

        "\" "]

###############################################################################
# SQLite.EF6.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \

        "\" "]

###############################################################################
# SQLite.EF6.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \

        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \

        "\" "]

###############################################################################
# SQLite.Linq.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.Linq.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.Linq.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*?\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*?\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.MSIL.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \


        </version>]































###############################################################################
# SQLite.MSIL.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
































        </version>]

###############################################################################
# SQLite.MSIL.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
































        </version>]

###############################################################################
# SQLite.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        $version(nuget) "\" "]

###############################################################################
# SQLite.x64.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]





















###############################################################################
# SQLite.x86.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> [string map [list . \\.] $version(nuget)] \
        </version>]






















###############################################################################
# SQLite.Designer/AssemblyInfo.cs
###############################################################################

lappend patterns \
    [appendArgs AssemblyVersion\\(\" [string map [list . \\.] \
................................................................................
    [file join NuGet SQLite.EF6.Beta.nuspec] \
    [file join NuGet SQLite.EF6.Beta.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \





















    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
................................................................................
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \














    [file join NuGet SQLite.x86.nuspec] \
    [file join SQLite.Designer AssemblyInfo.cs] \
    [file join SQLite.Designer AssemblyInfo.cs] \
    [file join SQLite.Designer source.extension.vsixmanifest] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \







>
>
>
>
>
>
>
>
>







 







|
|
|

|
|







 







<
|







 







<
|







 







|
<






|
<






|
<






|
<






|
<






|
<






<
|
|
>
|
|
>
|
|
>
|






<
|
|
>
|
|
>
|
|
>
|






<
|
|
>
|
|
>
|
|
>
|






|
<
<
<
<
<
<
<
<
<






|
<
<
<
<
<
<
<
<
<






|
<
<
<
<
<
<
<
<
<






|
>
>
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>






|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|






|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|






<
|







 







|
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>






|
<
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







 







|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







 







>
>
>
>
>
>
>
>
>
>
>
>
>
>







29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
..
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
...
262
263
264
265
266
267
268

269
270
271
272
273
274
275
276
...
302
303
304
305
306
307
308

309
310
311
312
313
314
315
316
...
342
343
344
345
346
347
348
349

350
351
352
353
354
355
356

357
358
359
360
361
362
363

364
365
366
367
368
369
370

371
372
373
374
375
376
377

378
379
380
381
382
383
384

385
386
387
388
389
390

391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406

407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422

423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439









440
441
442
443
444
445
446









447
448
449
450
451
452
453









454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579

580
581
582
583
584
585
586
587
...
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648

649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
...
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
....
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
#       the source code files, the built binaries, and the release packages.
#       The revision number is reserved for NuGet package versioning.
#
set version(major)             1
set version(minor)             0
set version(build)            95; # NOTE: Incremented with each release.
set version(revision)          0

###############################################################################

#
# NOTE: What is the full version of the EntityFramework NuGet package (which
#       is not [necessarily] the same version as the assembly itself) in use
#       by the System.Data.SQLite NuGet packages?
#
set version(ef6) 6.1.2.0

###############################################################################
# ********************* END VOLATILE VERSION INFORMATION **********************
###############################################################################

#
# NOTE: Build the full version number using the components setup above.  This
................................................................................
#
set version(full) [appendArgs $version(major) . $version(minor) . \
                              $version(build) . $version(revision)]

###############################################################################

#
# NOTE: Build the version number regular expression used for the NuGet
#       packages.  This should be the same as the above version number,
#       with the exception of the revision, which may differ.
#
set version(nuget) [appendArgs $version(major) \\. $version(minor) \\. \
                               $version(build) \\. \\d+]

###############################################################################

runTest {test version-1.1 {'System.Data.SQLite' binary version} -body {
  file version $systemDataSQLiteDllFile
} -constraints {eagle file_System.Data.SQLite.dll} -result $version(full)}

................................................................................
    [appendArgs &quot\; [format %03d $version(build)] &quot\;]

###############################################################################
# SQLite.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        "\" "]

###############################################################################
# SQLite.Beta.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        $version(nuget) "\" "]

###############################################################################
# SQLite.Core.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.Core.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.Core.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.Core.MSIL.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.Core.MSIL.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.Core.MSIL.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]


###############################################################################
# SQLite.EF6.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "]

###############################################################################
# SQLite.EF6.Beta.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "]

###############################################################################
# SQLite.EF6.Test.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"EntityFramework\" version=\"" [string map [list . \\.] \
        $version(ef6)] "\" "]

###############################################################################
# SQLite.Linq.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]










###############################################################################
# SQLite.Linq.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]










###############################################################################
# SQLite.Linq.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>]










###############################################################################
# SQLite.MSIL.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.MSIL.Beta.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Beta\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Beta\" version=\"" \
        $version(nuget) "\" "]

###############################################################################
# SQLite.MSIL.Test.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.MSIL\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\\.Test\" version=\"" \
        $version(nuget) "\" "]

###############################################################################
# SQLite.Test.nuspec
###############################################################################

lappend patterns \

    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Core\\.Test\" version=\"" \
        $version(nuget) "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
................................................................................
        $version(nuget) "\" "]

###############################################################################
# SQLite.x64.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>] \
    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.x86.nuspec
###############################################################################

lappend patterns \
    [appendArgs <version> $version(nuget) </version>] \

    [appendArgs " targetFramework=\"net20\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.Linq\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net40\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net45\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "] \
    [appendArgs " targetFramework=\"net451\".*? " \
        "id=\"System\\.Data\\.SQLite\\.EF6\" version=\"" $version(nuget) \
        "\" "]

###############################################################################
# SQLite.Designer/AssemblyInfo.cs
###############################################################################

lappend patterns \
    [appendArgs AssemblyVersion\\(\" [string map [list . \\.] \
................................................................................
    [file join NuGet SQLite.EF6.Beta.nuspec] \
    [file join NuGet SQLite.EF6.Beta.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.EF6.Test.nuspec] \
    [file join NuGet SQLite.Linq.nuspec] \
    [file join NuGet SQLite.Linq.Beta.nuspec] \
    [file join NuGet SQLite.Linq.Test.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Beta.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.MSIL.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
................................................................................
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.Test.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x64.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join NuGet SQLite.x86.nuspec] \
    [file join SQLite.Designer AssemblyInfo.cs] \
    [file join SQLite.Designer AssemblyInfo.cs] \
    [file join SQLite.Designer source.extension.vsixmanifest] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \
    [file join SQLite.Interop props SQLite.Interop.2005.vsprops] \

Changes to readme.htm.

211
212
213
214
215
216
217



218
219
220
221
222
223
224
...
225
226
227
228
229
230
231

232
233
234
235
236
237
238
<p>
    <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li>
    <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li>
    <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for [2be4298631], [abad7c577d], and [417d669435].</li>



    <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
    <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li>
    <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li>
    <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
    <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
    <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
    <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
    <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
    <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88].&nbsp;<b>** Potentially Incompatible Change **</b></li>

</ul>
<p>
    <b>1.0.94.0 - September 9, 2014</b>
</p>
<ul>
    <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li>
    <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li>







>
>
>







 







>







211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
...
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
<p>
    <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_8_2.html">SQLite 3.8.8.2</a>.</li>
    <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.2">Entity Framework 6.1.2</a>.</li>
    <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for [2be4298631], [abad7c577d], and [417d669435].</li>
    <li>The &quot;System.Data.SQLite.EF6*&quot; and &quot;System.Data.SQLite.Linq*&quot; NuGet packages no longer depend on the &quot;System.Data.SQLite.Core*&quot; packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>The &quot;System.Data.SQLite.MSIL*&quot; NuGet packages no longer directly include any files; they are now meta-packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>The &quot;System.Data.SQLite.x86*&quot; and &quot;System.Data.SQLite.x64*&quot; NuGet packages now depend on the &quot;System.Data.SQLite.Linq&quot; and &quot;System.Data.SQLite.EF6&quot; NuGet packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
    <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li>
    <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li>
    <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
    <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
    <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity. Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
    <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
    <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
    <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add PrepareRetries connection string property to allow the maximum number of retries when preparing a query to be overridden. Fix for [647d282d11].</li>
</ul>
<p>
    <b>1.0.94.0 - September 9, 2014</b>
</p>
<ul>
    <li>Updated to <a href="https://www.sqlite.org/releaselog/3_8_6.html">SQLite 3.8.6</a>.</li>
    <li>Updated to <a href="https://www.nuget.org/packages/EntityFramework/6.1.1">Entity Framework 6.1.1</a>.</li>

Changes to test/TestCases.cs.

78
79
80
81
82
83
84
85
86

87
88
89
90
91
92
93
    internal void CheckSQLite()
    {
      if (_fact.GetType().Name.IndexOf("SQLite", StringComparison.OrdinalIgnoreCase) == -1)
        throw new InconclusiveException("Not a SQLite database");
    }

/*
 * NOTE: Using SEE for this particular test case is unsupported because we have
 *       no easy way of executing the necessary SQL beforehand.

 */

#if INTEROP_CODEC // || INTEROP_INCLUDE_SEE
    /// <summary>
    /// Tests changing password on an encrypted database.
    /// </summary>
    [Test]







|
|
>







78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
    internal void CheckSQLite()
    {
      if (_fact.GetType().Name.IndexOf("SQLite", StringComparison.OrdinalIgnoreCase) == -1)
        throw new InconclusiveException("Not a SQLite database");
    }

/*
 * NOTE: Using SEE for this particular test case is currently unsupported
 *       because we have no easy way of executing the SQL beforehand that
 *       is needed to set it up.
 */

#if INTEROP_CODEC // || INTEROP_INCLUDE_SEE
    /// <summary>
    /// Tests changing password on an encrypted database.
    /// </summary>
    [Test]

Changes to www/downloads.wiki.

1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
....
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
....
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042







2043
2044
2045
2046
2047
2048
2049
....
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
....
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097
      </td>
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support Entity
        Framework 6 using System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET
        Framework 4.0, 4.5, or 4.5.1 is required.
        <br />
        <big><b>This package depends on both the
        &quot;System.Data.SQLite.Core&quot; and &quot;EntityFramework&quot;
        packages.</b></big>
        <br />
        (sha1: 38a123d32d8f6ed3d56b4915394c3207526e7637)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
      </td>
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support LINQ using
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1, 4.0,
        4.5, or 4.5.1 is required.
        <br />
        <big><b>This package depends on the &quot;System.Data.SQLite.Core&quot;
        package.</b></big>
        <br />
        (sha1: 8984abae64ec2a49641a6ba15dc80ef60838ca98)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains the managed binaries for System.Data.SQLite
        1.0.95.0.  The .NET Framework 3.5 SP1, 4.0, 4.5, or 4.5.1 is required.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;
        package instead.  This package depends on the &quot;EntityFramework&quot;
        package.</b></big>
        <br />
        <br />
        <big><b><i>This NuGet package does not include any code from the native
        SQLite core library and will not work properly without the native
        assembly &quot;SQLite.Interop.dll&quot; compiled for the processor
        architecture of the host process being present in a directory in the
        native library search path.</i></b></big>
        <br />







        <br />
        (sha1: d3d5abdde0f39e244432ec8ae2084a51ea9cd9ef)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1,
        4.0, 4.5, or 4.5.1 is required.  For the included native binaries, the
        version of the Visual C++ runtime corresponding to the .NET Framework
        used by the associated managed assembly is statically linked.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;
        package instead.  This package depends on the &quot;EntityFramework&quot;
        package.</b></big>
        <br />
        (sha1: 63cee7bb755c5e411fa12ac16241efb03982fb28)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1,
        4.0, 4.5, or 4.5.1 is required.  For the included native binaries, the
        version of the Visual C++ runtime corresponding to the .NET Framework
        used by the associated managed assembly is statically linked.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;
        package instead.  This package depends on the
        &quot;EntityFramework&quot; package.</b></big>
        <br />
        (sha1: 4d8e58bd75a7b0cb831f417ca6926d8868d523b8)
      </td>
    </tr>

    <tr>
      <td colspan="4">







|
<
|







 







|
<







 







<
|








>
>
>
>
>
>
>







 







<
|







 







|
<







1984
1985
1986
1987
1988
1989
1990
1991

1992
1993
1994
1995
1996
1997
1998
1999
....
2004
2005
2006
2007
2008
2009
2010
2011

2012
2013
2014
2015
2016
2017
2018
....
2024
2025
2026
2027
2028
2029
2030

2031
2032
2033
2034
2035
2036
2037
2038
2039
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
....
2062
2063
2064
2065
2066
2067
2068

2069
2070
2071
2072
2073
2074
2075
2076
....
2085
2086
2087
2088
2089
2090
2091
2092

2093
2094
2095
2096
2097
2098
2099
      </td>
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support Entity
        Framework 6 using System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET
        Framework 4.0, 4.5, or 4.5.1 is required.
        <br />
        <big><b>This package depends on the &quot;EntityFramework&quot;

        package.</b></big>
        <br />
        (sha1: 38a123d32d8f6ed3d56b4915394c3207526e7637)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
      </td>
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains just the binaries to support LINQ using
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1, 4.0,
        4.5, or 4.5.1 is required.
        <br />
        <big><b>This package does not depend on any other package.</b></big>

        <br />
        (sha1: 8984abae64ec2a49641a6ba15dc80ef60838ca98)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
      <td width="5"></td>
      <td valign="top">
        This NuGet package contains the managed binaries for System.Data.SQLite
        1.0.95.0.  The .NET Framework 3.5 SP1, 4.0, 4.5, or 4.5.1 is required.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;

        package instead.</b></big>
        <br />
        <br />
        <big><b><i>This NuGet package does not include any code from the native
        SQLite core library and will not work properly without the native
        assembly &quot;SQLite.Interop.dll&quot; compiled for the processor
        architecture of the host process being present in a directory in the
        native library search path.</i></b></big>
        <br />
        <br />
        <big><b><i>As of version 1.0.95.0, this package will not directly
        contain any of the required binaries. Instead, this package will
        depend on the &quot;System.Data.SQLite.Core.MSIL&quot;,
        &quot;System.Data.SQLite.Linq&quot;, and
        &quot;System.Data.SQLite.EF6&quot; packages.</i></b></big>
        <br />
        <br />
        (sha1: d3d5abdde0f39e244432ec8ae2084a51ea9cd9ef)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1,
        4.0, 4.5, or 4.5.1 is required.  For the included native binaries, the
        version of the Visual C++ runtime corresponding to the .NET Framework
        used by the associated managed assembly is statically linked.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;

        package instead.</b></big>
        <br />
        (sha1: 63cee7bb755c5e411fa12ac16241efb03982fb28)
      </td>
    </tr>

    <tr>
      <td width="10">&nbsp;</td>
................................................................................
        System.Data.SQLite 1.0.95.0 (3.8.8.2).  The .NET Framework 3.5 SP1,
        4.0, 4.5, or 4.5.1 is required.  For the included native binaries, the
        version of the Visual C++ runtime corresponding to the .NET Framework
        used by the associated managed assembly is statically linked.
        <br />
        <big><b>This is a legacy package; if possible, please use either the
        &quot;System.Data.SQLite&quot; or &quot;System.Data.SQLite.Core&quot;
        package instead.</b></big>

        <br />
        (sha1: 4d8e58bd75a7b0cb831f417ca6926d8868d523b8)
      </td>
    </tr>

    <tr>
      <td colspan="4">

Changes to www/news.wiki.

5
6
7
8
9
10
11



12
13
14
15
16
17
18
..
19
20
21
22
23
24
25

26
27
28
29
30
31
32
<p>
    <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to [https://www.sqlite.org/releaselog/3_8_8_2.html|SQLite 3.8.8.2].</li>
    <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.2|Entity Framework 6.1.2].</li>
    <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for [2be4298631], [abad7c577d], and [417d669435].</li>



    <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
    <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li>
    <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li>
    <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
    <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
    <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity.  Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
    <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
    <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
    <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88].&nbsp;<b>** Potentially Incompatible Change **</b></li>

</ul>
<p>
    <b>1.0.94.0 - September 9, 2014</b>
</p>
<ul>
    <li>Updated to [https://www.sqlite.org/releaselog/3_8_6.html|SQLite 3.8.6].</li>
    <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.1|Entity Framework 6.1.1].</li>







>
>
>







 







>







5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
..
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<p>
    <b>1.0.95.0 - February XX, 2015 <font color="red">(release scheduled)</font></b>
</p>
<ul>
    <li>Updated to [https://www.sqlite.org/releaselog/3_8_8_2.html|SQLite 3.8.8.2].</li>
    <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.2|Entity Framework 6.1.2].</li>
    <li>Modify configuration file transforms performed by the NuGet packages to allow Entity Framework 6 design-time integration to work automatically. Fix for [2be4298631], [abad7c577d], and [417d669435].</li>
    <li>The &quot;System.Data.SQLite.EF6*&quot; and &quot;System.Data.SQLite.Linq*&quot; NuGet packages no longer depend on the &quot;System.Data.SQLite.Core*&quot; packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>The &quot;System.Data.SQLite.MSIL*&quot; NuGet packages no longer directly include any files; they are now meta-packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>The &quot;System.Data.SQLite.x86*&quot; and &quot;System.Data.SQLite.x64*&quot; NuGet packages now depend on the &quot;System.Data.SQLite.Linq&quot; and &quot;System.Data.SQLite.EF6&quot; NuGet packages.&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure SQL statements generated for DbUpdateCommandTree objects are properly delimited.</li>
    <li>Make sure SQLiteIndexOutputs.ConstraintUsages instances are created prior to calling ISQLiteManagedModule.BestIndex. Fix for [56f511d268].</li>
    <li>Correct marshalling of strings and blobs in the SQLiteValue class. Fix for [85b824b736].</li>
    <li>Various minor performance enhancements to the SQLiteDataReader class. Pursuant to [e122d26e70].</li>
    <li>Defer disposing of connections created by the static SQLiteCommand.Execute method when a data reader is returned. Fix for [daeaf3150a].</li>
    <li>Wrap SELECT statements in parenthesis if they have an ORDER BY, LIMIT, or OFFSET clause and a compound operator is involved. Fix for [0a32885109].</li>
    <li>In the SQLiteDataReader.VerifyType method, remove duplicate &quot;if&quot; statement for the DbType.SByte value and move the remaining &quot;if&quot; to the Int64 affinity.  Fix for [c5cc2fb334].&nbsp;<b>** Potentially Incompatible Change **</b></li>
................................................................................
    <li>Handle Julian Day values that fall outside of the supported range for OLE Automation dates. Fix for [3e783eecbe].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied when publishing a project that refers to a NuGet package containing them. Fix for [e796ac82c1].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Make sure the interop files are copied before the PostBuildEvent. Fix for [f16c93a932].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Modify GetSchemaTable method to avoid setting SchemaTableColumn.IsKey column to true when more than one table is referenced. Fix for [47c6fa04d3].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add AppendManifestToken_SQLiteProviderManifest environment variable to enable better integration between LINQ and the underlying store connection.</li>
    <li>Add SQLite_ForceLogPrepare environment variable to force logging of all prepared SQL regardless of the flags for the associated connection.</li>
    <li>Honor the DateTimeFormat, DateTimeKind, DateTimeFormatString, BinaryGUID connection string and/or provider manifest token properties from within the LINQ assembly. Fix for [8d928c3e88].&nbsp;<b>** Potentially Incompatible Change **</b></li>
    <li>Add PrepareRetries connection string property to allow the maximum number of retries when preparing a query to be overridden. Fix for [647d282d11].</li>
</ul>
<p>
    <b>1.0.94.0 - September 9, 2014</b>
</p>
<ul>
    <li>Updated to [https://www.sqlite.org/releaselog/3_8_6.html|SQLite 3.8.6].</li>
    <li>Updated to [https://www.nuget.org/packages/EntityFramework/6.1.1|Entity Framework 6.1.1].</li>