public void WhereConjunctionOrNotNested()
        {
            AggregateTestQuery query = new AggregateTestQuery();

            query.Where
            (
                query.OrNot
                (
                    query.DepartmentID == 1,
                    query.And
                    (
                        query.IsActive == true,
                        query.Age == 28
                    )
                )
            );

            AggregateTestCollection coll = new AggregateTestCollection();
            Assert.IsTrue(coll.Load(query));

            switch (coll.es.Connection.ProviderSignature.DataProviderName)
            {
                case "EntitySpaces.MSAccessProvider":
                    Assert.AreEqual(29, coll.Count);
                    break;

                case "EntitySpaces.NpgsqlProvider":
                case "EntitySpaces.Npgsql2Provider":
                case "EntitySpaces.OracleClientProvider":
                case "EntitySpaces.SqlClientProvider":
                case "EntitySpaces.SqlServerCeProvider":
                case "EntitySpaces.SybaseSqlAnywhereProvider":
                case "EntitySpaces.VistaDBProvider":
                case "EntitySpaces.VistaDB4Provider":
                    Assert.AreEqual(24, coll.Count);
                    break;

                default:
                    Assert.AreEqual(24, coll.Count);
                    break;
            }
        }
        public void WhereConjunctionAndNotNested()
        {
            AggregateTestQuery query = new AggregateTestQuery();

            query.Where
            (
                query.AndNot
                (
                    query.DepartmentID == 1,
                    query.And
                    (
                        query.IsActive == true,
                        query.Age == 28
                    )
                )
            );

            AggregateTestCollection coll = new AggregateTestCollection();
            Assert.IsTrue(coll.Load(query));
            Assert.AreEqual(2, coll.Count);
        }