public static List <Station> GetStations() { List <Station> stations = new List <Station>(); using (SqlConnection c = new SqlConnection(Settings.connString)) { SqlCommand cmd = new SqlCommand(Queries.q_GetStations, c); c.Open(); SqlDataAdapter a = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); a.Fill(dt); stations = Transformer.ConvertDTtoStations(dt); } return(stations); }