If I have a database with for example.....
A hotel has as part of its definition a navigational property in EF of Room
Each Room has a Navigational Property of Bed
Now theres lots of hotels and each has lots of rooms and some rooms have 1,2 or 3 beds.
How can I do something like
Hotel h = context.Hotels.where( c => c.Rooms.Beds =3)
I have tried many alternatives and looked at a gazillion web pages on the matter and am yet to find a solution.