SQLite User Forum

Building System.Data.SQLite, possibly with new SQLite version
Login

Building System.Data.SQLite, possibly with new SQLite version

(1.2) Originally by Aask (AAsk1902) with edits by Larry Brasfield (larrybr) on 2024-05-12 17:53:38 from 1.1 [source]

[Edited by moderator to provide a thread title useful to others.]

  1. I downloaded the source from here.

  2. Extracted the file from the ZIP

  3. Launched SQLite.NET.2017.MSBuild.sln

  4. Using Build | Batch Build, I de-selected the Installer and test* builds.

I have

========== Rebuild All: 24 succeeded, 0 failed, 0 skipped ==========

I am perplexed because (I do not know how this project is put together) I do not know what .... 24 succeeded ... I have built.1

a. Do you have any guidance that will enable me to make more sense of the (my) build(s)?

b. Is there a way I can replace the version of SQLite? (The source code is for SDS 1.0.118.0 which is tied to SQLite version 3.42).

1 I am only interested in Precompiled Statically-Linked Binaries for 32- and 64- bit Windows (.NET Framework 4.6) (as on the download page) but would like to use Framework 4.8 and the latest (or any recent) version of SQLite.

(2.1) By Chris Locke (chrisjlocke1) on 2024-05-12 10:38:13 edited from 2.0 in reply to 1.1 [link] [source]

Is your configuration 'debug' or 'release' ?

Whats in the bin\debug or bin\release directory?

(3) By mistachkin on 2024-05-12 15:38:57 in reply to 1.1 [link] [source]

Are you running into any specific issues?

(4.6) By Aask (AAsk1902) on 2024-05-12 16:38:03 edited from 4.5 in reply to 3 [link] [source]

Are you running into any specific issues?

None yet but I am still testing.

I'd like to know:

b. Is there a way I can replace the version of SQLite? (The source code is for SDS 1.0.118.0 which is tied to SQLite version 3.42).That is, use/compile with a later version, say, 3.45.3 or 3.46.0?

The reason for my other question is

i. I have several System.Data.SQLite.DLL and SQLite.Interop.dll

ii. The size of System.Data.SQLite.DLL in my compilations do not match the size of the pre-compiled DLL that I downloaded, namely, 1,799,168 bytes

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\ReleaseNativeOnly
12/05/2024  10:39         1,660,416 SQLite.Interop.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\Release
12/05/2024  10:41         1,795,072 System.Data.SQLite.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\DebugNativeOnly
12/05/2024  10:41         3,234,816 SQLite.Interop.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\Debug
12/05/2024  10:42         3,671,552 System.Data.SQLite.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\ReleaseNativeOnlyStatic
12/05/2024  10:43         1,806,848 SQLite.Interop.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\ReleaseStatic
12/05/2024  10:45         1,940,480 System.Data.SQLite.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\DebugNativeOnlyStatic
12/05/2024  10:46         3,676,672 SQLite.Interop.dll

 Directory of G:\Build_SQLiteSDS\bin\2017\x64\DebugStatic
12/05/2024  10:48         4,113,408 System.Data.SQLite.dll

Which one of the above corresponds to the pre-compiled version?