The password issuses by opening Sqlite.db files by sqlitebrowser or sqlite-net

[BoydenYubin]

（1）Encrypt the db file by using the sqlitebrowser

I have checked the logic of sqlitebrowser to encrypt the db file as below.

db.executeSQL("ATTACH DATABASE 'temp.db' AS sqlitebrowser_edit_encryption KEY 'password';");
db.executeSQL("PRAGMA sqlitebrowser_edit_encryption.cipher_page_size = 1024");
db.executeSQL("PRAGMA sqlitebrowser_edit_encryption.cipher_hmac_algorithm = HMAC_SHA1;"; 
db.executeSQL("PRAGMA sqlitebrowser_edit_encryption.cipher_kdf_algorithm = PBKDF2_HMAC_SHA1;");
db.executeSQL("PRAGMA sqlitebrowser_edit_encryption.kdf_iter = 64000;");
db.executeSQL("PRAGMA sqlitebrowser_edit_encryption.cipher_plaintext_header_size = 0;");
db.executeSQL("SELECT sqlcipher_export('sqlitebrowser_edit_encryption');");
db.executeSQL("DETACH sqlitebrowser_edit_encryption;");

This object db is encrypted by sqlitebrowser with password password, and every time it was open by above steps the temp db file will be built ans then exchage the file. You could check the original link as sqlitebrowser check link 3341.

（2）Decrypt the db file by using the sqlite-net

When I try to use above steps to open the db files by using sqlite-net, it will show not an error. By the way, I used the sqlitecipher instead of standard sqlite.dll. And realize the sqlitecipher API as API defination.

var options = new SQLiteConnectionString(databasePath: "test.db", 
    storeDateTimeAsTicks:true, 
    openFlags: SQLiteOpenFlags.ReadWrite | SQLiteOpenFlags.Create,
    preKeyAction: db =>
    {
        //db.Execute("PRAGMA key = 'password';"); // it can't be excuted
        db.Key("admin");
        db.Execute($"ATTACH DATABASE '{tempfile}' AS sqlitebrowser_edit_encryption KEY 'password';"); //display 'not an error'
        db.Execute("PRAGMA sqlitebrowser_edit_encryption.cipher_plaintext_header_size = 0;");
        db.Execute("PRAGMA sqlitebrowser_edit_encryption.cipher_page_size = 1024;");
        db.Execute("PRAGMA sqlitebrowser_edit_encryption.cipher_kdf_algorithm = PBKDF2_HMAC_SHA1;");   //;
        db.Execute("PRAGMA sqlitebrowser_edit_encryption.kdf_iter = '64000';");
        db.Execute("PRAGMA sqlitebrowser_edit_encryption.cipher_default_hmac_algorithm = HMAC_SHA1;");
        db.Execute("SELECT sqlcipher_export('sqlitebrowser_edit_encryption');");
        db.Execute("DETACH sqlitebrowser_edit_encryption;");
    }
    );
var encryptedDb = new SQLiteConnection(options);
// next step the exexute  sql

（3）Decrypt the db file by using the sqlcipher

And I have tried the sqlciper way on Ubuntu, it works if we used above steps.

So any other mistake sqlite-net deal with the pre-action? Thanks for your feedback if no bother.