public void Paginates()
{
var details = new MsSqlDetails();
Assert.Equal("OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY", details.Paginate(1));
Assert.Equal("OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY", details.Paginate(2));
Assert.Equal("OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY", details.Paginate(3, 15));
Assert.Equal("OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY", details.Paginate(-1));
}
