public void TestLinqAny()
{
var connectionString = GetConnectionString("TestLinqAny");
var context = new MyEntityContext(connectionString);
var deptA = context.Departments.Create();
deptA.Name = "Department A";
var deptB = context.Departments.Create();
deptB.Name = "Department B";
var alice = context.Persons.Create();
alice.Age = 25;
var bob = context.Persons.Create();
bob.Age = 29;
var charlie = context.Persons.Create();
charlie.Age = 21;
var dave = context.Persons.Create();
dave.Age = 35;
deptA.Persons.Add(alice);
deptA.Persons.Add(bob);
deptB.Persons.Add(charlie);
deptB.Persons.Add(dave);
context.SaveChanges();
var departmentsWithOldies = context.Departments.Where(d => d.Persons.Any(p => p.Age > 30)).ToList();
Assert.AreEqual(1, departmentsWithOldies.Count);
Assert.AreEqual(deptB.Id, departmentsWithOldies[0].Id);
}