public override IEnumerable <Row> Execute(IEnumerable <Row> rows) { using (var conn = new NpgsqlConnection(conString)) { conn.Open(); foreach (var row in rows) { AirportRepository.Add(conn, (string)row["OriginAirportName"], (string)row["OriginCityName"], (string)row["OriginState"], _dictAirport, _dictCity, _dictState); AirportRepository.Add(conn, (string)row["DestAirportName"], (string)row["DestCityName"], (string)row["DestState"], _dictAirport, _dictCity, _dictState); yield return(row); } } }