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