public void TestJoinQuery() { Person p = new Person(); p.FirstName = "Mirko"; p.LastName = "Matytschak"; p.Moniker = "Hallo"; Adresse a1 = new Adresse(); a1.Lkz = "D"; a1.Plz = "83646"; a1.Straße = "Nockhergasse 7"; a1.Ort = "Bad Tölz"; Adresse a2 = new Adresse(); a2.Ort = "Mönchen"; a2.Plz = "80331"; a2.Straße = "Isartorplatz 5"; a2.Lkz = "D"; Institution i = new Institution(); i.FirstName = "Schnulli"; i.LastName = "Wauwau"; i.Hausmeister = "Möller"; pm.MakePersistent(a1); pm.MakePersistent(a2); pm.MakePersistent(p); pm.MakePersistent(i); i.AddAdresse(a1); p.AddAdresse(a1); p.AddAdresse(a2); pm.Save(); pm.UnloadCache(); IQuery q = new NDOQuery <Contact>(pm, $"addresses.plz = '{a2.Plz}'"); IList l = q.Execute(); Assert.AreEqual(1, l.Count, "Wrong number of contacts"); }