859 questions
How to access an encrypted sqlite database?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sarah
186
Reputation points
I have developed a WPF app (Net5.0). For the app I used SQLite Database to store the data. The database is encrypted with a password using sqlcipher. To connect to the database in VS I use the package "System.Data.SQLite Version 1.0.115.5".
Does anyone know how to decrypt the database in Visual Studio so that the data can be accessed (the password used for encryption is known)?
Developer technologies XAML
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 11%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Hui Liu-MSFT 48,676 Reputation points Microsoft External Staff2022-06-17T08:49:40.887+00:00 -
Sarah 186 Reputation points
2022-06-17T10:49:21.773+00:00 Hi @Hui Liu-MSFT , I have tried the method but I get the following error/ execption:
System.TypeInitializationException: 'The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.'
TargetInvocationException: Exception has been thrown by the target of an invocation.
MissingMethodException: Method not found: 'Int32 SQLitePCL.ISQLite3Provider.sqlite3_win32_set_directory(Int32, System.String)'.
To use the method I have installed the package:
- SQLitePCLRaw.bundle_sqlcipher, Version 1.1.14
- Microsoft.Data.Sqlite.Core, Version 6.0.6
Sign in to comment
Sign in to answer