That's expected, the query uses an outer join, thus yielding 11 rows in the result. Please search for DistinctRootEntityResultTransformer and NHibernate for details. -Markus
2009/4/30 chitech <[email protected]> > > Let say I got this code: > > [ActiveRecord] > public class Case > { > [HasMany(Table="Case_CaseType", ColumnKey="CaseID", > Element="CaseTypeID", ElementType = typeof(CaseType))] > public IList<CaseType> CaseTypes > { > get { return caseTypes; } > > set { caseTypes = value; } > } > } > > > public enum CaseType > { > TYPE1 = 1, > TYPE2 = 2 > } > > Let say I have 10 cases and 1 of them have 2 casetypes > > When I run this query: > SimpleQuery query = new SimpleQuery(typeof(Case), @"from Case c"); > It's working fine and I get 10 cases back and casetypes is populated. > But NHProf saying select N+1 > > If I run this: > SimpleQuery query = new SimpleQuery(typeof(Case), @"from Case c left > joint fetch c.CaseTypes"); > Now I got 11 cases back and only 1 select statements (the last part is > fine) > > It is because NHibernate don't know about CaseType enum? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
