Example #1
0
        public void BoolWhereCriteriaFalseTest()
        {
            var criteria = new TestWhereBoolCriteria
            {
                OnlySingleStorey = false,
            };
            var builder = new QueryBuilder <TestWhereBoolCriteria>(criteria);
            var query   = builder.Build();

            Assert.AreEqual(
                "Select Houses.* from Houses",
                SimplifyString(query.Sql));
        }
Example #2
0
        public void BoolWhereCriteriaTrueTest()
        {
            var criteria = new TestWhereBoolCriteria
            {
                OnlySingleStorey = true,
            };
            var builder = new QueryBuilder <TestWhereBoolCriteria>(criteria);
            var query   = builder.Build();

            Assert.AreEqual(
                "Select Houses.* from Houses WHERE (Houses.FloorsCount = 1)",
                SimplifyString(query.Sql));
        }