Click or drag to resize

IDao.GetMultiAsDataTable Method (IEntityFields, DataTable, ISortExpression, IPredicate, IRelationCollection, Boolean, ITransaction)

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.10.0.0 (5.10.0)
Syntax
Copy
bool GetMultiAsDataTable(
	IEntityFields fieldsToReturn,
	DataTable tableToFill,
	ISortExpression sortClauses,
	IPredicate selectFilter,
	IRelationCollection relations,
	bool allowDuplicates,
	ITransaction transactionToUse
)

Parameters

fieldsToReturn
Type: SD.LLBLGen.Pro.ORMSupportClasses.IEntityFields
IEntityFields implementation which forms the definition of the resultset to return.
tableToFill
Type: System.Data.DataTable
The datatable to fill with the rows retrieved
sortClauses
Type: SD.LLBLGen.Pro.ORMSupportClasses.ISortExpression
The order by specifications for the sorting of the resultset. If null is specified, no sorting is applied.
selectFilter
Type: SD.LLBLGen.Pro.ORMSupportClasses.IPredicate
A predicate or predicate expression which should be used as filter for the entities to retrieve.
relations
Type: SD.LLBLGen.Pro.ORMSupportClasses.IRelationCollection
The set of relations to walk to construct to total query.
allowDuplicates
Type: System.Boolean
Flag to allow duplicate rows or not
transactionToUse
Type: SD.LLBLGen.Pro.ORMSupportClasses.ITransaction
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.

Return Value

Type: Boolean
true if succeeded, false otherwise
See Also