Click or drag to resize
IDaoGetMultiAsDataTable 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.3.0)
bool GetMultiAsDataTable(
	IEntityFields fieldsToReturn,
	DataTable tableToFill,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IPredicate selectFilter,
	IRelationCollection relations,
	bool allowDuplicates,
	IGroupByCollection groupByClause,
	ITransaction transactionToUse,
	int pageNumber,
	int pageSize


Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFields
IEntityFields implementation which forms the definition of the resultset to return.
Type: System.DataDataTable
The datatable to fill with the rows retrieved
Type: SystemInt64
The maximum number of items to return with this retrieval query. When set to 0, no limitations are specified.
Type: SD.LLBLGen.Pro.ORMSupportClassesISortExpression
The order by specifications for the sorting of the resultset. If null is specified, no sorting is applied.
Type: SD.LLBLGen.Pro.ORMSupportClassesIPredicate
A predicate or predicate expression which should be used as filter for the entities to retrieve.
Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
The set of relations to walk to construct to total query.
Type: SystemBoolean
Flag to allow duplicate rows or not
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.
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.
Type: SystemInt32
The page number to retrieve.
Type: SystemInt32
The page size of the page to retrieve.

Return Value

Type: Boolean
true if succeeded, false otherwise
See Also