Nhibernate get collection by ICriteria

Posted by Andrew Kalashnikov on Stack Overflow See other posts from Stack Overflow or by Andrew Kalashnikov
Published on 2010-03-22T08:02:51Z Indexed on 2010/03/22 8:31 UTC
Read the original article Hit count: 404

Filed under:
|

Hello, colleagues. I've got a problem at getting my entity. MApping:

     <?xml version="1.0" encoding="utf-8" ?>
    <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
           assembly="Clients.Core"
           namespace="Clients.Core.Domains">
     <class name="Sales, Clients.Core" table='sales'>
        <id name="Id" unsaved-value="0">
          <column name="id" not-null="true"/>
          <generator class="native"/>
        </id>
        <property name="Guid">
           <column name="guid"/>
         </property>
        <set name="Accounts" table="sales_users" lazy="false">
            <key column="sales_id" />
            <element column="user_id" type="Int32" />
        </set>
     </class>

Domain:

   public class Sales : BaseDomain
   {
        ICollection<int> accounts = new List<int>();
        public virtual ICollection<int> Accounts
        {
            get { return accounts; }
            set { accounts = value; }
   }
    public Sales() { }           
   }

I want get query such as

SELECT * 
 FROM sales s 
 INNER JOIN sales_users su on su.sales_id=s.id 
 WHERE su.user_id=:N

How can i do this through ICriterion object?

Thanks a lot.

© Stack Overflow or respective owner

Related posts about nhibernate

Related posts about collection