How to get NHibernate ISession to cache an entity not retrieved using the primary key

Question

My user object is almost always retrieved by username, and not by its whole surrogate key. Since the username is not a primary key, this means that ISession will not cache it and repeatedly enters the database to obtain the same data.

Is there any way to configure NHibernate to force ISession to cache users retrieved by username?

Answer 1

There seems to be no real answer. Yes, if you use a second level cache, no if you use a session cache.

Answer 2

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

Answer 3

The "session cache" is not really a cache, but an entity map.

My suggestion is that you activate the second level cache for requests using a custom provider that stores items in an HttpContext.