The CData ADO.NET Provider for QuickBooks exposes caching features that can be used to avoid the delay of executing commands over the network, to create applications with offline functionality, to use a particular SQL dialect, and more. Caching can be transparent to the application. This article shows how to enable the Auto Cache feature to meet one of the common use cases for caching: to provide fast reporting from the cache, even when working with large data sets.
You can download the sample application to see how to create a complete application using the code examples in this article. The included sample project integrates the basic components of an effective caching solution with a simple application that displays the current QuickBooks data.