如何使用Web API下载SQL server中以字节形式存储的图像文件

[HttpGet]
[Route("api/images/{id}")]
public IActionResult DownloadImage(int id)
{
    // 连接到SQL Server数据库
    using (var connection = new SqlConnection("your_connection_string"))
    {
        connection.Open();

        // 查询数据库获取图像文件的字节数据
        var query = "SELECT ImageData FROM Images WHERE Id = @Id";
        using (var command = new SqlCommand(query, connection))
        {
            command.Parameters.AddWithValue("@Id", id);
            using (var reader = command.ExecuteReader())
            {
                if (reader.Read())
                {
                    // 获取图像文件的字节数据
                    var imageData = (byte[])reader["ImageData"];

                    // 构建HTTP响应
                    var response = new HttpResponseMessage(HttpStatusCode.OK);
                    response.Content = new ByteArrayContent(imageData);
                    response.Content.Headers.ContentType = new MediaTypeHeaderValue("image/jpeg");

                    // 返回响应
                    return File(imageData, "image/jpeg");
                }
            }
        }
    }

    // 如果未找到图像文件，则返回404 Not Found
    return NotFound();
}