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.
public ICollection<T> GetObjectsFromQuery<T>( List<XPMemberInfo> members, string sql )
Public Function GetObjectsFromQuery(Of T)( members As List(Of XPMemberInfo), sql As String ) As ICollection(Of T)
A list of XPMemberInfo objects representing object members that are mapped to the query's result set columns. The order of list elements should correspond to the order of result set columns.
A String value that specifies an SQL query.
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:
The GetObjectsFromQuery<T> method throws an exception if the members list includes any of the following object members:
To learn more about executing SQL queries in XPO and retrieving objects from query results, refer to Direct SQL Queries.