The issue was using the original System.Data.SqlClient, I changed to Microsoft.Data.SqlClient, and the connection was held.