public void ManualWhereOr()
{
ProductQuery pq = new ProductQuery("p");
pq.es2.Connection.Name = "ForeignKeyTest";
List<int> inList = new List<int>();
inList.Add(8);
inList.Add(9);
esComparison comp = null;
comp = pq.ManualWhere("ProductName", "LIKE", "W%", null, "OR");
comp = pq.ManualWhere("UnitPrice", "LESSTHAN", 10.0, null, "OR");
comp = pq.ManualWhere("ProductID", "IN", inList, null, "OR");
pq.Where(comp);
ProductCollection coll = new ProductCollection();
coll.es.Connection.Name = "ForeignKeyTest";
Assert.IsTrue(coll.Load(pq));
Assert.AreEqual(7, coll.Count);
}
public void ManualWhereAnd()
{
ProductQuery pq = new ProductQuery("p");
pq.es2.Connection.Name = "ForeignKeyTest";
esComparison comp = null;
comp = pq.ManualWhere("Discontinued", "EQUAL", false, null, "AND");
comp = pq.ManualWhere("UnitPrice", "BETWEEN", 0.15, 0.20, "AND");
comp = pq.ManualWhere("ProductID", "GREATERTHAN", 2, null, "AND");
pq.Where(comp);
ProductCollection coll = new ProductCollection();
coll.es.Connection.Name = "ForeignKeyTest";
Assert.IsTrue(coll.Load(pq));
Assert.AreEqual(1, coll.Count);
}
