Context managers

[eavanvalkenburg]

I would love to see correct managers on both the connection, the cursor but also on a transaction, where the exit commits a transaction

[LarnuUK]

Context Managers on the connection, and that they didn't dispose of the connection, when used with pyodbc was something that bugged me. It would be great to see context managers added to connection added to mssql-python and that they dispose of the connection, like the change that was made to Psycopg 3.

[sumitmsft]

Hello @eavanvalkenburg - Thanks for reaching out to us. We wanted to let you know that we have started the development of Context Manager feature now. Soon, we will be releasing it. Please stay tuned!

Appreciate your early feedback.

@LarnuUK - I think we are on the same page regarding your concerns :)

[sumitmsft]

This is merged and will be released in v0.10.0.