Use Table Caching using MySqlConnection

Connection string

This MySQL Connector/Net connection string can be used for connections to MySQL.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
tablecache=true;DefaultTableCacheAge=30;

Specifying DefaultTableCacheAge is optional, default value is 60 seconds.

This option is available from Connector/NET version 6.4