This feature exists with Connector/Net versions 6.4 and above.
Table caching is a feature that can be used to cache slow-changing datasets on the client side. This is useful for applications that are designed to use readers, but still want to minimize trips to the server for slow-changing tables.
This feature is transparent to the application, and is disabled by default.
To enable table caching, add
cache = true' to the connection string.
Optionally, specify the
Table Cache Age' connection string option,
which represents the number of seconds a table is cached
before the cached data is discarded. The default value is
You can turn caching on and off and set caching options at runtime, on a per-command basis.