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
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/lwATNBQptLYJ.
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.
