I've have the following query:
.Where<ClubPartRecord>(c=> c.CityPartRecord.RegionPartRecord == null)
So "ClubPartRecord" has a related record "CityPartRecord" and "CityPartRecord" has a related record "RegionPartRecord". I get the following error with this query:
could not resolve property: CityPartRecord.RegionPartRecord of: Users.Models.Records.ClubPartRecord
As far I can see the normal query method can't query sub properties/records so it's returning this error. Queryhints doesn't solve this either. Could this be done using a normal Query or do I have to use a HQL query? Or is this not even possible with HQL
and do I have to use a plain SQL query. Thanks!