Speeding up LINQ to SQL queries
c#, linq, sql
Solution
There is one helpful thing about LINQ that every developer should know. It is about performance of Join vs Where.
The full discussion can be seen here why is join so much faster than where
Problem
What are the common things that we can keep in mind while writing the LINQ to SQL query for optimizing or speeding up the LINQ to SQL?. For example, ordinarily, LINQ to SQL must translate LINQ queries to SQL every time a query executes; this involves recursing the expression tree that makes up the query in several stages. What we do is like precompiling the query using the `CompiledQuery` class.