public ProductCollectionResponse Fetch(ProductQueryCollectionRequest request)
        {
            base.FixupLimitAndPagingOnRequest(request);

            var totalItemCount  = 0;
            var sortExpression  = RepositoryHelper.ConvertStringToSortExpression(EntityType, request.Sort);
            var includeFields   = RepositoryHelper.ConvertStringToExcludedIncludedFields(EntityType, request.Select);
            var prefetchPath    = RepositoryHelper.ConvertStringToPrefetchPath(EntityType, request.Include, request.Select);
            var predicateBucket = RepositoryHelper.ConvertStringToRelationPredicateBucket(EntityType, request.Filter, request.Relations);

            EntityCollection <ProductEntity> entities;

            using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
            {
                OnBeforeFetchProductQueryCollectionRequest(adapter, request, sortExpression, includeFields, prefetchPath, predicateBucket,
                                                           request.PageNumber, request.PageSize, request.Limit);
                entities = base.Fetch(adapter, sortExpression, includeFields, prefetchPath, predicateBucket,
                                      request.PageNumber, request.PageSize, request.Limit, out totalItemCount);
                OnAfterFetchProductQueryCollectionRequest(adapter, request, entities, sortExpression, includeFields, prefetchPath, predicateBucket,
                                                          request.PageNumber, request.PageSize, request.Limit, totalItemCount);
            }
            var response = new ProductCollectionResponse(entities.ToDtoCollection(), request.PageNumber,
                                                         request.PageSize, totalItemCount);

            return(response);
        }
        /// <summary>Queries 'Product' entities using sorting, filtering, eager-loading, paging and more.</summary>
        public ProductCollectionResponse Get(ProductQueryCollectionRequest request)
        {
            OnBeforeGetProductQueryCollectionRequest(request);
            var output = Repository.Fetch(request);

            OnAfterGetProductQueryCollectionRequest(request, output);
            return(output);
        }
 partial void OnAfterGetProductQueryCollectionRequest(ProductQueryCollectionRequest request, ProductCollectionResponse response);
 partial void OnBeforeGetProductQueryCollectionRequest(ProductQueryCollectionRequest request);
 partial void OnAfterFetchProductQueryCollectionRequest(IDataAccessAdapter adapter, ProductQueryCollectionRequest request, EntityCollection <ProductEntity> entities, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int totalItemCount);
 partial void OnBeforeFetchProductQueryCollectionRequest(IDataAccessAdapter adapter, ProductQueryCollectionRequest request, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit);