Skip to content

6. Top Skip

IharYakimush edited this page Apr 11, 2018 · 2 revisions

Usings

    using System;
    using System.Linq;

    using Community.OData.Linq;

Top 5 items

Code

    IQueryable<Sample> dataSet = Enumerable.Range(1, 50).Select(i => new Sample { Id = i }).AsQueryable();
    Sample[] filterResult = dataSet.OData().TopSkip("5").ToArray();

    // 1-5
    foreach (Sample sample in filterResult)
    {
        Console.WriteLine(string.Format("Id:{0}", sample.Id));
    }

Console output

Id:1
Id:2
Id:3
Id:4
Id:5

Top 5 and Skip 5 items

Code

    IQueryable<Sample> dataSet = Enumerable.Range(1, 50).Select(i => new Sample { Id = i }).AsQueryable();
    Sample[] filterResult = dataSet.OData().TopSkip("5","5").ToArray();

    // 6-10
    foreach (Sample sample in filterResult)
    {
        Console.WriteLine(string.Format("Id:{0}", sample.Id));
    }

Console output

Id:6
Id:7
Id:8
Id:9
Id:10

Default page size

Code

    IQueryable<Sample> dataSet = Enumerable.Range(1, 50).Select(i => new Sample { Id = i }).AsQueryable();
    Sample[] filterResult = dataSet.OData(s => s.QuerySettings.PageSize = 10).TopSkip().ToArray();

    // 1-10
    foreach (Sample sample in filterResult)
    {
        Console.WriteLine(string.Format("Id:{0}", sample.Id));
    }

Console output

Id:1
Id:2
Id:3
Id:4
Id:5
Id:6
Id:7
Id:8
Id:9
Id:10