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.1.0.0 (5.1.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
)
Public Overridable 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
Type:
Booleantrue if succeeded, false otherwise
Implements
IDaoGetMultiAsDataTable(IEntityFields, DataTable, Int64, ISortExpression, IPredicate, IRelationCollection, Boolean, IGroupByCollection, ITransaction, Int32, Int32)See Also