Christian Bauer wrote: > Maybe NHibernate only needs two modes. NHibernate probably only need > to release either after transaction (also auto-committed) and when > the Session is closed. By the way, after reading the Hibernate source, it looks to me that auto-commit mode connection release only happens for a few operations on the session, not all of them (for example refresh, lock, get with LockMode seem to be exempt). Was this intended (why?) or was this an oversight? > With a Java transaction manager we have to > give back the connection after every SQL statement. The service > guarantees that we will get back "the same" connection inside the > same transaction, for the next SQL statement. Is that common in .NET > environments? > As far as I know, it is not. Sergey