Session.ExecuteQuery(String, String[], QueryParameterCollection) Method
Executes the specified SQL query and returns a result set.
Namespace: DevExpress.Xpo
Assembly: DevExpress.Xpo.v24.2.dll
NuGet Package: DevExpress.Xpo
#Declaration
public SelectedData ExecuteQuery(
string sql,
string[] parameterNames,
QueryParameterCollection parameters
)
#Parameters
Name | Type | Description |
---|---|---|
sql | String | Specifies an SQL statement. |
parameter |
String[] | Specifies parameter names. |
parameters | Query |
Specifies query parameter values. |
#Returns
Type | Description |
---|---|
Selected |
A result set compatible with XPData |
#Remarks
Use the ExecuteQuery method to query data stores for resulting sets. You can visualize resulting sets using the XPDataView. Refer to this article for additional information: How to: Access Data in SQL Query Results.
Use QueryParameterCollection to pass strongly-typed parameters. See examples here: Always Encrypted (SQL Server only).
To learn more about executing SQL statements in XPO, refer to Direct SQL Queries.
Note
The Execute