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
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 );
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.
Returns a collection of objects (one for each row retrieved) of type TYPE.
$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
Documentation Feedback
© 2024 - Softel vdm, Inc. - YetaWF.com