Application which has the bug is using System.Data.SqlClient (ado.net) to make database connection with SQL Server 2014.Database connectivity works fine with normal connection string however whenever I add MultiSubnetFailover = True in order to configure the application to support multi subnet failover, application throws an database connection error as mentioned below. While same connection string works fine on windows machine ( with .Net Framework without mono). Application is deployed on both Windows and Linux and this error occurs in both the environments.
This connection which is used in the application:
connectionString="Data Source=********; User ID=********; Password=********; Initial Catalog=********; Connection Timeout=300; MultiSubnetFailover=true"
Error which is thrown when MultiSubnetFailover=true used:
ExecuteGetDataTable Exception : System.ArgumentException: Keyword not supported : 'multisubnetfailover'.
at System.Data.SqlClient.SqlConnection.SetProperties (System.String name, System.String value) [0x00000] in <filename unknown>:0
at System.Data.SqlClient.SqlConnection.SetConnectionString (System.String connectionString) [0x00000] in <filename unknown>:0
at System.Data.SqlClient.SqlConnection.set_ConnectionString (System.String value) [0x00000] in <filename unknown>:0
at System.Data.SqlClient.SqlConnection..ctor (System.String connectionString) [0x00000] in <filename unknown>:0
at (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlConnection:.ctor (string)
Please help and advice.
Mono 5.10 has significantly improved System.Data implementation which should resolve this issue. If you can still reproduce it please reopen the issue.