public void AndEqualLessParam() { WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL); w.EqualLessValue("a", "1"); w.EqualLessValue("b", "2"); w.EqualLessValue("c", "3"); string result = w.GetSql(); string sql = "[a]<=1 AND [b]<=2 AND [c]<=3"; Assert.AreEqual(sql, result); }
public void AndEqualLessParam() { SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql; WhereList w = new WhereList(SqlBuilder.DefaultFormatter); w.EqualLessValue("a", "1"); w.EqualLessValue("b", "2"); w.EqualLessValue("c", "3"); string result = w.GetSql(); string sql = "[a]<=1 AND [b]<=2 AND [c]<=3"; Assert.AreEqual(sql, result); }
public void AndEqualLessParam() { SuperSql.DefaultFormatter = FormatterLibrary.MsSql; var w = new WhereList(SuperSql.DefaultFormatter); w.EqualLessValue("a", "1"); w.EqualLessValue("b", "2"); w.EqualLessValue("c", "3"); var result = w.GetSql(); var sql = "[a]<=1 AND [b]<=2 AND [c]<=3"; Assert.Equal(sql, result); }