public void WhereParenthesis5()
{
WhereList w = new WhereList(global::SqlBuilder.Format.MsSQL);
w.RawParenthesis("[a] IS NULL OR [b] IS NULL");
w.RawParenthesis("[c] IS NULL OR [d] IS NULL");
string result = w.GetSql();
string sql = "([a] IS NULL OR [b] IS NULL) AND ([c] IS NULL OR [d] IS NULL)";
Assert.AreEqual(sql, result);
}
public void WhereParenthesis5()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
WhereList w = new WhereList(SqlBuilder.DefaultFormatter);
w.RawParenthesis("[a] IS NULL OR [b] IS NULL");
w.RawParenthesis("[c] IS NULL OR [d] IS NULL");
string result = w.GetSql();
string sql = "([a] IS NULL OR [b] IS NULL) AND ([c] IS NULL OR [d] IS NULL)";
Assert.AreEqual(sql, result);
}
public void WhereParenthesis5()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var w = new WhereList(SuperSql.DefaultFormatter);
w.RawParenthesis("[a] IS NULL OR [b] IS NULL");
w.RawParenthesis("[c] IS NULL OR [d] IS NULL");
var result = w.GetSql();
var sql = "([a] IS NULL OR [b] IS NULL) AND ([c] IS NULL OR [d] IS NULL)";
Assert.Equal(sql, result);
}
