public List <Department> GetDepartments() { const string query = @"SELECT [Id] ,[DepartmentName] FROM [viDepartment]"; using (var con = _dbHelper.GetConnection()) { var departments = con.Query <Department>(query).ToList(); foreach (var department in departments) { // TODO: set users department.Users = _userRepository.GetDepartmentUser(department.Id); foreach (var user in department.Users) { user.ConfirmedVacationSlots = _vacationRepository.GetConfirmedVacationSlotsFromUser(user.Id); } } return(departments); } }