Auto Cache Option (RSSBus.GoogleSheets Data Provider)

Controls automatic caching of data returned by the provider.

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the provider automatically caches the results of SELECT queries to a cache specified by the CacheLocation option.

Non-queries, such as UPDATE/INSERT/DELETE statements on the original tables will not modify the data in the cache at all, regardless of the value set for AutoCache.

Note that while Offline is TRUE, the RSSBus ADO.NET Provider for Google Spreadsheets ignores AutoCache.