public void SimpleUnion() { EmployeeCollection collection = new EmployeeCollection(); collection.es.Connection.Name = "ForeignKeyTest"; EmployeeQuery eq1 = new EmployeeQuery("eq1"); EmployeeQuery eq2 = new EmployeeQuery("eq2"); // This leaves out the record with Age 30 eq1.Where(eq1.Age < 30); eq1.Union(eq2); eq2.Where(eq2.Age > 30); Assert.IsTrue(collection.Load(eq1)); Assert.AreEqual(4, collection.Count); }