How can I use "Validate Connection = true" as a connection string property in the web.config file? My connection string is like
<add name="ConnectionString" connectionString="Data Source=X.X.X.X/orcl;User Id=XXX;Password=XXX"/>
It works but sometimes server returns a non-active connection from the pool when I try to open a connection. I don't always want to check if the connection is alive. I have found Validate Connection property from Oracle documentations. I need to add "Validate Connection" property setted to true. So I try
<add name="ConnectionString" connectionString="Data Source=X.X.X.X/orcl;User Id=XXX;Password=XXX;Validate Connection = true"/>
but I get System.ArgumentException: 'Validate Connection' is an invalid connection string attribute.
How can I use this property properly? Couldn't find any working example.