Does ADO.NET support multi-subnet failover for SQL connections, and how does this feature compare to ODBC's multi-subnet failover support?

YONG Chee Wee 1 Reputation point
2024-06-10T10:06:11.2266667+00:00

I am using ADO.NET for SQL connections. Does ADO.NET support multi-subnet failover? I understand that ODBC supports multi-subnet failover. Can you explain the difference between ADO.NET and ODBC in this regard?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,545 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,121 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 104.2K Reputation points MVP
    2024-06-10T20:46:28.96+00:00

    Depends on what you mean with ADO .Net, but I will assume that you mean SqlClient. And, yes, SqlClient suppotrs MultiSubnetFailover, see https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/sqlclient-support-for-high-availability-disaster-recovery

    I would expect any differences between SqlClient and ODBC with regards this connection-string property. But since they are different implementations, there may be subtle differences.