Session.SelectDataInTransaction(XPClassInfo, CriteriaOperatorCollection, CriteriaOperator, CriteriaOperatorCollection, CriteriaOperator, Boolean, Int32, Int32, SortingCollection) Method

Retrieves objects from a session using the specified query parameters, including all in-memory changes into query results.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public List<object[]> SelectDataInTransaction(
    XPClassInfo classInfo,
    CriteriaOperatorCollection properties,
    CriteriaOperator criteria,
    CriteriaOperatorCollection groupProperties,
    CriteriaOperator groupCriteria,
    bool selectDeleted,
    int skipSelectedRecords,
    int topSelectedRecords,
    SortingCollection sorting
)

VB.NET

Public Function SelectDataInTransaction(
    classInfo As XPClassInfo,
    properties As CriteriaOperatorCollection,
    criteria As CriteriaOperator,
    groupProperties As CriteriaOperatorCollection,
    groupCriteria As CriteriaOperator,
    selectDeleted As Boolean,
    skipSelectedRecords As Integer,
    topSelectedRecords As Integer,
    sorting As SortingCollection
) As List(Of Object())

Parameters

Name	Type	Description
classInfo	XPClassInfo	An XPClassInfo object which provides the metadata information for the objects to be retrieved.
properties	CriteriaOperatorCollection	A CriteriaOperatorCollection object which specifies object properties to be retrieved.
criteria	CriteriaOperator	A CriteriaOperator descendant which specifies the objects to be retrieved.
groupProperties	CriteriaOperatorCollection	A CriteriaOperatorCollection object which specifies the grouping properties.
groupCriteria	CriteriaOperator	A CriteriaOperator descendant which specifies the grouping criteria for the retrieved objects.
selectDeleted	Boolean	A Boolean value that specifies whether the objects marked as deleted must be retrieved.
skipSelectedRecords	Int32	An integer value which specifies the number of objects to exclude when populating the list.
topSelectedRecords	Int32	An integer value which specifies the maximum number of objects to be retrieved.
sorting	SortingCollection	A SortingCollection object that specifies the sort order for the list of the retrieved objects.

Returns

Type	Description
List<Object[]>	A list whose elements are property values that correspond to the properties of objects retrieved from the session.

Remarks

This method is intended for internal use. To include in-memory changes into query results, get objects from a session using the XPCollection and XPView components with the Session.InTransactionMode enabled.