Exemple #1
0
        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));
        }