hello -- you might already be aware that the driver they use will have an impact?
But just in case here's the link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-client-connectivity-sql-server
e.g.
Driver | Multi-Subnet Failover | Application Intent | Read-Only Routing | Multi-Subnet Failover: Faster Single Subnet Endpoint Failover | Multi-Subnet Failover: Named Instance Resolution For SQL Clustered Instances |
---|---|---|---|---|---|
SQL Native Client 11.0 ODBC | Yes | Yes | Yes | Yes | Yes |
SQL Native Client 11.0 OLEDB | No | Yes | Yes | No | No |
ADO.NET with .NET Framework 4.0 with connectivity patch* | Yes | Yes | Yes | Yes | Yes |
ADO.NET with .NET Framework 3.5 SP1 with connectivity patch** | Yes | Yes | Yes | Yes | Yes |
Microsoft JDBC driver 4.0 for SQL Server | Yes | Yes | Yes | Yes | Yes |