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