I've got a model set up in the Entity Framework (EF) where there are two tables, parent and child, in a one to many relationship. Where I am having trouble is writing a query with linq where I am trying to retrieve a single instance of the parent while filtering upon a field in the parent and another field in the child. It would look something like what is listed below:
var query = from c in context.ParentTable where c.IsActive == true && c.ChildTable.Name = "abc" select c;
Unfortunately when I try this it fails because no field named "Name" appears available via Intellisense when I type c.ChildTable.
Any guidance would be appreciated.