brokenthorn

try
{
    await using var sqlDataReader = await sqlCommand.ExecuteReaderAsync(cancellationToken);
    await using var streamWriter = new StreamWriter($"{reportName}_{startDate:dd-MM-yyyy}-{endDate:dd-MM-yyyy}.csv");
    await using var csvWriter = new CsvWriter(streamWriter, _csvConfiguration);

    var columnSchema = sqlDataReader.GetColumnSchema();
    var columnCount = columnSchema.Count;

    // write headers to CSV: