public static List <DisciplineSet> getDisciplineSetsByDiscipline(Discipline discipline) { List <Dictionary <string, object> > results = querySql("" + "SELECT " + "* " + "FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_disciplineId + "` = " + discipline.DisciplineId ); List <DisciplineSet> disciplineSets = new List <DisciplineSet>(); foreach (var row in results) { disciplineSets.Add(DisciplineSetProvider.getDisciplineSetById(Convert.ToInt32(row[field_disciplineSetId]))); } return(disciplineSets); }