Last post Sep 23, 2019 02:11 PM by bruce (sqlwork.com)
Aug 15, 2019 02:46 AM|chriscsie|LINK
I have an ASP.Net core (3.0.100-preview6-012264) project need to access password protected SQLite database that was encrypted by DB Browser for SQLCipher.
I followed the steps of the link below, use Microsoft.EntityFrameworkCore.Sqlite.Core and SQLitePCLRaw.bundle_sqlcipher package
I also followed its reference, use Microsoft.Data.Sqlite package
they didn't work!!
How could I access this password protected SQLite which encrypted by DB Browser for SQLCipher?
Aug 15, 2019 09:12 AM|maherjendoubi|LINK
This example that you mention is using .Net Core 2.0 with EFCore 2.0 whereas you are using .NET Core 3 Preview 6.
I see a lot of compatibilty issues.
Aug 16, 2019 02:55 AM|chriscsie|LINK
I am developing a project using .Net Core 3 in Linux
I wanna encrypt or decrypt a SQLite database but there is no any reference about the encryption / decryption of SQLite using .Net Core 3
Is EFCore 3 preview 6 has capability to access password protected SQLite database that was encrypted by DB Browser for SQLCipher?
Sep 23, 2019 04:46 AM|Rena Ni|LINK
they didn't work!!
What does this sentence mean?Did you make any errors?I suggest that you could share a simple demo which could reproduce your issue.
Sep 23, 2019 11:32 AM|PatriceSc|LINK
According to https://www.connectionstrings.com/sqlite-net-provider/with-password/ you
can add the db password as part of the connection string. If "it doesn't work" and as pointed already tell rather which error message you have so that we can better understand the problem which in turn make easier to investigate and fix it (without having
to guess first what you tried and which problem you ran into).
Sep 23, 2019 02:11 PM|bruce (sqlwork.com)|LINK
EFCore does not have direct support for SQLCipher. The support is supplied by the SQLitePCLRaw bundle. see:
if you believe you are using it correctly, check its issues.