Hide

YetaWF.DataProvider.PostgreSQL Package Documentation

Display
Print

YetaWF.DataProvider.PostgreSQL.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.PostgreSQL.SQLBase
Namespace: YetaWF.DataProvider.PostgreSQL
Assembly: YetaWF.DataProvider.PostgreSQL

Syntax

public Task<YetaWF.Core.DataProvider.DataProviderGetRecords<TYPE>> Direct_QueryPagedListAsync<TYPE>(
    string sqlCount,
    string sql,
    int skip,
    int take,
    List<YetaWF.Core.DataProvider.DataProviderSortInfo>? sort,
    List<YetaWF.Core.DataProvider.DataProviderFilterInfo>? filters,
    params object[] args );

Parameters

sqlCount

The SQL statement(s) to return the total number of records (not paged).

sql

The SQL statement(s) to return a collection of objects of type TYPE.

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 replaced with a complete WHERE clause for filtering and the column names for sorting, respectively.

Two SQL statements must be provided, one to return a scalar value with the total number of records (not paged) and the second to return a collection of objects of type TYPE.

See Also YetaWF.DataProvider.PostgreSQL.SQLBase ClassYetaWF.DataProvider.PostgreSQLYetaWF.Core