In EF 4.1 DbContext how to trace generated SQL

sql logging entity-framework-4 entity-framework-4.1 trace
Chance picture Chance · Apr 9, 2011 · Viewed 10.3k times · Source

I wonder how to trace generated SQL like DataContext in LinqToSql.

I also read articles about the solution of EFProviderWrapper on Jaroslaw Kowalski's blog, but it is based on ObjectContext, does not work for DbContext.

Anyone know how to do this in DbContext?

Thank you.

Answer

Slauma picture Slauma · Jul 19, 2011

The easiest way with DbContext and DbSet<T> is just to use ToString() on the IQueryable you have built. For example:

var query = context.Blogs.Include(b => b.Posts)
                   .Where(b => b.Title == "AnyTitle");

string sql = query.ToString();

sql contains the SQL command which will be issued to the DB when the query gets executed.

Related questions

How can I log the generated SQL from DbContext.SaveChanges() in my Program?

According this thread, we can log the generated SQL via EF, but what about DbContext.SaveChanges()? Is there any easy way to do this job without any extra frameworks?

Read More
Log the actual SQL query using ActiveRecord with Yii2?

I'm doing this: $students = Student::find()->all(); return $this->render('process', array('students' => $students)); and then this in the view: foreach($students as $student) { echo $student->name . ', &nbsp;'; echo $student->getQuizActivitiesCount(); ?&…

Read More
How to log SQL statements in Grails

I want to log in the console or in a file, all the queries that Grails does, to check performance. I had configured this without success. Any idea would help.

Read More