Well, I'm hesitant to say "its working fine", but it seems to be ok for an object load, save, update etc. It's just a class split across two physical tables - the entity ID represents the business object ID, which is a GUID, so its unique across everything. Therefore so a join between the ID of User and the Entity ID of the audit table will match correctly and not conflict, datawise, with a join between (e.g.) Task ID from the task table and the Entity ID from the audit table
As regards my initial question, I don't understand why the query is resolving the many-to-many of User to Group with "groups1_.elt=group2_.Id" instead of "groups1_.GroupId=group2_.Id", as described in my mapping file (similar for the many-to-many resolution between Task and Group). Where has it pulled the name "elt" from? This doesn't exist anywhere in any of the mapping files and seems to be generated by mistake.In case the mapping to the Audit table was causing the problem, I removed it from the mapping - no difference, still failed with the same issue. I'm using NHibernate 2.0.1GA. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
