SingleTableInheritance problem

Hi,

I have that model:

when I query the uow with that statement:

 return (from
                up in LsUnitOfWork.UserPermissions
              where
                up.User.Id == userIdentity.Id
                &&
                up.SecuredObject.Id == securedObject.Id
              select
                up
              ).SingleOrDefault();

I got this SQL generated:

SELECT
  Permission.Id AS "Permission.Id",
  Permission.PermissionType AS "Permission.PermissionType",
  Permission.SecuredObjectId AS "Permission.SecuredObjectId",
  Permission.RoleId AS "Permission.RoleId",
  Permission.IsGranted AS "Permission.IsGranted",
  Permission.UserId AS "Permission.UserId"
FROM
  Permission
WHERE
  ((Permission.UserId = 2 AND t0.SecuredObjectId = 1) AND Permission.PermissionType = 1)
ORDER BY
  Permission.Id
LIMIT 2

--> Time:   0 ms

Somehow LS managed to not include "t0" which should be the SecuredObject entity.

Any ideas?

Forget to mention that I use LS version 4.0.524.17831

"T0" should be named "Permission"

Thanks for reporting this. This appears to be a problem when you are traversing an association on the base class when the query is rooted on the derived class. We will have a look into this and report back once we have some progress. In the meantime you should be able to rewrite your query using SecuredObjectId rather than SecuredObject.Id which should work fine to help cover this specific query.

Jeremy

I have put in a candidate fix which should cover this into tonights nightly build. Let us know if you are still running into issues.

Thanks!

Jeremy