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