YetaWF.DataProvider.SQLDyn Package Documentation

YetaWF.DataProvider.SQL.SQLBase.Direct_ScalarIntAsync Method

Executes the provided SQL statement(s) and returns a scalar integer.

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

Syntax

public Task<int> Direct_ScalarIntAsync( string sql );
public Task<int> Direct_ScalarIntAsync(
    string sql,
    params object[] args );

Parameters

sql

The SQL statement(s).

args

Optional arguments that are passed when executing the SQL statements.

Return Value

Returns a scalar integer.

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.