public void OrderByTableAlias2() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; OrderByList o = new OrderByList(SqlBuilder.DefaultFormatter); o.Raw("[a] ASC"); o.Ascending("as1"); o.Descending("ds2"); o.SetTableAlias("ttt"); o.Ascending("at1"); o.SetTableAlias("ddd"); o.Descending("at2"); o.SetTableAlias(); o.Descending("b"); string result = o.GetSql(); string sql = "[a] ASC, [as1] ASC, [ds2] DESC, [ttt].[at1] ASC, [ddd].[at2] DESC, [b] DESC"; Assert.AreEqual(sql, result); }
public void OrderByTableAlias2() { NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter = FormatterLibrary.MsSql; OrderByList o = new OrderByList(NKnife.Storages.SQL.Common.SuperSql.DefaultFormatter); o.Raw("[a] ASC"); o.Ascending("as1"); o.Descending("ds2"); o.SetTableAlias("ttt"); o.Ascending("at1"); o.SetTableAlias("ddd"); o.Descending("at2"); o.SetTableAlias(); o.Descending("b"); string result = o.GetSql(); string sql = "[a] ASC, [as1] ASC, [ds2] DESC, [ttt].[at1] ASC, [ddd].[at2] DESC, [b] DESC"; Assert.Equal(sql, result); }