加密
SQLiteConnection cnn = new SQLiteConnection($"Data Source = {sqliteFilePath}");
cnn.Open();
cnn.ChangePassword("your password");
cnn.Close();
连接加密数据库
//System.Data.Sqlite uses a non standard encryption files encrypted by it are only read by system.data.sqlite
//System.Data.Sqlite使用非标准的加密方式加密文件,所以只能由System.Data.Sqlite文件读取。
//->加密后的sqlite数据库无法在Navicat中打开。
//连接代码:
public static SQLiteConext CreateConnection(string fileName, string password = "")
{
string connectionString = $"Data Source ={fileName}";
SQLiteConnection sqlLiteConnection = new SQLiteConnection(connectionString);
if (!string.IsNullOrEmpty(password))
{
sqlLiteConnection.SetPassword(password);
}
return new SQLiteConext(sqlLiteConnection);
}
参考资料:
Open connection to SQLite secured database with navicat
资料出处:
sqlite 加密与连接