internal EntityCollection <TEntity> Fetch(IDataAccessAdapter adapter, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, out int totalItemCount) { return(Fetch(adapter, sortExpression, excludedIncludedFields, prefetchPath, predicateBucket, pageNumber, pageSize, limit, 0, out totalItemCount)); }
public static void PrintSchema(IEntity2 entity, IPrefetchPath2 prefetchPath) { if (prefetchPath != null) { PrintSchema(prefetchPath, entity.GetEntityFactory().ForEntityName); } else { PrintEntityFields(entity, 0); } }
internal TEntity Fetch(IDataAccessAdapter adapter, IPredicate predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, int cacheTimeInSeconds) { var qf = new QueryFactory(); var q = qf.Create <TEntity>().Where(predicate); if (cacheTimeInSeconds > 0) { q = q.CacheResultset(cacheTimeInSeconds); } var results = adapter.FetchQuery(q); return((TEntity)(results[0])); }
internal EntityCollection <TEntity> Fetch(IDataAccessAdapter adapter, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, out int totalItemCount) { var entities = new EntityCollection <TEntity>(new TEntityFactory()); totalItemCount = adapter.GetDbCount(entities, predicateBucket); if (limit > 0) { adapter.FetchEntityCollection(entities, predicateBucket, limit, sortExpression, prefetchPath, excludedIncludedFields); } else { adapter.FetchEntityCollection(entities, predicateBucket, 0, sortExpression, prefetchPath, excludedIncludedFields, pageNumber, pageSize); } return(entities); }
internal EntityCollection <TEntity> Fetch(IDataAccessAdapter adapter, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int cacheTimeInSeconds, out int totalItemCount) { var qf = new QueryFactory(); var q = qf.Create().Select(qf.Create <TEntity>().Where(predicateBucket.PredicateExpression).CountRow()); if (cacheTimeInSeconds > 0) { q = q.CacheResultset(cacheTimeInSeconds); } totalItemCount = adapter.FetchScalar <int>(q); var entities = new EntityCollection <TEntity>(new TEntityFactory()); var parameters = new QueryParameters { CollectionToFetch = entities, FilterToUse = predicateBucket.PredicateExpression, RelationsToUse = predicateBucket.Relations, SorterToUse = sortExpression, ExcludedIncludedFields = excludedIncludedFields, PrefetchPathToUse = prefetchPath, CacheResultset = cacheTimeInSeconds > 0, CacheDuration = cacheTimeInSeconds > 0 ? TimeSpan.FromSeconds(cacheTimeInSeconds) : TimeSpan.Zero, RowsToTake = limit > 0 ? limit : pageSize, RowsToSkip = limit > 0 ? 0 : pageSize * (pageNumber - 1) }; adapter.FetchEntityCollection(parameters); return(entities); }
partial void OnBeforeFetchRegionQueryCollectionRequest(IDataAccessAdapter adapter, RegionQueryCollectionRequest request, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit);
partial void OnAfterFetchRegionPkRequest(IDataAccessAdapter adapter, RegionPkRequest request, RegionEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchCustomerDemographicPkRequest(IDataAccessAdapter adapter, CustomerDemographicPkRequest request, CustomerDemographicEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchSupplierUcSupplierNameRequest(IDataAccessAdapter adapter, SupplierUcSupplierNameRequest request, SupplierEntity entity, IPredicateExpression predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchProductUcProductNameRequest(IDataAccessAdapter adapter, ProductUcProductNameRequest request, ProductEntity entity, IPredicateExpression predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
public static EntityCollection SelectAllWFKAPaging(int iTop, ISortExpression sorter, EntityField2 fieldStatus, IRelationPredicateBucket filter, IPrefetchPath2 paths, int pageNumber, int pageSize) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { filter.PredicateExpression.Add(fieldStatus == true); adapter.FetchEntityCollection(ec, filter, iTop, sorter, paths, pageNumber, pageSize); } return(ec); }
public static EntityCollection SelectAllWFK(int iTop, ISortExpression sorter, IRelationPredicateBucket filter, IPrefetchPath2 paths) { EntityCollection ec = new EntityCollection(new TEntityFactory()); using (DataAccessAdapter adapter = DataAccessAdapterManagerBase.CreateAdapter()) { adapter.FetchEntityCollection(ec, filter, iTop, sorter, paths); } return(ec); }
public static void PrintSchema(IEntityFactory2 factory, IPrefetchPath2 prefetchPath) { PrintSchema(factory.Create(), prefetchPath); }
private static void PrintSchema(IPrefetchPath2 path, string rootEntityName) { for (int i = 0; i < path.Count; i++) { PrintSchema(path[i], rootEntityName); } }
partial void OnBeforeFetchCategoryUcCategoryNameRequest(IDataAccessAdapter adapter, CategoryUcCategoryNameRequest request, CategoryEntity entity, IPredicateExpression predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
private bool FetchEntityCollection(IEntityCollection2 collection, IRelationPredicateBucket bucket, int maxNumberOfItemsToReturn, ISortExpression sortExpression, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludeIncludeFieldsList, int pageNumber, int pageSize) { if (_entitiesToReturn != null) { foreach (IEntity2 entity in _entitiesToReturn) { collection.Add(entity); } } return(true); }
partial void OnAfterFetchSupplierPkRequest(IDataAccessAdapter adapter, SupplierPkRequest request, SupplierEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchTerritoryPkRequest(IDataAccessAdapter adapter, TerritoryPkRequest request, TerritoryEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnBeforeFetchEmployeeTerritoryPkRequest(IDataAccessAdapter adapter, EmployeeTerritoryPkRequest request, EmployeeTerritoryEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchCustomerUcCompanyNameRequest(IDataAccessAdapter adapter, CustomerUcCompanyNameRequest request, CustomerEntity entity, IPredicateExpression predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchEmployeePkRequest(IDataAccessAdapter adapter, EmployeePkRequest request, EmployeeEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnBeforeFetchOrderPkRequest(IDataAccessAdapter adapter, OrderPkRequest request, OrderEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchRegionUcRegionDescriptionRequest(IDataAccessAdapter adapter, RegionUcRegionDescriptionRequest request, RegionEntity entity, IPredicateExpression predicate, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnBeforeFetchCustomerCustomerDemoPkRequest(IDataAccessAdapter adapter, CustomerCustomerDemoPkRequest request, CustomerCustomerDemoEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);
partial void OnAfterFetchRegionQueryCollectionRequest(IDataAccessAdapter adapter, RegionQueryCollectionRequest request, EntityCollection <RegionEntity> entities, SortExpression sortExpression, ExcludeIncludeFieldsList excludedIncludedFields, IPrefetchPath2 prefetchPath, IRelationPredicateBucket predicateBucket, int pageNumber, int pageSize, int limit, int totalItemCount);
partial void OnAfterFetchOrderDetailPkRequest(IDataAccessAdapter adapter, OrderDetailPkRequest request, OrderDetailEntity entity, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields);