Generate a new encrypted database for Microsoft.Data.Sqlite.Core

GenerateDatabase.cs

public class GenerateDatabase
{
    public void Generate()
    {
        var databasePlainName = "plaintext.db";
        var databasePlainPath = Path.Combine(FileSystem.AppDataDirectory, databasePlainName);
        
        var databaseEncryptedName = "database_encrypted.db";
        var databaseEncryptedPath = Path.Combine(FileSystem.AppDataDirectory, databaseEncryptedName);
        
        var databasePassword = "YOUR_SUPER_SECRET_PASSWORD";
        
        var encryptQuery = @$"ATTACH DATABASE '{databasePath}' AS database_encrypted KEY '{YOUR_SUPER_SECRET_PASSWORD}'; SELECT sqlcipher_export('database_encrypted'); DETACH DATABASE database_encrypted;";
        
        var connection = new SqliteConnection($"Data Source = {databasePlainPath}");
        connection.Open();
        
        using var cmd = new SqliteCommand(encryptQuery, connection);
        cmd.ExecuteNonQuery();
        connection.Close();
        
        if (File.Exists(databasePlainPath))
        {
            File.Delete(databasePlainPath);
        }
        
        //from here, you can connect to your database using your password. Enjoy!
    }
}