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); }
public void WhereConjunctionOrNotSeparateLines() { AggregateTestQuery query = new AggregateTestQuery(); query.Where(query.DepartmentID == 1); query.es.DefaultConjunction = esConjunction.OrNot; query.Where(new esComparison(esParenthesis.Open)); query.Where(query.IsActive == true); query.es.DefaultConjunction = esConjunction.And; query.Where(query.Age == 28); query.Where(new esComparison(esParenthesis.Close)); 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 WhereConjunctionAndNotSeparateLines() { AggregateTestQuery query = new AggregateTestQuery(); query.Where(query.DepartmentID == 1); query.es.DefaultConjunction = esConjunction.AndNot; query.Where(new esComparison(esParenthesis.Open)); query.Where(query.IsActive == true); query.es.DefaultConjunction = esConjunction.And; query.Where(query.Age == 28); query.Where(new esComparison(esParenthesis.Close)); AggregateTestCollection coll = new AggregateTestCollection(); Assert.IsTrue(coll.Load(query)); Assert.AreEqual(2, coll.Count); }