Linq to Entities : How to filter master table rows based on child rows properties

Question

I have a master table Person and a detail table Events

I need to filter master table rows based on child row property SomeId.

Could anyone please show me how to do it ?

Thanks in advance!

Answer 1

This works!

var q = from p in db.Persons
        join ev in db.Events on p.Id equals ev.PersonId
        where ev.SomeId == 4
        select p;

Answer 2

var q = db.Events.Where(p=>p.SomeId == 4).Select(p=>p.Person).Distinct();