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 -~----------~----~----~----~------~----~------~--~---
