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.5.0.0 (5.5.18.1019)
Syntax void FetchTypedList(
IEntityFields2 fieldCollectionToFetch,
DataTable dataTableToFill,
IRelationPredicateBucket filterBucket,
int maxNumberOfItemsToReturn,
ISortExpression sortClauses,
bool allowDuplicates,
IGroupByCollection groupByClause,
int pageNumber,
int pageSize
)
Sub FetchTypedList (
fieldCollectionToFetch As IEntityFields2,
dataTableToFill As DataTable,
filterBucket As IRelationPredicateBucket,
maxNumberOfItemsToReturn As Integer,
sortClauses As ISortExpression,
allowDuplicates As Boolean,
groupByClause As IGroupByCollection,
pageNumber As Integer,
pageSize As Integer
)
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