Microsoft.Data.Sqlite can support sqlcipher key options ?

[IOL0ol1]

i can use Microsoft.Data.Sqlite.Core 5.0.0-preview.6.20312.4
and SQLitePCLRaw.bundle_e_sqlcipher 2.0.3
to create a sqlcipher database file with custom sqlcipher key options.
but i can't open it.

I think it's because the sql query is used in SqliteConnection.Open code here

sqlcipher key options need after sqlite3_open_v2 but before other sql query.

my code like this:

       public void ChangeKeyOptionTest()
        {
            try
            {
                string db = "sqlcipher4.db";
                string pwd = "password";
                // delete db file
                if (File.Exists(db)) File.Delete(db);
                // create sqlcipher database
                CreateOrOpenSqlcipher(db, pwd);
                // open sqlcipher database
                CreateOrOpenSqlcipher(db, pwd);
            }
            catch (Exception ex)
            {
                Trace.WriteLine($"{ex}");
            }

        }

        public void CreateOrOpenSqlcipher(string db, string pwd)
        {
            using (var conection = new SqliteConnection($"DataSource='{db}';Password='{pwd}'"))
            {
                conection.Open();
                using (var cmd = conection.CreateCommand())
                {
                    // change sqlcipher key options
                    cmd.CommandText = "PRAGMA cipher_memory_security = OFF;";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "PRAGMA kdf_iter = '10000';";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "PRAGMA cipher_page_size = 8192;";
                    cmd.ExecuteNonQuery();
                    //create table make db file is not zero size
                    cmd.CommandText = "CREATE TABLE [t_data]([c_id] INTEGER PRIMARY KEY);";
                    cmd.ExecuteNonQuery();
                }
            }
        }

maybe we can add action in SqliteConnectionStringBuilder, like

Action<SqliteConnection> BeforeOpen
Action<SqliteConnection> AfterOpen

and invoke in SqliteConnection.Open.

[ajcvickers]

Putting this on the backlog to consider making it easier to send custom pragmas in this case. For now the way to do this is to send the pragmas directly, rather than using the connection string configuration.

[IOL0ol1]

it's works for me.

        public void CreateOrOpenSqlcipher(string db, string pwd)
        {
              // do not add Password in connectionstring if need custom sqlcipher key options.
            using (var conection = new SqliteConnection($"DataSource='{db}';"))
            {
                conection.Open(); 
                using (var cmd = conection.CreateCommand())
                {
                    // set password by send the pragmas directly
                    cmd.CommandText = $"PRAGMA key = '{pwd}';";
                    cmd.ExecuteNonQuery();
                    // change sqlcipher key options
                    cmd.CommandText = "PRAGMA cipher_memory_security = OFF;";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "PRAGMA kdf_iter = '10000';";
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = "PRAGMA cipher_page_size = 8192;";
                    cmd.ExecuteNonQuery();
                    //create table make db file is not zero size
                    cmd.CommandText = "CREATE TABLE [t_data]([c_id] INTEGER PRIMARY KEY);";
                    cmd.ExecuteNonQuery();
                }
            }
        }