Devart Forums

How do I set a session/connection level server variable in the mysqlconnectionstringbuilder?

I want to set net_read_timeout from its default of 30 to say 900.

Thanks,
Don Bouchard

The default command timeout of MySqlCommand is 30 second. For more information, please refer to https://www.devart.com/dotconnect/mysql ... meout.html

You can set a larger value for this property to avoid the "Lost connection to MySQL server during query" error.

You can also specify a larger value of the 'Default Command Timeout' parameter in the connection string. In this case, for all MySqlCommands that use this connection, the CommandTimeout property value will be equal to the one you have specified in the connection string by default.
For more information, please refer to:
http://www.devart.com/dotconnect/mysql/ ... tring.html
http://www.devart.com/dotconnect/mysql/ ... meout.html