192 votes12 comments · [Closed] Entity Framework Core Feature Suggestions · Flag idea as inappropriate… · Admin →Eric supported this idea ·Eric commented
I have a dynamic query that changes the number of joins based upon the number of keywords passed in and the query timesout...it never completes via EF. Without even specifying an option the same SQL running in SSMS executes in 3 seconds. We must have the ability to pass query hints or this ORM like many others will be useful only in silo projects with small databases. We need a solution for real world problems.