Log all linq queries executed on DbContext - C#

Question

Is there a simple way to log all linq queries executed in an application?

I am currently using code first entity framework with a DbContext instead of the older DataBaseContext.I know for a fact that the DataBaseContext class has a Log property, but i do not know if there is something like the log property for the DbContext.

No EF unfortunately doesn't have any build in logging. You must use SQL profiler, EF related profiler or you must write EF provider wrapper which will do that. — Ladislav Mrnka
– Ladislav Mrnka, Commented Jan 17, 2013 at 9:48

Anatolii Gabuza · Accepted Answer · 2013-01-17 10:05:29Z

1

You can use .ToString() on IQueryable queries that you'll create. It will return SQL statement that will be executed on DB.
Then if you're using Repository pattern you can implement your logging logic without using any third-party libs.

edited Jan 17, 2013 at 10:05

answered Jan 17, 2013 at 10:00

Anatolii Gabuza

6,2902 gold badges39 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Log all linq queries executed on DbContext - C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related