These linq queries are translated into the same sql query

from portfolio in Session.Current.Query.All<Portfolio>() select portfolio

&

from portfolio in Session.Current.Query.All<Portfolio>()
.Prefetch(p => new { p.Status, p.Fund, p.ManagementCompany })
select portfolio

But this linq query leads to the desired result

from portfolio in Session.Current.Query.All<Portfolio>()
                                  .Prefetch(p => p.Status)
                                  .Prefetch(p => p.Fund)
                                  .Prefetch(p => p.ManagementCompany)
                              select portfolio