private void ParseRoutes() { Routes.Clear(); using (var reader = new StreamReader(string.Format(PathToData, "routes.csv"))) using (var csv = new CsvReader(reader)) { csv.Read(); csv.ReadHeader(); while (csv.Read()) { var route = new Route { Airline = Airlines.FirstOrDefault(x => x.IATADesignator == csv.GetField("Airline Id")), Origin = Airports.FirstOrDefault(x => x.IATADesignator == csv.GetField("Origin")), Destination = Airports.FirstOrDefault(x => x.IATADesignator == csv.GetField("Destination")) }; Routes.Add(route); } } }