Linq to Entities : How to filter master table rows based on child rows properties
I have a master table Person
and a detail table Events
I need to filter master table rows based on child row property Some开发者_如何学运维Id
.
Could anyone please show me how to do it ?
Thanks in advance!
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;
var q = db.Events.Where(p=>p.SomeId == 4).Select(p=>p.Person).Distinct();
精彩评论