public void AndNotEqualParamValue()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.NotEqualValue("a", "1");
w.NotEqualValue("b", "2");
w.NotEqualValue("c", "3");
string result = w.GetSql();
string sql = "[a]!=1 AND [b]!=2 AND [c]!=3";
Assert.AreEqual(sql, result);
}
public void AndNotEqualParamValue()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.NotEqualValue("a", "1");
w.NotEqualValue("b", "2");
w.NotEqualValue("c", "3");
string result = w.GetSql();
string sql = "[a]!=1 AND [b]!=2 AND [c]!=3";
Assert.AreEqual(sql, result);
}
public void AndNotEqualParamValue()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.NotEqualValue("a", "1");
w.NotEqualValue("b", "2");
w.NotEqualValue("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);
}