.net核心web api -如何以块为单位返回表结果

[HttpGet]
public async Task<IActionResult> GetTableResult()
{
    // 获取表结果数据
    var tableData = await GetDataFromDatabase();

    // 定义每个块的大小（可根据需求调整）
    var blockSize = 1024;

    // 将表结果数据分块
    var blocks = SplitIntoBlocks(tableData, blockSize);

    // 设置响应头，指示使用分块传输编码
    HttpContext.Response.Headers.Add("Transfer-Encoding", "chunked");

    // 逐块发送数据给客户端
    foreach (var block in blocks)
    {
        // 等待一段时间（可选），以模拟较大的表结果
        await Task.Delay(500);

        // 发送块数据给客户端
        await HttpContext.Response.BodyWriter.WriteAsync(block);
        await HttpContext.Response.BodyWriter.FlushAsync();
    }

    return Ok();
}

private async Task<IEnumerable<byte[]>> GetDataFromDatabase()
{
    // 从数据库中获取表结果数据（示例）
    var tableData = await _databaseService.GetTableData();

    // 将表结果数据转换为字节数组块
    var blocks = SplitIntoBlocks(tableData, blockSize);

    return blocks;
}

private IEnumerable<byte[]> SplitIntoBlocks(byte[] data, int blockSize)
{
    var offset = 0;
    var remainingBytes = data.Length;

    while (remainingBytes > 0)
    {
        var currentBlockSize = Math.Min(remainingBytes, blockSize);

        var block = new byte[currentBlockSize];
        Buffer.BlockCopy(data, offset, block, 0, currentBlockSize);

        yield return block;

        offset += currentBlockSize;
        remainingBytes -= currentBlockSize;
    }
}