Method: Select
This method handles selecting data.
public ManageDataPages Select ()
public ManageDataPages Select (string whereClause)
public ManageDataPages Select (Where whereClause)
public ManageDataPages Select (int page, string whereClause)
public ManageDataPages Select (int page, Where whereClause)
public ManageDataPages Select (int page, string whereClause, string orderBy)
public ManageDataPages Select (int page, Where whereClause, string orderBy)
The select method supports data paging and assists in front-end Pagination by allowing you to return the following serialized output to the front end.
Please Note: If you need to use paging or are returning records beyond the max per page, you must have a defined identity column or pass an orderBy column name.
new Customer().Select().ToString();
{
"TotalPages":3,
"TotalRecords":30000,
"CurrentPage":1,
"RecordsAllowedPerPage":10000,
"Data":[{...}]
}
|