http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660That's true for connections, but you still have to take care for opening/closing your transactions appropriately, whilst the TransactionProxyFactoryObject will decorate particular methods with begin/commit/rollback calls without any further efforts. http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment3http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment3Mon, 05 Feb 2007 12:08:47 GMT@Harald, Actually, NHibernate 1.2 Beta 3 will manage the open/close of the connection for you, so it is much easier to handle the lazy load stuff. http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment2http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment2Mon, 05 Feb 2007 08:13:43 GMTI haven't worked with iBatis either, hence I cannot make a judgement, but I've done enough desktop app projects with NHibernate to ensure you that all these statements are bogus, as you already pointed out. There is one possible problem that might prevent the "lazy guy" from adhering to the session-per-connection pattern which can lead to such a design: You have to know what you need in advance, deffered lazy loading won't work if the session is already closed again. This is partially NHibernates fault as figuring out which object/collection caused a LazyInitialitationException is not always easy as you therefore need to know how and where the object was loaded in first place. Also using a second level cache in desktop apps is not always a good idea, as cache coherence cannot be guaranteed if you have multiple instances of a particular application working with the same database. That's of course a minor issue when you're only using in-memory databases like sqlite or sqlserver ce. Regarding your simple things to remember, I almost always use the Spring.NET TransactionProxyFactoryObject which takes care of session and transaction handling. But as always, the more you hide, the more you have to know whats going on behind you. http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment1http://ayende.com/2062/ibatis-better-than-hibernate-for-gui-applications#comment1Mon, 05 Feb 2007 07:59:22 GMT