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);
