You create an Entity Data Model to access data from a Microsoft SQL Server database. You use Entity SQL to retrieve data. Several Entity SQL queries are used repeatedly. You need to ensure that after one of these queries is executed, it can be subsequently executed with minimal cost to performance.

What should you do?

Compiled queries can make a valuable performance improvement for queries that are used repeatedly in an application. You will still pay the compilation cost the first time the query is used, but subsequent uses of the query will avoid that part of the process. Query plan caching is enabled by default. When using query plan caching, avoid dynamically generated queries because caching will use memory for cache entries that are unlikely to be reused.