StoredProcQuery Class

A stored procedure call.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.1.dll

Declaration

C#

public sealed class StoredProcQuery :
    SqlQuery

VB.NET

Public NotInheritable Class StoredProcQuery
    Inherits SqlQuery

Remarks

To pass parameters to a stored procedure, assign QueryParameter objects to the SqlQuery.Parameters property of the StoredProcQuery.

Note

Do not add OUT parameters to the SqlQuery.Parameters collection of the StoredProcQuery class to prevent errors on an attempt to all a stored procedure.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the StoredProcQuery class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-create-data-access-library-data-sources-at-runtime-t424210/CS/SqlDataSourceSnippets/Code.cs#L40

{
    StoredProcQuery spQuery = new StoredProcQuery("StoredProcedure", "stored_procedure_name");
    spQuery.Parameters.Add(new QueryParameter("@First", typeof(int), 0));

VB.NET

how-to-create-data-access-library-data-sources-at-runtime-t424210/VB/SqlDataSourceSnippets/Code.vb#L27

Private Sub StoredProcedureInitialization()
    Dim spQuery As New StoredProcQuery("StoredProcedure", "stored_procedure_name")
    spQuery.Parameters.Add(New QueryParameter("@First", GetType(Integer), 0))

Inheritance

Object

SqlQuery

StoredProcQuery

Extension Methods

Show 20 items

EditQuery()

EditQuery(IRepositoryItemsProvider)

EditQuery(UserLookAndFeel)

EditQuery(UserLookAndFeel, IRepositoryItemsProvider)

EditQuery(UserLookAndFeel, IWin32Window)

EditQuery(UserLookAndFeel, IWin32Window, IRepositoryItemsProvider)

EditQuery(UserLookAndFeel, IWin32Window, IDBSchemaProvider)

EditQuery(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IRepositoryItemsProvider)

EditQuery(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService)

EditQuery<TModel>(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, Action<IWizardCustomization<TModel>>)

EditQuery<TModel>(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, Action<IWizardCustomization<TModel>>, IServiceProvider)

EditQuery(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, IRepositoryItemsProvider)

EditQuery<TModel>(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, IRepositoryItemsProvider, Action<IWizardCustomization<TModel>>)

EditQuery<TModel>(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, IRepositoryItemsProvider, Action<IWizardCustomization<TModel>>, IServiceProvider)

EditQuery<TModel>(UserLookAndFeel, IWin32Window, IDBSchemaProvider, IParameterService, IRepositoryItemsProvider, Action<IWizardCustomization<TModel>>, IServiceProvider, ICustomQueryValidator)

EditQuery(EditQueryContext)

EditQuery<TModel>(EditQueryContext, Action<IWizardCustomization<TModel>>)

EditQueryWithQueryBuilder()

EditQueryWithQueryBuilder(QueryBuilderEditQueryContext)

EditQueryWithQueryBuilder(QueryBuilderEditQueryContext, QueryBuilderRunnerDelegate)