WithAggregate fetching whole tables

I have a many to many relationship between Sheet and Customer objects. These relations are joined using a CustomerSheet object. I am using named aggregates named "CustomerWithSheet" and "SheetWithCustomer" (set in the appropriate "Backreference Aggregates" and "Collection Aggregates" properties, good work guys - it is so intuitive I got it in an instant without docs). Finally I am able to retrieve all rows in a single query which is perfect.

When I select:

x => x.Sheets.WithAggregate("SheetWithCustomer").Where(s => s.Kind == SheetKind.GoodSheet)

the query to the database (SQL Server 2012) seems to be all right:

exec sp_executesql N'SELECT
  [Sheets].[Id] AS [Sheets.Id],
  [Sheets].[Kind] AS [Sheets.Kind],
  [Sheets].[Name] AS [Sheets.Name]
FROM
  [Sheets]
WHERE
  [Sheets].[Kind] = @p0;

SELECT
  [CustomerSheets].[Id],
  [CustomerSheets].[CustomerId],
  [CustomerSheets].[SheetId]
FROM
  [CustomerSheets]
WHERE
  EXISTS (
    SELECT
      [Sheets].*
    FROM
      [Sheets]
    WHERE
      [Sheets].[Id] = [CustomerSheets].[SheetId] AND
      [Sheets].[Kind] = @p0
  );

SELECT
  [Customers].[Id],
  [Customers].[Name]
FROM
  [Customers]
WHERE
  EXISTS (
    SELECT
      [CustomerSheets].*
    FROM
      [CustomerSheets]
    WHERE
      [CustomerSheets].[CustomerId] = [Customers].[Id] AND
      EXISTS (
        SELECT
          [Sheets].*
        FROM
          [Sheets]
        WHERE
          [Sheets].[Id] = [CustomerSheets].[SheetId] AND
          [Sheets].[Kind] = @p0
      )
  )',N'@p0 int',@p0=2

But when I select (without any filter):

x => x.Sheets.WithAggregate("SheetWithCustomer")

the query on the database is:

SELECT
  [Sheets].[Id] AS [Sheets.Id],
  [Sheets].[Kind] AS [Sheets.Kind],
  [Sheets].[Name] AS [Sheets.Name]
FROM
  [Sheets];

SELECT
  [CustomerSheets].[Id],
  [CustomerSheets].[CustomerId],
  [CustomerSheets].[SheetId]
FROM
  [CustomerSheets];

SELECT
  [Customers].[Id],
  [Customers].[Name]
FROM
  [Customers]

The second query seems to be excessive - it selects ALL customers, even those without any sheets. It is the problem as Customers without sheets might be a majority in the database, why select them ?

This looks like a bug to me, can you please confirm this ?

Thanks.

Thanks for reporting this - yes this doesn't look right given they can be filtered on the FK. Ill check into why this is occurring (as there may be some reason Im not aware of) and let you know what the story is here.

Thanks!
Jeremy