在C#中设置和更改SQLite数据库密码

SQLiteConnection connection = new SQLiteConnection("Data Source=mydatabase.db");

connection.Open();

string password = "myPassword";
string pragmaQuery = "PRAGMA key='" + password + "';";
SQLiteCommand command = new SQLiteCommand(pragmaQuery, connection);
command.ExecuteNonQuery();

string oldPassword = "myOldPassword";
string newPassword = "myNewPassword";

string decryptQuery = "PRAGMA rekey='" + oldPassword + "';";
SQLiteCommand decryptCommand = new SQLiteCommand(decryptQuery, connection);
decryptCommand.ExecuteNonQuery();

string encryptQuery = "PRAGMA key='" + newPassword + "';";
SQLiteCommand encryptCommand = new SQLiteCommand(encryptQuery, connection);
encryptCommand.ExecuteNonQuery();

connection.Close();