System.Data.SQLite with SSE (or other encryption)
(1) By ivan83 (igolovic) on 2021-08-25 10:32:50
Hi, will there be a support for SSE (1) in any future version of System.Data.SQLite ? In a commercial project we are using System.Data.SQLite in a C#/WPF Windows desktop application and sqlite databases are encrypted using now unsupported method (since version 188.8.131.52, when in SQLite SQLITE_HAS_CODEC was removed). We are also using System.Data.SQLite.EF6 because we use Entity Framework. I saw that Microsoft.Data.Sqlite (2) already contains support for encryption libraries (SQLCipher is mentioned). Will there be anything similar in System.Data.SQLite for SSE (or any other encryption library)? Thanks. (1) http://www.hwaci.com/sw/sqlite/see.html) (2) https://docs.microsoft.com/en-us/dotnet/standard/data/sqlite/encryption?tabs=netcore-cli)
(2) By mistachkin on 2021-08-25 22:18:24 in reply to 1 [link]
SEE is supported in the latest NuGet packages.
(3) By ivan83 (igolovic) on 2021-08-26 11:43:37 in reply to 2 [link]
Thank you. Are there any tutorials/demos/examples/documentation on how to create a .NET application, or connect to it, a System.Data.Sqlite package with SEE binary (which by itself, I believe, is a native binary, and it should be integrated with managed System.Data.Sqlite package)? It would be the best option for us to keep original System.Data.Sqlite package but we have a pressing need to connect it with encrypted Sqlite database - and we would prefer to use SEE. Any information is much appreciated.
(4) By ivan83 (igolovic) on 2021-08-26 11:51:50 in reply to 2 [link]
Sorry, wrong word formulation - are there any tutorials on how to integrate SEE (once you buy it and compile it) into a .NET application which uses System.Data.Sqlite ?
(5) By mistachkin on 2021-08-27 17:09:11 in reply to 4 [link]
Yes; however, there is no longer a need to recompile System.Data.SQLite.