Session.GetObjectsFromQuery(XPClassInfo, List<XPMemberInfo>, String, String[], Object[]) 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,
List<XPMemberInfo> members,
string sql,
string[] parameterNames,
object[] parameterValues
)
#Parameters
Name | Type | Description |
---|---|---|
class |
XPClass |
An XPClass |
members | List<XPMember |
Specifies object members mapped to columns in the resulting set. The order of list elements should correspond to the order of the resulting set columns. |
sql | String | Specifies an SQL statement. |
parameter |
String[] | Specifies parameter names. |
parameter |
Object[] | An array of objects specifying parameters to pass to the database server along with the query. |
#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, based on the mapping information passed as the members parameter. 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.