Session.GetObjectsFromQuery<T>(String, 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
Parameters
Name | Type | Description |
---|---|---|
sql | String | A String value that specifies a SQL query. |
parameterNames | String[] | An array of strings specifying parameterValues parameter names. |
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.