Skip to content

6. Top skip

ArnaudB88 edited this page Feb 11, 2025 · 1 revision

Usings

using OData2Linq;
using System;
using System.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