The MultiSubnetFailover option in database connection strings controls how the client attempts to connect to a database server, especially when multiple IPs are available.
There is conflicting documentation as to whether the correct connection string syntax is:
MultiSubnetFailover=Yes
Or:
MultiSubnetFailover=True
Are both "Yes" and "True" supported? Or does it vary by driver? If the latter, is there a list of which drivers support which syntax?
Update 2023-03-30:
This Microsoft documentation implies that "True" or "Yes" will work for another option:
The default setting for the Persist Security Info keyword is false. Setting it to true or yes allows security-sensitive information, including the user ID and password, to be obtained from the connection after the connection has been opened. Keep Persist Security Info set to false to ensure that an untrusted source does not have access to sensitive connection string information.
https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax
(emphasis added)