MDMaterialRepository.cs

public IPaginatorRespDom<StringPairItemDom> OnLazyReference(string pattern, int start, int rows)
        {
            var withTranslationQuery = AsLabelTranslationsTranslatedQuery(x => x.Description, pattern);

            Expression<Func<WithTranslation<MDMaterial, int>, bool>> filter = null;
            if (isValidPattern(pattern))
            {
                filter = x => x.MdEntity.Name.ToUpper().Contains(pattern.ToUpper());
            }

            return new PaginatorRespDom<StringPairItemDom>()
            {
                Items = GetTranslatedPairItem<StringPairItemDom, int?>(withTranslationQuery, x => new StringPairItemDom()
                {
                    RefId = x.MdEntity.Id,
                    RefValue = x.TranslatedValue
                }, start, rows, filter),
                TotalResults = GetFieldDistinctCount(
                    withTranslationQuery,
                    x => x.MdEntity.Id
                )
            };
        }