Ejemplo n.º 1
0
        public void GetLimitString()
        {
            var dialect = new MsSqlCe40Dialect();
            var str     = dialect.GetLimitString(new SqlString("SELECT id FROM user ORDER BY name"), 13, 17);

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

            Assert.AreEqual("SELECT id FROM user ORDER BY GETDATE() OFFSET 13 ROWS FETCH NEXT 17 ROWS ONLY", str.ToString());
        }