http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660ionel, Please check the documentation for AR, it is all there. The documentation for NH attempts to use plain NHibernate API to maximize relevance . http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment3http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment3Mon, 05 Jan 2009 20:48:39 GMTI have read the user guide og NH Prof and see the samples are for NH. If I use AR, how do I get the "session" object ? More exactly, how would you translate the following using AR? // SELECT * FROM Posts foreach (Post post in session.CreateQuery("from Post").List()) { //lazy loading of comments list causes: // SELECT * FROM Comments where PostId = @p0 foreach (Comment comment in post.Comments) { //print comment... } } Thanks. http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment2http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment2Mon, 05 Jan 2009 20:28:12 GMTYes, it's comforting to see how the cache is working for you. I may have to shell out for this thing... http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment1http://ayende.com/3795/nh-prof-feature-the-2nd-level-cache#comment1Mon, 05 Jan 2009 15:30:59 GMT