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