public void Can_Include_Many_Multiple()
{
SqlSet <SqlSetInclude.Employee> set1 = db.Table <SqlSetInclude.Employee>()
.Include("EmployeeTerritories");
SqlSet <SqlSetInclude.Employee> set2 = set1.Include("Orders");
SqlSetInclude.Employee item = set1.First();
Assert.IsNotNull(item.EmployeeTerritories);
Assert.AreNotEqual(0, item.EmployeeTerritories.Count);
Assert.IsTrue(item.EmployeeTerritories.All(p => Object.ReferenceEquals(p.Employee, item)));
// test immutability
Assert.IsTrue(item.Orders == null || item.Orders.Count == 0);
item = set2.First();
Assert.IsNotNull(item.EmployeeTerritories);
Assert.AreNotEqual(0, item.EmployeeTerritories.Count);
Assert.IsTrue(item.EmployeeTerritories.All(p => Object.ReferenceEquals(p.Employee, item)));
Assert.IsNotNull(item.Orders);
Assert.AreNotEqual(0, item.Orders.Count);
//Assert.IsTrue(item.Orders.All(p => Object.ReferenceEquals(p.Employee, item)));
}
public void Cannot_Include_Many_In_Many()
{
SqlSet <SqlSetInclude.Employee> set = db.Table <SqlSetInclude.Employee>()
.Include("Orders.OrderDetails");
SqlSetInclude.Employee item = set.First();
}
public void Can_Include_One_In_Many()
{
SqlSet <SqlSetInclude.Employee> set = db.Table <SqlSetInclude.Employee>()
.Include("EmployeeTerritories.Territory");
SqlSetInclude.Employee item = set.First();
Assert.IsNotNull(item.EmployeeTerritories);
Assert.AreNotEqual(0, item.EmployeeTerritories.Count);
Assert.IsTrue(item.EmployeeTerritories.All(p => p.Territory != null));
}
