Thank you sir... I did see that, but was unsure whether a list of enums was considered a "component".
On Dec 16, 6:59 pm, "Ayende Rahien" <[email protected]> wrote: > http://www.hibernate.org/117.html > > On Tue, Dec 16, 2008 at 9:41 PM, adressin <[email protected]> wrote: > > > Hello, > > > We have an enum that we use for Roles, which are associated to a > > User: > > > public class User > > { > > private IList<UserRoles> roles; > > > public virtual IList<UserRoles> Roles > > { > > get { return roles; } > > set { roles = value; } > > } > > } > > > public enum UserRoles > > { > > Admin, > > Purchasing, > > ... > > } > > > We map this in hbm file as: > > > <bag name="UserRoles" table="APP_USER_ROLES" lazy="true" > > fetch="select"> > > <key column="USR_ID"/> > > <element column="ROLE_ID" type="Core.Domain.UserRoles,Core.Domain"/> > > </bag> > > > I am trying to create a criteria query with an "in" statement that > > goes against the UserRoles property using just a list of ints: > > > IList<int> rolesToQuery = new List<int>(); > > rolesToQuery.Add(1); > > rolesToQuery.Add(2); > > > DetachedCriteria hibernateCriteria; > > ... > > ... > > hibernateCriteria.CreateCriteria("UserRoles", "uRoles").Add > > (Restrictions.InG<int>("uRoles", criteria.Roles)); > > > This fails with: collection was not an association. > > > Any ideas how to do this query using criteria api? > > > Kind Regards, > > Aaron > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
