Hi,

I have a many-to-many association between Fabricante and Revenda and I want to list all fabricante instances with each revenda of them.

I'm using this code to do it. Therefore, It's happening a bad behavior with a generated SQL.


fabricantes = (IList) NHibernateUtil.getSession()
.CreateCriteria(typeof(Fabricante))
.AddOrder(NHibernate.Expression.Order.Asc("NomeFabricante"))
.SetFetchMode("Revendas", NHibernate.FetchMode.Eager)
.List();


The result of this code repeat the same "fabricante" many times and by coincidence ;) the same quantity of the"revendas" for each "fabricante".

I read in the Hibernate in Action that when we use fetch collection, Hibernate doen´t return a distinct result list, and the book recommend use a Set collection to avoid duplicated "fabricante" from the List returned of the query.

If really this happening, I would like to know if there is a better way to do it, because using FetchMode.Eager is a very bad choice. You can imagine if I have 1000 "fabricante" and 1000 "revendas" to each "fabricante".

The resulted would be horrible!

If my thought about this point, is wrong. Please clear my mind.

Thanks in advance,
Cleiton

Hi,

I found the solution to the problem.

Change the code from:


To this code appending:



I found the solution in this topic:
http://forum.hibernate.org/viewtopic.php?t=952693

Thanks,
Cleiton