On SQL Server, I'm trying to prevent connection from staying open. From here I understand that
Connection Lifetime allows a connection to stay alive for a certain period of time since it was opened.
When a connection is returned to the pool, its creation time is compared with the current time...
Is there a way to do something similar, but with connections who are idle? When they return to the pool they'd be allowed to live for X seconds until killing them, unless they're used again.