Support within-connection/transaction locks #1

Right now, each sql lock creates a new connection. We could additionall offer constructors taking in a DbConnection / DbTransaction. In this case, disposal would call release instead of just closing the connection