public void SimpleExcept() { EmployeeCollection collection = new EmployeeCollection(); collection.es.Connection.Name = "ForeignKeyTest"; EmployeeQuery eq1 = new EmployeeQuery("eq1"); EmployeeQuery eq2 = new EmployeeQuery("eq2"); // Includes all "J"s except "Jim" eq1.Where(eq1.FirstName.Like("%J%")); eq1.Except(eq2); eq2.Where(eq2.FirstName == "Jim"); Assert.IsTrue(collection.Load(eq1)); Assert.AreEqual(3, collection.Count); }