如何使用类似于Asp.Net MVC散列机制的口令散列的SQL查询来插入用户记录数据库

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

// 获取用户输入的密码
string password = "user_password";

// 生成口令散列
using (SHA256 sha256Hash = SHA256.Create())
{
    byte[] bytes = sha256Hash.ComputeHash(Encoding.UTF8.GetBytes(password));
    StringBuilder builder = new StringBuilder();
    for (int i = 0; i < bytes.Length; i++)
    {
        builder.Append(bytes[i].ToString("x2"));
    }
    string hashedPassword = builder.ToString();

    // 准备SQL查询语句
    string query = "INSERT INTO Users (Username, PasswordHash) VALUES (@Username, @PasswordHash)";

    // 创建数据库连接对象
    using (SqlConnection connection = new SqlConnection("connection_string"))
    {
        // 打开数据库连接
        connection.Open();

        // 创建并配置SQL命令对象
        using (SqlCommand command = new SqlCommand(query, connection))
        {
            // 添加参数
            command.Parameters.AddWithValue("@Username", "user_name");
            command.Parameters.AddWithValue("@PasswordHash", hashedPassword);

            // 执行SQL查询
            command.ExecuteNonQuery();
        }
    }
}