public override void PagedQuery_Skip0_Take10(BenchmarksContainer bc)
{
bc.Add(id =>
{
_db.PagedQuery <sfPosts>(0, 10, "select * from sfposts where id>@0", 5);
}, "SqlFu");
}
public void paged_query()
{
Config.EnsurePosts();
var rez = _db.PagedQuery <Post>(1, 3, "select Id,Title,34 as ty from Posts where id<@id order by id desc", new{ id = 7 });
Assert.Equal(6, rez.Count);
Assert.Equal(3, rez.Items.Count());
Assert.Equal(5, rez.Items.First().Id);
Assert.Equal(4, rez.Items.Skip(1).First().Id);
Assert.Equal(3, rez.Items.Skip(2).First().Id);
}
