When should I use Compiled LINQ vs Normal LINQ

Question

I just read about LINQ performance, and there is a huge amount you can get with Compiled LINQ.

Now, why don't I always use compiled LINQ?

Answer 1

Short answer: when it happens only once for a long time.

Long Answer .

Answer 2

You should use it when some kind of linq query is executed most of the time. They can be converted to compiled lynq. Performance will be improved since the query execution path will be set at compile time. I used it in my project, and the performance climbed by notches.