public IEnumerable <Major> GetAllMajors(int maxCount, int offset) { Dictionary <string, object> parameters = new Dictionary <string, object>(); _queryBuilder.AddSelect(@"*"); _queryBuilder.SetFrom("reg_opleidingen"); _queryBuilder.SetLimit("@limit"); _queryBuilder.SetOffset("@offset"); parameters.Add("@limit", maxCount); parameters.Add("@offset", offset); string query = _queryBuilder.BuildQuery(); var majors = _optionRepository.GetAllMajors(query, parameters); return(_mapper.Map <IEnumerable <Major> >(majors)); }