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?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 872 | Points: 40
Select from following answers:
  1. Ensure that query plan caching is enabled and avoid dynamic queries.
  2. Ensure that query plan caching is enabled and use dynamic queries over static queries when possible.
  3. Disable query plan caching and use dynamic queries over static queries when possible.
  4. All Above

Show Correct Answer


Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response