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.
While working on an application, I had to commit changes to local Git Repository. It was usual task and I started with following command,
git add –A
To surprise git add command gave me error as shown in image below. Error message was clear that to a particular file there was Permission denied.
Note: I was working on a MVC application which had local database attached. Name of database was MoviesRTM.mdf.
I tried to commit using Visual Studio 2013 as well. Here also I got same error as shown in image below,
This can be solved by two ways either shutting down IIS Express or restarting Visual Studio. I was using IIS Express to host MVC application. You can shut down IIS Express by right click on IIS Express and click on Exit from context menu.
If this option is not working then try restarting Visual Studio.
Note: Restarting Visual Studio or Shutting down IIS Express may worked in this scenario because permission denies error was on a database file (extension mdf). And database was locally created.
After shutting down I was able to run git add command successfully.