System.Data.SqlClient.SqlException (0x80131904): .... 'UserBase.Id' ... can't be found.

Hi there,

UserBase is a base class, Vendor is a child class and has 1:1 association to RichText which is loaded eagerly. UserBase has a 1:n association to Approval. I try to load a vendor via a Approval.ClaimIdentification and got an error. The error occurs during the select of the RichtText entity: UserBase.Id can't be found within the select.

SELECT
  UserBase.*
FROM
  (
    SELECT
      UserBase.Id AS [UserBase.Id],
      UserBase.CreatedOn AS [UserBase.CreatedOn],
      UserBase.EMailAddress AS [UserBase.EMailAddress],
      UserBase.FirstName AS [UserBase.FirstName],
      UserBase.LastName AS [UserBase.LastName],
      UserBase.LockVersion AS [UserBase.LockVersion],
      UserBase.Membership_IsLocked AS [UserBase.Membership_IsLocked],
      UserBase.Membership_LockedAt AS [UserBase.Membership_LockedAt],
      UserBase.Membership_PasswordHash AS [UserBase.Membership_PasswordHash],
      UserBase.Membership_PasswordSalt AS [UserBase.Membership_PasswordSalt],
      UserBase.Membership_UserName AS [UserBase.Membership_UserName],
      UserBase.UpdatedOn AS [UserBase.UpdatedOn],
      UserBase.UserType AS [UserBase.UserType],
      Vendor.CompanyName AS [Vendor.CompanyName],
      Vendor.InfoTextId AS [Vendor.InfoTextId],
      Vendor.WebSideUrl AS [Vendor.WebSideUrl],
      ROW_NUMBER() OVER(ORDER BY UserBase.Id) as RowNumber
    FROM
      UserBase
    LEFT OUTER JOIN
      Vendor Vendor
    ON
      UserBase.Id = Vendor.Id
    WHERE
      EXISTS (
        SELECT
          Approval.*
        FROM
          Approval
        WHERE
          Approval.UserId = UserBase.Id AND
          Approval.ClaimIdentification = '2e302755-8915-436e-a9ed-070b8ed1781c'
      )
  )
  UserBase
WHERE
  RowNumber <= 2;

SELECT
  RichText.Id,
  RichText.CreatedOn,
  RichText.LockVersion,
  RichText.UpdatedOn
FROM
  RichText
WHERE
  EXISTS (
    SELECT
      Vendor.*
    FROM
      Vendor
    WHERE
      Vendor.InfoTextId = RichText.Id AND
      EXISTS (
        SELECT
          Approval.*
        FROM
          Approval
        WHERE
          Approval.UserId = **UserBase.Id** AND
          Approval.ClaimIdentification = '2e302755-8915-436e-a9ed-070b8ed1781c'
      )
  )

Hi Soernt,

Ive tried setting up a repro here using the model you describe but I am getting slightly different (and working) SQL emitted which would lead me to believe that this has been addressed in an earlier nightly. Are you able to recheck using a recent nightly build?

If this is still an issue would you be able to send through a small repro project and Ill have another look into this.

Thanks!
Jeremy

Hi Jeremy,

I use the current nightly (28. Nov). I attached a demo.

Sörnt

Thanks for the repro - I can confirm the issue. We are investigating this now and I will post an update once we have an update on a fix.

Jeremy

We have added in a fix for this which will be available in the next nightly build.

Thanks!
Jeremy