See comments from #3555 regarding some docs we should add to help explain existing behaviour: https://github.com/dotnet/SqlClient/pull/3555#discussion_r2304875607 https://github.com/dotnet/SqlClient/pull/3555#discussion_r2304899495