Test bug fix

Added ConnectionReleaseMode.OnClose to nhibernate cfg in the
SessionMangerTests.
Disposing of transaction.

Disposing of the transaction in the DisposeOfSession method.