Nhibernate Multiple join

18 views
Skip to first unread message

Deepz

unread,
Mar 12, 2012, 1:29:16 AM3/12/12
to nhu...@googlegroups.com


Hi All,

I am relatively new to Nhibernate,I am trying to create join between multiple table.However I am not 
sure about how to mention the join like Sql say for.. 

Eg:-

select * from user a
join userrolemap b on a.userid=b.userid
join userrole c on c.roleid=b.roleid
join   userorganisationmap d on d.userid=a.userid


I try this in nhibernate createcriteria like this....

 ICriteria Query = session.CreateCriteria(typeof(user), "usr")
                                .CreateCriteria("userRoleMaps", "usrm", JoinType.InnerJoin)
                                .CreateCriteria("userRole", "usrr", JoinType.InnerJoin)
                                .CreateCriteria("userOrgMap",orgmap, JoinType.InnerJoin)
                                .CreateCriteria("organization", "org", JoinType.InnerJoin)


but in the userOrgMap table it tries to map in the table userRole.And I am really confused how to go from here.
please help me.



Many Thanks

Deepak.vs


                     










Reply all
Reply to author
Forward
0 new messages