Task (example): The KNDRECH table contains deviating invoice recipients. There are two records with the value 113 in KNDNR1 and the values 1949 and 1973 in KNDNR2:
I now want to retrieve the two records from the customer table that correspond to the two records with the values 1949 and 1973 in KNDNR
abweichendeRechnungsempfaenger = EEvolution.GetContext().Kundes.Where(k => EEvolution.GetContext().Kndreches.Where(r => r.KNDNR1 == selectedKunde.KNDNR).Select(s => s.KNDNR2).Contains(k.KNDNR)).ToList();