使用C#解密列级SQL加密值

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

public class Program
{
    public static void Main()
    {
        string encryptedValue = "加密后的值"; // 待解密的加密值

        string decryptedValue = DecryptValue(encryptedValue);
        Console.WriteLine("解密后的值: " + decryptedValue);
    }

    public static string DecryptValue(string encryptedValue)
    {
        // 解密密钥
        string decryptionKey = "解密密钥";

        // 将加密值转换为字节数组
        byte[] encryptedBytes = Convert.FromBase64String(encryptedValue);

        // 创建解密器
        using (Aes aes = Aes.Create())
        {
            aes.Key = Encoding.UTF8.GetBytes(decryptionKey);
            aes.IV = new byte[16]; // 初始化向量

            // 创建解密流
            using (MemoryStream ms = new MemoryStream())
            {
                using (CryptoStream cs = new CryptoStream(ms, aes.CreateDecryptor(), CryptoStreamMode.Write))
                {
                    cs.Write(encryptedBytes, 0, encryptedBytes.Length);
                    cs.FlushFinalBlock();
                }

                // 将解密后的字节数组转换为字符串
                byte[] decryptedBytes = ms.ToArray();
                string decryptedValue = Encoding.UTF8.GetString(decryptedBytes);

                return decryptedValue;
            }
        }
    }
}