Session.ExecuteQuery(String, String[], Object[]) 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,
object[] parameterValues
)
#Parameters
Name | Type | Description |
---|---|---|
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 |
---|---|
Selected |
A Selected |
#Remarks
Use ExecuteQuery to query data stores for result sets. You can visualize result sets via the XPDataView. To learn how to access the resulting data, refer to How to: Access Data in SQL Query Results.
The example below demonstrates how to use this method. Here, session is the Session instance.
using DevExpress.Xpo.DB;
// ...
SelectedData data = GetEmployeesSimpleData();
// ...
public SelectedData GetEmployeesSimpleData() {
const string queryString =
@"SELECT EmployeeID, (FirstName + ' ' + LastName) as Name, City, Country
FROM [Northwind].[dbo].[Employees]
WHERE City = @p1";
return session.ExecuteQuery(queryString,
new string[] { "p1" },
new object[] { "London" });
}
Note that a format of parameter names in a SQL statement depends on the ADO.NET provider and database you use.
To learn more about executing SQL queries in XPO, refer to Direct SQL Queries.
Note
The Execute