Printing Entity Framework Linq query as a string

Question

I would like to be able to log long running entity framework linq queries so I can investigate what is being generated. I have found that having an Entity Framework linq query and if I hover my mouse over it in the Visual Studio debugger, it shows me a string representation of the generated SQL that the entity framework will send to the SQL server.

I am wondering how it would be possible to get this string so I could print it out to a log file?

you also can use Linqpad, which supports to generate sql from your dbcontext — John Liu
– John Liu, Commented Mar 13, 2013 at 19:42

Wahid Bitar · Accepted Answer · 2013-03-13 18:09:29Z

3

Did you try ToString();

var query = context.Products.Where(p=>p.IsActive);
var queryText = query.ToString();

answered Mar 13, 2013 at 18:09

Wahid Bitar

14.1k13 gold badges83 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lehn0058 Over a year ago

Wow... no I had not! I had read that it didn't work, though that was for an earlier version of the framework than what I am using. That should work perfectly - thanks!

Aron · Accepted Answer · 2013-03-13 18:03:51Z

0

Take a look at this logging provider for Entity Framework

answered Mar 13, 2013 at 18:03

Aron

15.9k3 gold badges35 silver badges71 bronze badges

Collectives™ on Stack Overflow

Printing Entity Framework Linq query as a string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related