IDaoGetMultiAsDataTable Method (IEntityFields, DataTable, Int64, ISortExpression, IPredicate, IRelationCollection, Boolean, IGroupByCollection, ITransaction, Int32, Int32)

bool GetMultiAsDataTable(
	IEntityFields fieldsToReturn,
	DataTable tableToFill,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IPredicate selectFilter,
	IRelationCollection relations,
	bool allowDuplicates,
	IGroupByCollection groupByClause,
	ITransaction transactionToUse,
	int pageNumber,
	int pageSize
)

Function GetMultiAsDataTable ( 
	fieldsToReturn As IEntityFields,
	tableToFill As DataTable,
	maxNumberOfItemsToReturn As Long,
	sortClauses As ISortExpression,
	selectFilter As IPredicate,
	relations As IRelationCollection,
	allowDuplicates As Boolean,
	groupByClause As IGroupByCollection,
	transactionToUse As ITransaction,
	pageNumber As Integer,
	pageSize As Integer
) As Boolean

Parameters

fieldsToReturn

Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFields
IEntityFields implementation which forms the definition of the resultset to return.

tableToFill

Type: System.DataDataTable
The datatable to fill with the rows retrieved

maxNumberOfItemsToReturn

Type: SystemInt64
The maximum number of items to return with this retrieval query. When set to 0, no limitations are specified.

sortClauses

Type: SD.LLBLGen.Pro.ORMSupportClassesISortExpression
The order by specifications for the sorting of the resultset. If null is specified, no sorting is applied.

selectFilter

Type: SD.LLBLGen.Pro.ORMSupportClassesIPredicate
A predicate or predicate expression which should be used as filter for the entities to retrieve.

relations

Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
The set of relations to walk to construct to total query.

allowDuplicates

Type: SystemBoolean
Flag to allow duplicate rows or not

groupByClause

Type: SD.LLBLGen.Pro.ORMSupportClassesIGroupByCollection
The list of fields to group by on. When not specified or an empty collection is specified, no group by clause is added to the query. A check is performed for each field in the selectList. If a field in the selectList is not present in the groupByClause collection, an exception is thrown.

transactionToUse

Type: SD.LLBLGen.Pro.ORMSupportClassesITransaction
The transaction object to use. Can be null. If specified, the connection object of the transaction is used to fill the TypedView, which avoids deadlocks on SqlServer.

pageNumber

Type: SystemInt32
The page number to retrieve.

pageSize

Type: SystemInt32
The page size of the page to retrieve.

Return Value

Reference