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