从SQL Server中检索varbinary(MAX)到C#中的byte []

using System.Data.SqlClient;
using System.IO;

// 连接字符串
string connectionString = "Data Source=your_server;Initial Catalog=your_database;Integrated Security=True";

// SQL查询语句
string sqlQuery = "SELECT your_varbinary_column FROM your_table";

// 创建SqlConnection对象
using (SqlConnection connection = new SqlConnection(connectionString))
{
    // 打开连接
    connection.Open();

    // 创建SqlCommand对象
    using (SqlCommand command = new SqlCommand(sqlQuery, connection))
    {
        // 创建SqlDataReader对象
        using (SqlDataReader reader = command.ExecuteReader())
        {
            // 读取查询结果
            while (reader.Read())
            {
                // 获取varbinary(MAX)类型的列数据
                byte[] data = (byte[])reader["your_varbinary_column"];

                // 处理数据
                // ...
            }
        }
    }
}