Hello.
Please help me, I want to know about SQLCipher Community Edition how to use .NET Framework.
I want to encrypt databese using System.Data.Sqlite, but It cause error.
(Maybe I mistake how to use this … )
Could It encrypt databese in this development environment and Code?
I tested below code.
var dataSource = MyDataFilePath;
SQLiteConnectionStringBuilder connectionStringBuilder = new SQLiteConnectionStringBuilder
{
DataSource = dataSource
};
connection = new SQLiteConnection(connectionStringBuilder.ToString());
connection.Open();
using (var command = new SQLiteCommand("PRAGMA foreign_keys = true", connection))
{
command.ExecuteNonQuery();
}
using (var command = new SQLiteCommand("PRAGMA key ='password'", connection))
{
command.ExecuteNonQuery();
}
This is error content.
SQLite error (21): API called without license: -2147024894 (0x80070002)
And I use PC below preference.
- Windows 10
- .NET Framework 4.8
- Using below Nuget packcage.
- SQLitePCLRaw.bundle_e_sqlcipher (version 2.1.8)
- System.Data.SQLite.Core (version 1.0.118)
I’m beginner database and English.
I’m really sorry if this topic is funny.
[postscript]
If I’m trying to use not community version without realizing it?
I would like to know that it can using community version in this code and develop enviorment, and how to use the community version.