.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

Session.GetObjectsFromQuery<T>(LoadDataMemberOrderItem[], String, Object[]) Method

Executes a SQL query and returns its result set as a collection of objects of a non-persistent type specified by the generic type parameter.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v19.2.dll


public ICollection<T> GetObjectsFromQuery<T>(
    LoadDataMemberOrderItem[] members,
    string sql,
    object[] parameterValues
Public Function GetObjectsFromQuery(Of T)(
    members As LoadDataMemberOrderItem(),
    sql As String,
    parameterValues As Object()
) As ICollection(Of T)


Name Type Description
members LoadDataMemberOrderItem[]

An array of LoadDataMemberOrderItem objects which provide mapping information for object members and the query's result set columns.

sql String

A String value that specifies a parameterized SQL query.

parameterValues Object[]

An array of objects specifying parameters to pass to the database server along with the query.

Type Parameters



Type Description

A collection of non-persistent objects of the specified type that are instantiated with data obtained via the specified SQL query.


This method performs the following:

  • Executes the specified SQL query and obtains the query result as a result set.
  • Creates objects of the specified type and instantiates them with the result set's data, based on the mapping information passed as the members parameter. Note that the GetObjectsFromQuery<T> method's generic type parameter should specify a non-persistent class decorated with a NonPersistentAttribute.
  • Populates a collection with these objects.

The GetObjectsFromQuery<T> method throws an exception if the members array includes any of the following:

  • A property that is not defined within the T type.
  • A struct type member.
  • A reference to a class with a struct type member.
  • A collection used in object relations.

To learn more about executing SQL queries in XPO and retrieving objects from query results, refer to Direct SQL Queries.

See Also