Session.GetObjectsFromQuery<T>(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

Declaration

C#

public ICollection<T> GetObjectsFromQuery<T>(
    string sql,
    object[] parameterValues
)

VB.NET

Public Function GetObjectsFromQuery(Of T)(
    sql As String,
    parameterValues As Object()
) As ICollection(Of T)

Parameters

Name	Type	Description
sql	String	A String value that specifies an SQL query.
parameterValues	Object[]	An array of objects specifying parameters to pass to the database server along with the query.

Type Parameters

Name
T

Returns

Type	Description
ICollection<T>	A collection of non-persistent objects of the specified type that are instantiated with data obtained via the specified SQL query.

Remarks

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, and populates a collection with these objects. The type and the order of object members should exactly match the result set’s columns. 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.

Note

The GetObjectsFromQuery<T> method throws an exception if object members include 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.