Can i use encrypt/decrypt SQLite in MvvmCross

0
votes

Give me the way, how i can encrypt/decrypt SQLite with MvvmCross, please.

I'm writing the app on Xamarin for two platforms, iOS and Android. And i'm using MvvmCross in the project.

I'm so confused.

The better way is SQLitePCL.raw with sqlcipher, i guess. But i don't know how exactly combine sqlcipher with SQLitePCL.raw. I can use some SQLitePCL.plugins.* for adding "sqlcipher provider" to each platform, but how it use on C# level? How i can set PRAGMA key into my C# code, for example?

1
sqliteencryptionxamarinmvvmcrosssqlcipher
There are Components for SQLite encryption: components.xamarin.com/view/sqlcipher-for-xamarin-ios and components.xamarin.com/gettingstarted/… - Sven-Michael Stübe
@Sven-MichaelStübe Yeah, i saw. Do you know some free packages / ways? - Denis Gordin
I've once created a binding for the android community edition for a stackoverflow answer: github.com/smstuebe/xamarin-sqlcipher - Sven-Michael Stübe
@Sven-MichaelStübe Thanks! I'll see - Denis Gordin

1 Answers

1
votes

For me the answer was to use that scheme.

For Core project I used next packages:

SQLitePCLRaw.core
SQLitePCLRaw.bundle_sqlchipher

For iOS project:

SQLitePCLRaw.core
SQLitePCLRaw.bundle_sqlchipher
SQLitePCLRaw.lib.sqlcipher.ios_unified.static
SQLitePCLRaw.provider.internal.ios_unified

And for Android project:

SQLitePCLRaw.core
SQLitePCLRaw.bundle_sqlcipher
SQLitePCLRaw.lib.sqlcipher.android
SQLitePCLRaw.provider.sqlcipher.android

Before you will try to use any method from SQLitePCLRaw packages you need setup provider. For that you just have to input one line of code: 

SQLitePCL.Batteries.Init();

More information about SQLitePCLRaw packages on github