Caching Data

Because some data sources are slow to query against, the RSSBus ADO.NET Provider for OData supports a simple caching model that can improve the performance of data queries. The caching support is only provided for Tables or Views, but not for Stored Procedures. See Data Model for more information.

Caching works by storing data into a local database in the user's system. This database is persistent and can be shared by multiple connection objects over time. By default, this database will be stored in the same directory where the Data Scripts are located, but this location can be explicitly defined in the CacheLocation option in the ConnectionString.

Internally, the cache database will contain each table exposed by the Data Model of RSSBus ADO.NET Provider for OData. Caching Automatically is accomplished by setting the AutoCache option to true in the ConnectionString or use the CACHE SQL statement to load data into the cache.

Explicit caching is also possible by using CACHE Statements. It is best to keep in mind some Caching: Best Practices while using various caching mechanisms.