public IEnumerable <IAssociationOption> FindDefaultITCsOfLocation(string subcustomer) { var dto = new SearchRequestDto(); dto.AppendProjectionField(ProjectionField.Default("personid")); dto.AppendProjectionField(ProjectionField.Default("hlagdisplayname")); var groupNameToQuery = HapagPersonGroupConstants.BaseHapagLocationPrefix + subcustomer + "%"; dto.AppendWhereClauseFormat("personid in (select personid from persongroupview where persongroup like '{0}' and groupdefault=1)", groupNameToQuery); var persons = _repository.Get(_personEntity, dto); var result = new HashSet <ItcUser>(); foreach (var user in persons) { var personId = user.GetAttribute("personid") as string; var displayname = user.GetAttribute("hlagdisplayname") as string; result.Add(new ItcUser { Label = displayname, Value = personId }); } return(result); }