Read N Consequent Items By Activerecord

My project is C# and uses CastleProject ActiveRecord on MS SQL Server database. I need to retrieve N consequent items from the database, sorted by some criteria, started from some

Solution 1:

Assuming your AR class is MyItem and it inherits ActiveRecordBase<T>:

MyItem[] items = MyItem.SlicedFindAll(100, 20, new[] {Order.Asc("time")});