I am using the following hql statement to retrieve a list of BreedingProject objects:

string hql =
@"from BreedingProject as bp left join bp._crops cs
where bp._year = :requestYear and
(cs in (:cropList) or cs is null) ";

But instead of a list of BreedinProject objects it returns a list of System.Object[] objects with a BreedingProject object at index 0 and a Crop (=cs) object at index 1.
I more or less do understand that this is caused by the left join call, but what hql should I use in order to obtain a list of BreedingObjects instead, against the same where clause?

select bp from BreedingProject as bp left join bp._crops cs
where bp._year = :requestYear and
(cs in (:cropList) or cs is null)

Of all people in the NHibernate community.... Thnx Martijn!

Modifying the hql as suggested works fine. I now get a list of bp objects returned. Howerver, this list contains multiple instances of the same object, where I expected a unique list of bp objects. Is there a way to get a unique list or do I have to filter doubles myself?

You have to filter them yourself or you can use an ResultSetTransformer to get a unique list. Beware of using the ResultSetTransformer when setting a max limit on results, however as the max limit is on the results *before* the duplicates are removed.

To filter them yourself you can create a HashedSet and load it with the IList result of your query. The set will only contain the unique results.

Symon.

Indeed, the Hashtable is what I use now to filter duplicates, although I need the database id as key, since all objects are different instances as well. Will leave it like it is now. Thanks!

Actually, when you get duplicate results from a query as you are each of the duplicate entities are in fact the same object - it's just been added to the collection multiple times.

hello, i have a question of this too.. :D

what if i want to get this..

select bp, cs from BreedingProject as bp left join bp._crops cs
where bp._year = :requestYear and
(cs in (:cropList) or cs is null)

can i get it someway???

thanks!!

Well, that is what I got the first time. If you omit select bp from the hql syntax, you will get a Systme.Object[] with bp at index 0 and cs at index 1

ok i know that... but i want a object[] that has an object only, not an array of object...

I can only say that ultimately the IQuery.list() method will return a list of objects and depending on the hql statement this will either be a list of bp objects or a list of System.Object[] objects.
For the rest, I do not completely understand what you want to get returned from the IQuery