Gustavo Ringel has a post about that :

http://gustavoringel.blogspot.com/2009/04/using-tag-in-nhibernate.html


2009/9/29 Markus Zywitza <[email protected]>

> 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