We know SQL connection lifetime is 60 seconds for idle connections.
If I set the lifetime of my ADO.NET connection object to 500 seconds. And the connection sits idle in the pool for say 150 seconds. Will SQL shuts down its side of the connection?
If yes, well, that's easy I will know that the ADO.NET is dead from the exception thrown next time i use it.
If not? how does ADO.NET overrides the SQL side lifetime limit?
Am I making sense or am I connecting too totally different concepts?
Thank you