Click or drag to resize

IDaoGetMultiAsDataTable Method (Int64, ISortExpression, IPredicate, IRelationCollection, ITransaction, Int32, Int32)

Retrieves entities of the type this dao is for in a datatable which match the specified filter. It will always create a new connection to the database.

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
Copy
DataTable GetMultiAsDataTable(
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IPredicate selectFilter,
	IRelationCollection relations,
	ITransaction transactionToUse,
	int pageNumber,
	int pageSize
)

Parameters

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. When not 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.
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

Type: DataTable
a filled datatable if succeeded, false otherwise
See Also