public List <Models.BU.Teacher> GetTeacherList() { Models.Database db = new Models.Database(); string query = "SELECT * FROM UserAccount WHERE Role = '2' OR Role = '3'"; // Teacher en Examiner List <Models.BU.Teacher> teacherList = db.GetTeacherList(query); // Vul wishList van Teachers foreach (Models.BU.Teacher teacher in teacherList) { query = "SELECT DISTINCT * FROM Wish WHERE UserId = '" + teacher.UserID + "'"; teacher.wishList = db.GetWishListOfTeacher(query); } return(teacherList); }