Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }