Read CSV file to create object List

[Aishwarya Tripathi]

What's the fastest way to read CSV file delimited by | into object List.

I have tried CSVHelper which works fine for several thousand records but for 3 GB CSV file this takes hours. My requirement is to read in the least possible time as there are many such files to process everyday.

Tried so far:

using (var reader = new StreamReader(csv file path))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
List<Customer> cList = csv.GetRecords<Customer>().ToList();

I can use any non-CsvHelper approach as well. Please let me know.


Thanks, AT

Continue reading...