C# (CSharp) NSQLQuery.OrderBy Beispiele

Beispiel #1

        public void TestConditionOrdeBy()
        {
            var sqlRaw = "select * from test";
            var nsql   = new NSQLQuery(sqlRaw);

            nsql.OrderBy("coluna1");
            nsql.OrderBy("coluna2", Order.DESC);

            var expected = "select * from test ORDER BY coluna1 ASC,coluna2 DESC";

            Assert.AreEqual(expected, nsql.ToSql(), true);
        }