用于解密SQLite字段中数据的C#代码

using System;
using System.Data.SQLite;
using System.Security.Cryptography;
using System.Text;

public class SQLiteDecryptor
{
    private static string Decrypt(string encryptedData, string encryptionKey)
    {
        byte[] encryptedBytes = Convert.FromBase64String(encryptedData);
        byte[] keyBytes = Encoding.UTF8.GetBytes(encryptionKey);

        using (Aes aes = Aes.Create())
        {
            aes.Key = keyBytes;
            aes.Mode = CipherMode.ECB;
            aes.Padding = PaddingMode.PKCS7;

            ICryptoTransform decryptor = aes.CreateDecryptor();

            byte[] decryptedBytes = decryptor.TransformFinalBlock(encryptedBytes, 0, encryptedBytes.Length);

            return Encoding.UTF8.GetString(decryptedBytes);
        }
    }

    public static string DecryptSQLiteField(string connectionString, string tableName, string fieldName, string encryptionKey)
    {
        string decryptedData = null;

        using (SQLiteConnection connection = new SQLiteConnection(connectionString))
        {
            connection.Open();

            string query = $"SELECT {fieldName} FROM {tableName}";
            using (SQLiteCommand command = new SQLiteCommand(query, connection))
            {
                using (SQLiteDataReader reader = command.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        string encryptedData = reader.GetString(0);
                        decryptedData = Decrypt(encryptedData, encryptionKey);
                    }
                }
            }
        }

        return decryptedData;
    }
}