Get underlying linq query for FirstOrDefault with Entity Framework 5 (Code First)

Asked Nov 19 '14 at 10:52

Active Nov 19 '14 at 10:52

Viewed 434 times

I can log the underlying query of a linq query by simply using the ToString() method.

string raw = query.Where(..whatever..).ToString();

I need the exact underlying query for the FirstOrDefault() method

query.FirstOrDefault().ToString()

because we get a very bad performance for this query and we want to analyze it. Here the ToString() method only returns the class name.

Is there a possibility to get the underlying query?

asked Nov 19 '14 at 10:52

StefanG

Have you considered using an sql profiler? – Andrei Nov 19 '14 at 10:57
Yes that's the way we do it now, but I would prefer to log it from code. – StefanG Nov 19 '14 at 11:00
See: http://msdn.microsoft.com/en-us/data/dn469464.aspx – Marthijn Nov 19 '14 at 13:48
@Marthijn Yes, I know, but this is only a option for EF 6. We are using EF 5. – StefanG Nov 19 '14 at 14:05
In that case: http://stackoverflow.com/questions/1412863/how-do-i-view-the-sql-generated-by-the-entity-framework and http://msdn.microsoft.com/en-us/magazine/gg490349.aspx – Marthijn Nov 19 '14 at 15:10
@Marthijn Written in the answers comment: "You won't get SQL for queries ending with .Single(), .Count(), .Any(), etc. that way" – StefanG Nov 19 '14 at 16:37
@StefanG too bad, didn't know – Marthijn Nov 19 '14 at 19:25

0 Answers0