I'm trying to make a copy of an existing datbase file to my memory.
The original database file is encrypted, I want to copy it to my memory to decrypt it there, insert or read the data i need, encrypt it again and overwrite the original database file. This because if the app crashes you won't be able to see any un-encrypted data. (maybe there is a better way, if you have one please tell me because i couldn't think of one.)
My code so far:
var dbName = "Dlgtest.db3"; var something = System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments); var path = System.IO.Path.Combine(something, dbName); var conn = new SQLiteConnection(path); var connection = new SQLiteConnection(":memory:");
I know you can use SQLCipher to encrypt the file, but they don't support UWP which i need.
Is there a way to write from the var conn to the var connection?