Hide

YetaWF.DataProvider.SQLDyn Package Documentation

Display
Print

YetaWF.DataProvider.SQL.SQLBase.Direct_QueryPagedListAsync Method

Executes the provided SQL statement(s) and returns a paged 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_QueryPagedListAsync<TYPE>(
    string sql,
    int skip,
    int take,
    List<YetaWF.Core.DataProvider.DataProviderSortInfo>? sort,
    List<YetaWF.Core.DataProvider.DataProviderFilterInfo>? filters,
    params object[] args );

Parameters

sql

The SQL statement(s).

skip

The number of records to skip (paging support).

take

The number of records to retrieve (paging support). If more records are available they are dropped.

sort

A collection describing the sort order.

filters

A collection describing the filtering criteria.

args

Optional arguments that are passed when executing the SQL statements.

Return Value

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

Remarks

$WhereFilter$ and $OrderBy$ embedded in the SQL statements are replace with a complete WHERE clause for filtering and the column names for sorting, respectively.

The SQL statements must create two result sets. The first, a scalar value with the total number of records (not paged) and the second result set is a collection of objects of type TYPE.

See Also YetaWF.DataProvider.SQL.SQLBase ClassYetaWF.DataProvider.SQLDynYetaWF.Core