public EmployeeCollectionResponse Fetch(EmployeeQueryCollectionRequest 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 <EmployeeEntity> entities;

            using (var adapter = DataAccessAdapterFactory.NewDataAccessAdapter())
            {
                OnBeforeFetchEmployeeQueryCollectionRequest(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, request.RCache, out totalItemCount);
                OnAfterFetchEmployeeQueryCollectionRequest(adapter, request, entities, sortExpression, includeFields, prefetchPath, predicateBucket,
                                                           request.PageNumber, request.PageSize, request.Limit, totalItemCount);
            }
            var response = new EmployeeCollectionResponse(entities.ToDtoCollection(), request.PageNumber,
                                                          request.PageSize, totalItemCount);

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

            OnAfterGetEmployeeQueryCollectionRequest(request, output);
            return(output);
        }
 partial void OnAfterFetchEmployeeQueryCollectionRequest(IDataAccessAdapter adapter, EmployeeQueryCollectionRequest request, EntityCollection <EmployeeEntity> entities, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int totalItemCount);
 partial void OnBeforeFetchEmployeeQueryCollectionRequest(IDataAccessAdapter adapter, EmployeeQueryCollectionRequest request, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit);
 partial void OnAfterGetEmployeeQueryCollectionRequest(EmployeeQueryCollectionRequest request, EmployeeCollectionResponse response);
 partial void OnBeforeGetEmployeeQueryCollectionRequest(EmployeeQueryCollectionRequest request);