public EmployeeTerritoryCollectionResponse Fetch(EmployeeTerritoryQueryCollectionRequest 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 <EmployeeTerritoryEntity> entities;

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

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

            OnAfterGetEmployeeTerritoryQueryCollectionRequest(request, output);
            return(output);
        }
 partial void OnAfterGetEmployeeTerritoryQueryCollectionRequest(EmployeeTerritoryQueryCollectionRequest request, EmployeeTerritoryCollectionResponse response);
 partial void OnBeforeGetEmployeeTerritoryQueryCollectionRequest(EmployeeTerritoryQueryCollectionRequest request);
 partial void OnAfterFetchEmployeeTerritoryQueryCollectionRequest(IDataAccessAdapter adapter, EmployeeTerritoryQueryCollectionRequest request, EntityCollection <EmployeeTerritoryEntity> entities, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int totalItemCount);
 partial void OnBeforeFetchEmployeeTerritoryQueryCollectionRequest(IDataAccessAdapter adapter, EmployeeTerritoryQueryCollectionRequest request, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit);