Click or drag to resize
IDataAccessAdapterFetchTypedList Method (IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection, Int32, Int32)
Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Namespace: SD.LLBLGen.Pro.ORMSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.0.0.0 (5.0.0)
Syntax
Copy
void FetchTypedList(
	IEntityFields2 fieldCollectionToFetch,
	DataTable dataTableToFill,
	IRelationPredicateBucket filterBucket,
	int maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	bool allowDuplicates,
	IGroupByCollection groupByClause,
	int pageNumber,
	int pageSize
)

Parameters

fieldCollectionToFetch
Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFields2
IEntityField2 collection which contains the fields to fetch into the datatable. The fields inside this object are used to construct the selection resultset. Use the typed list's method GetFieldsInfo() to retrieve this IEntityField2 information
dataTableToFill
Type: System.DataDataTable
The datatable object to fill with the data for the fields in fieldCollectionToFetch
filterBucket
Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationPredicateBucket
filter information (relations and predicate expressions) for retrieving the data. Use the TypedList's method GetRelationInfo() to retrieve this bucket.
maxNumberOfItemsToReturn
Type: SystemInt32
The maximum amount of rows to return. If 0, all rows matching the filter are returned
sortClauses
Type: SD.LLBLGen.Pro.ORMSupportClassesISortExpression
SortClause expression which is applied to the query executed, sorting the fetch result.
allowDuplicates
Type: SystemBoolean
When true, it will not filter out duplicate rows, otherwise it will DISTINCT duplicate rows.
groupByClause
Type: SD.LLBLGen.Pro.ORMSupportClassesIGroupByCollection
GroupByCollection with fields to group by on
pageNumber
Type: SystemInt32
the page number to retrieve. First page is 1. When set to 0, no paging logic is applied
pageSize
Type: SystemInt32
the size of the page. When set to 0, no paging logic is applied
See Also