Extends the basic Connection class to provide a transacted Connection instance that operates within the bounds of a .NET Scoped Transaction. The default Session creation methods of Connection are overriden here to always return a TX capable session instance.