Caching NHibernate Named Queries
- by TStewartDev
I recently started a new job and one of my first tasks was to implement a "popular products" design. The parameters were that it be done with NHibernate and be cached for 24 hours at a time because the query will be pretty taxing and the results do not need to be constantly up to date.
This ended up being tougher than it sounds.
The database schema…