Need Footer in csv file

[rakeshmahur]

I need footer with record count in csv file as below:

applicationid | name | city
1 | rakesh | delhi
2 | jon | london
recordcount | 2

how can i create csv in this format.

[JoshClose]

After you're done writing, however you would like to do that, just write another row.

csv.WriteRecord(footer);
csv.NextRecord();

or

csv.WriteField("recordcound");
csv.WriteField(records.Count);
csv.NextRecord();

[CabaVarga]

If you are using the pattern from the tutorial:

using (var writer = new StreamWriter("path\\to\\file.csv"))
using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture))
{    
    csv.WriteRecords(records);
}

Then you can write anything to the writer stream, before or after accessing csvWriter.
For example:

using (var writer = new StreamWriter("path\\to\\file.csv"))
using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture))
{    
    csv.WriteRecords(records);
    writer.WriteLine($"recordcount | {records.Count}");
}

You need to be careful when you are reading from that file, though, either through Peek-ing into the next line before trying to get a record, or by using the TryGetField method, or maybe through Exception handling.