Query: projecting anonymous type containing entity and subquery returning a scalar results in N+1 queries

[maumar]

Repro:

                var query = from g in ctx.Gears
                            where g.HasSoulPatch
                            orderby g.Nickname
                            select new { Gear = g, WeaponsCount = g.Weapons.Count };

produces:

SELECT [g].[Nickname], [g].[SquadId], [g].[AssignedCityName], [g].[CityOrBirthName], [g].[Discriminator], [g].[FullName], [g].[HasSoulPatch], [g].[LeaderNickname], [g].[LeaderSquadId], [g].[Rank]
  FROM [Gear] AS [g]
  WHERE [g].[Discriminator] IN (N'Officer', N'Gear') AND ([g].[HasSoulPatch] = 1)
  ORDER BY [g].[Nickname]
  
  @_outer_FullName: Damon Baird (Size = 450)
  
  SELECT COUNT(*)
  FROM [Weapon] AS [w0]
  WHERE @_outer_FullName = [w0].[OwnerFullName]
  
  @_outer_FullName: Marcus Fenix (Size = 450)
  
  SELECT COUNT(*)
  FROM [Weapon] AS [w0]
  WHERE @_outer_FullName = [w0].[OwnerFullName]

We should be able to produce a single query, and we do, if instead of gear we project it's properties individually.

[smitpatel]

Duplicate of #11186