TransactionProvider should be supported on client side

We should support automating TransactionManagement for the Client side as well as for in container.

A TransactionProvider could register it self to be in Client context. This will allow for embedded service containers to provide their own hooks without reloading the AuxiliaryArchives as it's done by Remote Containers.