System.Data.SQLite with SSE (or other encryption)
(1) By ivan83 (igolovic) on 2021-08-25 10:32:50 [link] [source]
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 18.104.22.168, 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)?
(2) By mistachkin on 2021-08-25 22:18:24 in reply to 1 [link] [source]
SEE is supported in the latest NuGet packages.
(3) By ivan83 (igolovic) on 2021-08-26 11:43:37 in reply to 2 [link] [source]
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] [source]
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 [source]
Yes; however, there is no longer a need to recompile System.Data.SQLite.