Let us more on a bit, and talk about the inability to support any interesting scenario. If we look at collections with NHibernate, we can take this: Console.WriteLine(category.Products.Count); To this SQL: selectcount(*)fromProductswhereCategoryId = 1 With the approach that the EF uses,...