There are two different behavior for Routing in SqlClient
in .Net inside SqlInternalConnectionTds we have
if (routingAttempts > 0)
{
throw SQL.ROR_RecursiveRoutingNotSupported(this);
}Where as the same place in .NetFramework we have
if (routingAttempts > _maxNumberOfRedirectRoute)
{
throw SQL.ROR_RecursiveRoutingNotSupported(this);
}_maxNumberOfRedirectRout is 10
There are two different behavior for Routing in SqlClient
in .Net inside SqlInternalConnectionTds we have
Where as the same place in .NetFramework we have
_maxNumberOfRedirectRoutis 10