CODEWITHSUNDEEP
c#linqentity-framework-6compiled-query
Aashish Kumar
Aashish Kumar

Reputation: 1643

Is all the query in Entity framework 6 is already compiled?

I want to optimized my queries in Entity Framework 6.1.3, so I need to know that whether queries are already CompiledQueries or I need to write them manually as CompiledQuery?

Thanks in advance.

Upvotes: 11

Views: 9493

Answers (1)

s3raph86
s3raph86

Reputation: 566

No, they are not. You'll need to specify that you want to use a CompiledQuery.

That said, using a compiled query will only provide a 7% performance improvement. If tuning performance of EF really is a major issue for you, I recommend reading the following:

https://msdn.microsoft.com/en-us/data/hh949853

Upvotes: 5

Related Questions