add RAII connection type

class auto_connection will disconnect the managed connection
object when it goes out of scope.