Checking if MySQL connection is lost?

hery there.

if want to check if i get a connection lost in my mysql connection. What i do:

onload:
_mySqlConnection = _mySql.OpenDb("...", this);

onunload:
_mySql.CloseDb(_mySqlConnection);

so now i want to check in a timer if the connection already etablished. if not i want to do a reconnect

Code:

        void timer_sqlcon()
        {
            if (!closing)
            {
                timer.Once(1, () =>
                {
                    if(connection == null)...
                   {
                   }
                    timer_sqlcon();
                });
            }
        }

the reconnect is no problem but i cant find a way to check if the connection is lost.

Thanks for help

 

Try executing any simple query, let's say SELECT 1;
I used that practice to verify connections in the pool.