The Cache Control builder is the tool you use to cache the results of a database query.
This builder allows you to store the results of a model action, such as a method that initiates a database call. Results of the action are placed in the model's output cache and are available to multiple users having the same profile. In database operations this means that a single query can be used to service multiple users, providing those users have similar profiles. This minimizes unnecessary trips to the database and reduces system load.
This type of caching is appropriate for data that does not change too frequently (once per hour) and also data that is identical for a number of users. A typical example of data that might benefit from caching is employee data accessed by an HR department group.
Parent topic: Building an SQL statement: wpf7