What are compiled queries?

 Posted by ArticlesMaint on 9/29/2009 | Category: LINQ Interview questions | Views: 3998

LINQ has provided something called as compiled LINQ queries. In compiled LINQ queries the plan is cached in a static class. As we all know that static class is global cache. So LINQ uses the query plan from the static class object rather than building the preparing the query plan from scratch.

Figure: - LINQ Query Caching

In all there are 4 steps which need to be performed right from the time LINQ queries are built till they are fired. By using compiled LINQ queries the 4 steps are reduced to 2 steps.

Figure: - Query plan bypasses many steps

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response