在ASP.Core中上传文件:如何将二进制文件存储在数据库表中，使用Dapper插入数据

// 实体类
public class FileEntity
{
    public int Id { get; set; }
    public byte[] FileData { get; set; }
}

// 控制器
public class FileController : Controller
{
    private readonly string connectionString = "YourConnectionString";

    [HttpPost]
    public IActionResult Upload(IFormFile file)
    {
        if (file != null && file.Length > 0)
        {
            using (var stream = file.OpenReadStream())
            {
                byte[] fileData;
                using (var memoryStream = new MemoryStream())
                {
                    stream.CopyTo(memoryStream);
                    fileData = memoryStream.ToArray();
                }

                var entity = new FileEntity
                {
                    FileData = fileData
                };

                using (var connection = new SqlConnection(connectionString))
                {
                    connection.Open();
                    connection.Execute("INSERT INTO Files (FileData) VALUES (@FileData)", entity);
                }
            }
        }

        return RedirectToAction("Index");
    }
}