Connect On Open
This property species whether to connect to the SQL Server when the connection is opened.
When set to true, a connection will be made to SQL Server when the connection is opened. This property enables the Test Connection feature available in various database tools.
This feature acts as a NOOP command as it is used to verify a connection can be made to SQL Server and nothing from this initial connection is maintained.
Setting this property to false may provide performance improvements (depending upon the number of times a connection is opened).