http://ayende.com/Blog/archive/2009/06/23/nhibernate-ltnatural-idgt.aspx

2009/9/26 liquidvapour <[email protected]>

>
> Hi All
>
> In my project I have a Member class that looks something like this:
>
> class Member
>    int Id (Primary Key,  for DB only)
>    string UserCode (Unique, used by the outside world to retrieve the
> Member)
>    ...
>
> For the purposes of my domain model I get the Members by their
> UserCodes quite a few times within one NHibernate Session. Once at the
> begining of the request to put their Roles into the secutity system
> and then again for each service call.
>
> I thought this would not be a problem as NHibernate would see that I
> had already retrieved that member and not hit the DB to get it again.
> However I have now realised that as I am not getting the Member by its
> primary key (id) but by a secondary unique column (userCode) so
> NHibernate does not use the Unit of Work / identity map and hits the
> DB again. Although it does mainting reference equality, which is good.
>
> Is there a way to tell NHibernate that even though I am not fetching
> by the primary key the UserCode can also be considered an identifying
> column? So if I've fetched a Member with userCode="X" another fetch
> for Member.userCode="X" in the same session will not hit the DB again.
>
> I have tried using the unique="true" attribute in the property element
> in the mapping file but this does not seem to help with this issue.
> Its also undocumented AFAICT so i'm not sure what it should do.
>
> I suppose one solution is to keep my own UserCode to Id map in my
> MemberRepository so the first call to GetByUserCode will get the
> Member by UserCode and see what its Id is and then the subsequend
> calls will re-route to GetById(). However I would feel much more warm
> and fuzzy if I could get NHibernate to do this for me.
>
> Comments, questions or sugestions most welcome.
>
> Thanks
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to