In this post I will show you to use DebugView to log the Entity Framework. For detail discussion on the same topic you may want to learn more here:
Logging in Entity Framework on Steve Smith Blog
Profiling Database Activity in the Entity Framework by Julie Lerman
Download DebugView , unzip it and Run it as administrator. In Capture menu select the options as shown in below image,
Once the debugview is configured, you should configure the DataContext class as shown below. Enable database log to print on the debug window.
As the last step run the application using Entity framework without using Visual Studio or without attaching Visual Studio Debugger. In Visual Studio run the application using Ctrl+ F5. You should able to view the Entityframework log in Debugview as follows:
The Debugview can be your good friend when you stuck with performance issues and want to log the queries.
Happy Coding.
Leave a Reply