Session.GetObjectsFromQuery(XPClassInfo, String) Method
Executes a SQL query and returns its result set as a collection of non-persistent objects.
Namespace: DevExpress.Xpo
Assembly: DevExpress.Xpo.v24.2.dll
NuGet Package: DevExpress.Xpo
#Declaration
public ICollection GetObjectsFromQuery(
XPClassInfo classInfo,
string sql
)
#Parameters
Name | Type | Description |
---|---|---|
class |
XPClass |
An XPClass |
sql | String | Specifies an SQL statement. |
#Returns
Type | Description |
---|---|
ICollection | A collection of non-persistent class |
#Remarks
This method performs the following:
- Executes the specified SQL query and obtains the query result as a result set.
- Populates a collection with classInfo objects that are instantiated with the result set’s data. The type and the order of classInfo members should exactly match the result set’s columns. Note that classInfo should represent a non-persistent class decorated with a NonPersistentAttribute.
Note
The Get
- A property that is not defined within the class
Info object. - 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.