hi Donovan, I get the feeling it has something to do with your mapping. can you please show us your mapping?
On 7 פברואר, 14:25, Donovan Groeneweegen <[email protected]> wrote: > I have the following simplified mapping: > > BaseEntity (abstract) > > EntityA : BaseEntity > > EntityB : BaseEntity > > My inheritance strategy is table-per-subclass, using a discriminator > value. > > EntityA needs to contain a collection of EntityB. > > When I try to access the nested subclass (EntityB) collection, I get > an exception trying to query the collection. Looking at the SQL > generated, I see that the statement is attempting to fetch the ID > property of EntityA (the FK on the EntityB table) from the BaseEntity > table, instead of from the EntityB table. > > Eg: > > SELECT base.EntityA_ID, base.ID, eb.Name > FROM BaseEntity base > INNER JOIN EntityB eb ON base.ID = eb.ID > WHERE base.EntityA_ID = x > > What I would expect to see is something like this: > > SELECT base.ID, eb.Name > FROM BaseEntity base > INNER JOIN EntityB eb ON base.ID = eb.ID > WHERE eb.EntityA_ID = x > > Any help would be greatly appreciated! > > Regards > Don -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
