isqlquery

ISQLQuery using AddJoin not loading related instance

I've got a problem using an ISQLQuery with an AddJoin. The entity I'm trying to return is RegionalFees, which has a composite-id which includes a Province instance. (This is the the instance being improperly loaded.) Here's the mapping: <class name="Project.RegionalFees, Project" table="tblRegionalFees"> <composite-id name="Id" cl...

Getting mapped entities from an ISQLQuery without AddEntity

Hello all, consider these POCOs: class Foo { int Id {get;set;} string Name {get;set;} } class Bar { int Id {get;set;} string PropA {get;set;} Foo PropB {get;set;} } Now what i want to achieve is using an ISQLQuery with a root entity of Bar to also hydrate the PropB property. ISQLQuery barsAround = nhSes.CreateSQLQuery("s...