Example #1
0
        public void Where_All()
        {
            //arrange
            SqlConnect sql      = new CSharpedSql.MySql.MySqlConnect();
            var        expected = "SELECT * FROM `test` WHERE `id` = ALL (SELECT * FROM `table`);";

            //act
            sql.Query(Select.From("test") + Where.All("id", Select.From("table")));
            var actual = sql.ToString().TrimEnd();

            //assert
            Assert.AreEqual(expected, actual);
        }