Click or drag to resize

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

Retrieves rows in the datatable provided which match the specified filter, containing the fields specified. 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.9.0.0 (5.9.0)
Syntax
public virtual bool GetMultiAsDataTable(
	IEntityFields fieldsToReturn,
	DataTable tableToFill,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IPredicate selectFilter,
	IRelationCollection relations,
	bool allowDuplicates,
	IGroupByCollection groupByClause,
	ITransaction transactionToUse,
	int pageNumber,
	int pageSize
)

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

Type: Boolean
true if succeeded, false otherwise

Implements

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