Session.ExecuteSprocParametrized(String, SprocParameter[]) Method

Executes the specified stored procedure with the named parameters and returns its result set.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v23.2.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public SelectedData ExecuteSprocParametrized(
    string sprocName,
    params SprocParameter[] parameters
)

VB.NET

Public Function ExecuteSprocParametrized(
    sprocName As String,
    ParamArray parameters As SprocParameter()
) As SelectedData

Parameters

Name	Type	Description
sprocName	String	A String value that specifies the stored procedure’s name.
parameters	DevExpress.Xpo.DB.SprocParameter[]	An array of SprocParameter objects specifying parameters to pass to the stored procedure.

Returns

Type	Description
SelectedData	A SelectedData object specifying the result set returned by the specified stored procedure.

Remarks

This method takes named parameters. The parameter order is arbitrary. The SprocParameter.Direction property should be set to Output for out parameters. Based on the current ADO.NET provider, the data type (SprocParameter.DbType), scale (SprocParameter.Scale) and precision (SprocParameter.Precision) may be required. If the stored procedure is a function, the resulting parameter with the SprocParameter.Direction property set to ReturnValue should be passed.

Out parameter values are returned in a supplementary ResultSet which includes two columns - parameter names and values. In the case where the procedure returns nothing but out parameter values, the first result set will be empty and the second will contain result values. In the case where the stored procedure is a function, one more ResultSet, which contains a single cell with the function result, is returned.

Below is an example of a ExecuteSprocParametrized method call.

C#

SelectedData data = 
    session.ExecuteSprocParametrized("TestProc", new SprocParameter("first", 123), new SprocParameter("second", "abc"));

VB.NET

Dim data As SelectedData = session.ExecuteSprocParametrized( _
"TestProc", New SprocParameter("first", 123), New SprocParameter("second", "abc"))

To visualize the result set returned by the ExecuteSprocParametrized method, use XPDataView. To learn how to access the resulting data, refer to How to: Access Data in SQL Query Results. For example, you can bind the GridControl control to the ExecuteSprocParametrized result as follows:

C#

using DevExpress.Xpo;
using DevExpress.Xpo.DB;
// ...
SelectedData sprocData = session.ExecuteSprocParametrized("TestProc", new SprocParameter("first", 123), new SprocParameter("second", "abc"));
gridControl1.DataSource = new XPDataView(session.Dictionary, session.GetClassInfo(typeof(MySproc)), sprocData);

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Xpo.DB
' ...
Private sprocData As SelectedData = session.ExecuteSprocParametrized("TestProc", New SprocParameter("first", 123), New SprocParameter("second", "abc"))
gridControl1.DataSource = New XPDataView(session.Dictionary, session.GetClassInfo(GetType(MySproc)), sprocData)

To learn more about executing stored procedures in XPO, refer to Stored Procedures.