Hide

YetaWF.DataProvider.SQLDyn Package Documentation

YetaWF.DataProvider.SQL.SQLBase.Direct_StoredProcAsync Method

Executes the provided SQL stored procedure returns a collection of objects (one for each row retrieved) of type TYPE.

Class: YetaWF.DataProvider.SQL.SQLBase
Namespace: YetaWF.DataProvider.SQL
Assembly: YetaWF.DataProvider.SQLDyn

Syntax

public Task<YetaWF.Core.DataProvider.DataProviderGetRecords<TYPE>> Direct_StoredProcAsync<TYPE>(
    string sqlProc,
    object? parms = null );

Parameters

sqlProc

The name of the stored procedure.

parms

An anonymous object with named parameters.

Return Value

Returns a collection of objects (one for each row retrieved) of type TYPE.

Remarks

This is used by application data providers to build and execute complex queries that are not possible with the standard data providers. Use of this method limits the application data provider to SQL repositories.