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);
}
