如何在c#中从数据库中下载具有jpeg格式图像的zip文件

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

public class ImageDownloader
{
    public void DownloadImagesFromDatabase()
    {
        string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

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

            string query = "SELECT ImageData FROM Images WHERE ImageFormat = 'jpeg'"; // 替换为实际的查询语句
            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            using (ZipArchive zip = ZipFile.Open("Images.zip", ZipArchiveMode.Create))
            {
                while (reader.Read())
                {
                    byte[] imageData = (byte[])reader["ImageData"];
                    string fileName = Guid.NewGuid().ToString() + ".jpeg"; // 使用GUID生成唯一的文件名

                    ZipArchiveEntry entry = zip.CreateEntry(fileName);
                    using (Stream entryStream = entry.Open())
                    {
                        entryStream.Write(imageData, 0, imageData.Length);
                    }
                }
            }
        }

        // 下载ZIP文件
        string zipFilePath = "Images.zip";
        string zipFileName = Path.GetFileName(zipFilePath);

        // 设置下载文件的HTTP头信息
        System.Web.HttpContext.Current.Response.ContentType = "application/zip";
        System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + zipFileName);
        System.Web.HttpContext.Current.Response.TransmitFile(zipFilePath);
        System.Web.HttpContext.Current.Response.End();
    }
}