Skip to content

Instantly share code, notes, and snippets.

@johnbabb

johnbabb/page-page-size-to-skip-take.cs

Last active June 19, 2020 09:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save johnbabb/fc1db5f30a7310bdf51799045c7c7503 to your computer and use it in GitHub Desktop.
Save johnbabb/fc1db5f30a7310bdf51799045c7c7503 to your computer and use it in GitHub Desktop.
Download ZIP
Code to covert page and page size into sql to skip rows and take rows.
Raw
page-page-size-to-skip-take.cs
void Main()
{
int? page = 3;
int? pageSize = 25;
if (page.HasValue && pageSize.HasValue)
{
var skip = (page.Value - 1) * pageSize.Value;
var take = pageSize.Value;
skip = skip < 0 ? 0 : skip;
Console.WriteLine(skip);
Console.WriteLine(take);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment