Hi, 
how can I use IN expression with a collection?
Code:
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
   <class name="Entities.BusinessRegisterCompany, Entities" table="BusinessRegisterCompanies">
      <id name="ID" column="CompanyID" type="int" unsaved-value="0">
         <generator class="identity" />
      </id>
    <bag name="Groups" lazy="false" table="BusinessRegisterCompaniesGroups">
      <key column="CompanyID"/>
      <many-to-many class="Entities.BusinessRegisterGroup, Entities" column="GroupID"/>
    </bag>
   </class>
</hibernate-mapping>
Code:
string groups = "123,abc";
ICriteria criteria = NHibernateHelper.GetCurrentSession().CreateCriteria(typeof(T));
ICriterion[] cri = new ICriterion[1];
cri.SetValue(Expression.In("Groups", groups.Split(',')), 0);
criteria.Add(cri);
return criteria.List<T>();
Just getting: Cannot use collections with InExpression