public static DisciplineSet getDisciplineSetById(int disciplineSetId)
        {
            Dictionary <string, object> result = querySingleSql(""
                                                                + "SELECT "
                                                                + "* "
                                                                + "FROM "
                                                                + "`" + tableName + "` "
                                                                + "WHERE "
                                                                + "`" + field_disciplineSetId + "` = " + disciplineSetId
                                                                );

            if (result == null)
            {
                return(null);
            }

            DisciplineSet disciplineSet = new DisciplineSet(
                Convert.ToInt32(result[field_disciplineSetId])
                );

            foreach (Discipline discipline in DisciplineSetDisciplineMappingProvider.getDisciplinesByDisciplineSet(disciplineSet))
            {
                disciplineSet.addDiscipline(discipline);
            }

            foreach (Competition competition in CompetitionProvider.getCompetitionsByDisciplineSet(disciplineSet))
            {
                disciplineSet.addCompetition(competition);
            }

            foreach (DisciplineSetDisciplineMapping disciplineSetDisciplineMapping in DisciplineSetDisciplineMappingProvider.getDisciplineSetDisciplineMappingsByDisciplineSet(disciplineSet))
            {
                disciplineSet.addDisciplineSetDisciplineMapping(disciplineSetDisciplineMapping);
            }

            return(disciplineSet);
        }