score:0

var list = db.lands.where(lnd => lnd.owners.any(x => x.name.contains("smit")));

score:0

var lands = db.owners.where(o => o.name.contains("smit")).select(o => o.lands);

score:2

var list = db.lands.join(db.owners.where(x=> x.name.contains("smit")), a=> a.id, b => b.landid, (a,b) => a).tolist();

Related Query

More Query from same tag