I have a csv file name manufacture.csv like below
Name | Headquarter | Year |
---|---|---|
Audi | Germany | 2017 |
Ferrari | Italy | 2017 |
Now I want to fetch all the data and store into a list.
I have already created a class like below
class Manufacture{ public string Name { get; set; } public string Headquarter { get; set; } public string Year { get; set; } }
Now I want to store the data List of Manufacture.
You can try this code
var manufacturer = ProcessManufacturer("manufacture.csv"); // Here ProcessManufacturer is a private static method private static List<Manufacture> ProcessManufacturer(string path) { var query = File.ReadAllLines(path) .Where(l => l.Length > 1) .Select(l => { var columns = l.Split(','); return new Manufacture { Name = columns[0], Headquarter = columns[1], Year = int.Parse(columns[2]) }; }); return query.ToList(); }
Question and answer is powered by AnsPress.io