Exemplos de NSQLQuery.JoinWhere em C# (CSharp)

Exemplo n.º 1

        public void TestConditionWhereJoinWhere()
        {
            // Query Principal
            var sqlRaw = "select * from test";
            var nsql   = new NSQLQuery(sqlRaw);

            // Query 2
            var nSubSql = new NSQLQuery();

            nSubSql.Where("coluna1", Op.IGUAL, "TESTE");

            // Adiciona sub query
            nsql.JoinWhere(nSubSql);

            var expected = "select * from test WHERE coluna1 = 'TESTE'";

            Assert.AreEqual(expected, nsql.ToSql(), true);
        }