ClassTableInheritance - The multi-part identifier "g1.Id" could not be bound

Hi

I have a ClassTableInheritance structure with one non-abstract base entity, and one derived entity.

I wish to perform some grouping, but the SQL issued is invalid

SELECT
  g1.Description
FROM
  (
    SELECT
      ReferenceData.Description
    FROM
      FailureDemand FailureDemand
    LEFT OUTER JOIN
      Complaint Complaint
    ON
      g1.Id = Complaint.Id
    INNER JOIN
      ReferenceData
    ON
      FailureDemand.ProductId = ReferenceData.Id
    GROUP BY
      ReferenceData.Description
  )
  g1

FailureDemand is the base entity

Complaint is the CTI derived entity

ReferenceData is a one to many association with FailureDemand 

The code that generates this SQL is Uow.Find<FailureDemand>().GroupBy(fdt => fdt.Product.Description)

Product is SingleTableInheritance with ReferenceData

Why is the SQL joining to Complaint, as I am not trying to retrieve Complaints, only the FailureDemands ?

If I manually edit the SQL by removing the join to Complaint I can get the query to return the correct results.

Thanks in advance for your help.

Patrick

Hi Patrick,

Can you send through a small repro which exhibits this behavior (usually just a cut down version of the model you are using and the query in question is all thats needed) and we can have a look at this.

Thanks!

Jeremy

Hi Jeremy

I have sent an app that reproduces the problem through to your support email address

Cheers

Patrick

Hi Jeremy

Thanks for the fix !!!

Patrick