Distinct objects from left join fetch of bag

jason.hill · **Joined:** Sat Sep 03, 2005 12:54 am **Posts:** 139

Hi,

I have been experimenting with the table-per-subclass inheritance mapping and I just gotta say that NH is so damned good and easy to use that I can't believe I used to do things the hard way! Everyone should be using this product end of story! Well done NH team :D

So, on to my problem! I have an abstract base class and another couple of subclasses that inherit from this. One of these subclasses has a bag that is implemented as a many to many association.

I am trying to left join fetch the bag but I am finding that NH is returning duplicate objects in the list even after I have added the distinct clause to the HQL.

Can this be done!?

Cheers,

Jason

michal · **Posted:** Mon Oct 17, 2005 9:29 am

Hi

you can try to exclude duplicates with ISet, e.g.:

Code:

dim set as ISet=new HashedSet(query.List())

I'm not sure but it is possible that your objects should be comparable (implement IComparable)

martijnb · **Joined:** Sat May 14, 2005 8:40 am **Posts:** 130

There is a JIRA issue for this: http://jira.nhibernate.org/browse/NH-300. Apperantly it has not been solved yet.