public void GetLimitString()
{
var dialect = new MsSqlCe40Dialect();
var str = dialect.GetLimitString(new SqlString("SELECT id FROM user ORDER BY name"), new SqlString("13"), new SqlString("17"));
Assert.AreEqual("SELECT id FROM user ORDER BY name OFFSET 13 ROWS FETCH NEXT 17 ROWS ONLY", str.ToString());
}
public void GetLimitStringWithDummyOrder()
{
var dialect = new MsSqlCe40Dialect();
var str = dialect.GetLimitString(new SqlString("SELECT id FROM user"), 13, 17);
Assert.AreEqual("SELECT id FROM user ORDER BY GETDATE() OFFSET 13 ROWS FETCH NEXT 17 ROWS ONLY", str.ToString());
}