How do I know what does EF translate Linq queries into?

Question

On many sites/blogs I noticed that people, who want to explain linq mechanism, write Linq Queries and provide SQL translation for that. How can I get the translation for my own queries? I'm working with EF .Net 4.0 in VS2010. Is there a place (property or even some third-party tool) where I can see what they're being translated into? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You can use the ObjectQuery.ToTraceString method: var query = ... string sql = ((System.Data.Objects.ObjectQuery)query).ToTraceString(); However, some shortcomings of this approach is that it will only show queries, not updates/inserts/deletes. Also, it won't reveal the parameters used. If you need as much detail as possible from the query then use the SQL Server Profiler as Neil suggested. Julie Lerman has a good article with different options on MSDN: Profiling Database Activity in the Entity Framework. She mentions: ObjectQuery.ToTraceString method Visual Studio 2010 Ultimate's IntelliTrace EFTracingProvider