JSON support for .NET Framework v. 4.6 (v. 3.38.02)

(1) By BeeMobile on 2022-04-26 14:55:21 [source]

Does anyone know, please, if there is a build of v. 3.38.02 for .NET Framework available for download in binary format? Currently, I am only able to download sqlite3.dll, but that is not used on .NET Framework v. 4.6. .NET Framework uses SQLite.Interop.XXX.dll in conjunction with System.Data.SQLite.dll.

The downloads for .NET F v. 4.6 seem to be available here: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

However, these are rather old versions and don't contain support for JSON.

If anyone has it build and could share a link, I'd appreciate it greatly.

Thank you.

Best regards Vladimir Gregor

(2) By anonymous on 2022-05-01 10:14:27 in reply to 1 [link] [source]

Hello Sir, I downloaded the latest the source code and selected the solution of \sqlite-netFx-full-source-1.0.115.5\SQLite.NET.2015.sln to rebuild.

And I added one line code of #define INTEROP_JSON1_EXTENSION in the file of SQLiteDefineConstants.cs.

I hoped that I will be succeed. However, it is a pity that the following exception is also given when I use the new built library of System.Data.SQLite.dll.

SQL logic error no such function: json_object

Now I have to give up.

I don't know whether my method is right, because I don't seek any available methods. Of cause, you can tell the right method, including detailed steps if you know, and I would rather to try it again.

On the other hand, I hope the team can provide one solution in detailed to rebuild to open JSON function.

Thanks very much for your help.