public static Competition getCompetitionById(int competitionId) { Dictionary<string, object> result = querySingleSql("" + "SELECT " + "* " + "FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_competitionId + "` = " + competitionId ); if (result == null) { return null; } Competition competition = new Competition( Convert.ToInt32(result[field_competitionId]), Convert.ToString(result[field_competitionName]) ); foreach (DisciplineSet disciplineSet in DisciplineSetProvider.getDisciplineSetsByCompetition(competition)) { competition.addDisciplineSet(disciplineSet); } return competition; }