L2S querying child objects from parent (in 1-many relationship)
var obj = f开发者_高级运维rom r in db.ParentTables
where r.ChildTable.Count > 0 // && How can we get the Child table data by parsing value by query string.? for eg: r.ChildTable.Language= English
select r;
I need to maintain the returned query as r i.e. IEnumerable
If I've understood your question right, are looking for something like this
var obj = from r in db.ParentTables
where r.ChildTable.Any(c => c.Language = "English")
select r;
var obj = from r in db.ParentTables
where r.ChildTable.Any(c => c.Count() > 0 && c.Language == "English")
select r;
精彩评论