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

c# compiled-query entity-framework-6 linq

Question

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.

1
7
11/3/2016 7:02:17 AM

Popular Answer

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

2
11/3/2016 6:50:33 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow