IDataAccessAdapterFetchTypedView Method (IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection, Int32, Int32) |
Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in
filterBucket into the DataTable object passed in. Use this routine to fill a TypedView object.
Namespace:
SD.LLBLGen.Pro.ORMSupportClasses
Assembly:
SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.8.0.0 (5.8.21.0111)
Syntax void FetchTypedView(
IEntityFields2 fieldCollectionToFetch,
DataTable dataTableToFill,
IRelationPredicateBucket filterBucket,
int maxNumberOfItemsToReturn,
ISortExpression sortClauses,
bool allowDuplicates,
IGroupByCollection groupByClause,
int pageNumber,
int pageSize
)
Sub FetchTypedView (
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 of the typed view to fetch into the datatable.
Use the Typed View's method GetFieldsInfo() to get this IEntityField2 field collection - 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. - 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
Remarks To fill a DataTable with entity rows, use this method as well, by passing the Fields collection of an entity of the same type
as the one you want to fetch as fieldCollectionToFetch.
See Also