56 lakh records generate in CSV

We can add the large number of records asynchronously using the sollowing code snippet:

using Microsoft.AspNetCore.Mvc;
using System.IO;
using System.Text;
using System.Threading.Tasks;

namespace CsvGenerator.Controllers
{
    [ApiController]
    [Route("[controller]")]
    public class CsvController : ControllerBase
    {
        [HttpGet("generate")]
        public async Task GenerateCsv()
        {
            var response = HttpContext.Response;
            response.ContentType = "text/csv";
            response.Headers.Add("Content-Disposition", "attachment; filename=largefile.csv");

            using (var writer = new StreamWriter(response.Body, Encoding.UTF8))
            {
                // Write the header
                await writer.WriteLineAsync("Column1,Column2,Column3");

                // Generate and write records
                for (int i = 0; i < 5600000; i++)
                {
                    await writer.WriteLineAsync($"{i},Value{i},AnotherValue{i}");
                }
            }

            return new EmptyResult();
        }
    }
}

It is possible by using a streaming approach to write the records directly to the response output stream, minimizing memory usage.