public void SingleUnionAllWithOverlap()
{
CustomerCollection coll = new CustomerCollection();
coll.es.Connection.Name = "ForeignKeyTest";
CustomerQuery cq1 = new CustomerQuery("c1");
cq1.Where(cq1.DateAdded.Between(Convert.ToDateTime("2005-01-01"), Convert.ToDateTime("2005-12-31")));
CustomerQuery cq2 = new CustomerQuery("c2");
cq2.Where(cq2.DateAdded.Between(Convert.ToDateTime("2005-12-31"), Convert.ToDateTime("2006-12-31")));
// Combine 2005 and 2006 in one result set with the 2 duplicate rows retained
cq1.UnionAll(cq2);
Assert.IsTrue(coll.Load(cq1));
Assert.AreEqual(51, coll.Count);
}