Is it possible to set the actual SQL that the entity framework provider will execute?

Question

Hi,

My entity framework provider (CoreLabs/Mysql/devart) is creating ridiculously slow queries.

is it possible for me to set the actual sql query that will be executed?

Thanks

Answer 1

Yes, one way is with the ObjectQuery.ToTraceString API.

Answer 2

its funny, i was just watching LINQPad - New Features for Entity Framework. half way through the webcast, he showed the script generated by the EF and the same query generated by Linq-To-Sql; the linq-to-sql generated script was way more efficient. Now i don't know if using linq-to-sql is an option for you but i thought you should know,

in regards to your question, as i understand the whole point of EF and Linq-to-sql to avoid programmers writing TSQL in strings, doesn't force feeding your own SQL command kind of defeat the whole purpose of EF and Linq-to-sql?