I want to use C# (winform) to read an SQLCipher database and find an open source project SQLitePCL, but I have not found examples of this use, and the documentation is not a lot. Have any friends used this thing, can you provide some examples to help me?
Thank you!
This will work for winforms, wpf, asp.net, xamarin.android, xamarin.ios, UWP and any other .net project since this is a cross-platform library:
Install nuget by Frank A. Krueger "sqlite-net-pcl".
Use tutorial from his github page.
Now, once we have database and all the stuff. How to encrypt newly created database or open encrypted database?
Add nuget by Eric Sink: "SQLitePCLRaw.bundle_sqlcipher"
In the code, where you create SQLiteConnection specify encryption key:
connection = new SQLiteConnection(dbPath, openFlags: SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.FullMutex | SQLiteOpenFlags.Create);
connection.Query<int>("PRAGMA key=xzy1921");
That's it. The rest will work as if it was not crypted.
