When running the below code, I get multiple Containers with same ID.
Should this ever happen?
If I comment out the SetFetchMode row it works correctly (from my point-of-view at least).



ScorecardId and Node are properties of Container.

/Carl

Hi Carl,

you need to add .SetResultTransformer(NHibernate.CriteriaUtil.DistinctRootEntity) to your Criteria query.

ICriteria crit = m_session.CreateCriteria(typeof(Container));
crit.Add(Expression.Eq("ScorecardId", id));
crit.SetFetchMode("Node.m_visibility", FetchMode.Eager);
crit.SetResultTransformer(NHibernate.CriteriaUtil.DistinctRootEntity);

IList list = crit.List();

Adding the result transformer is effectively the same as doing a "select distinct ... " sql or hql query. The difference with ICriteria is that instead of adding the distinct clause to the generated sql, the result transformer adds each object created from the underlying ado reader to a Hash and therefore any dups are discarded before the final collection is returned.

It worked. Thanks a lot!

no problem