public List <ClubModel> GetAll() { string query = "Select * from club "; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >(); DataSet results = ExecuteQuery(query, parameters); List <ClubModel> clubs = new List <ClubModel>(); if (results != null) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { ClubModel c = DataSetParser.DataSetToclub(results, x); clubs.Add(c); } } return(clubs); }