How can I see the Entity Framework's pending changes?


I'm creating an application with the ADO.NET Entity Framework.

I can step through my code line-by-line while debugging and watch SQL Server Profiler for every query executed, but I can't figure out where all those SQL commands are coming from!

Sometimes when I execute SaveChanges(), the Entity Framework performs unexpected, weird INSERTS. They sometimes break the application. I can't figure out what I'm doing to cause them.

How can I monitor the pending changes that queue up waiting for a SaveChanges() call?

7/1/2017 7:11:50 PM

Since Entity Framework 5.0 DbContext has a ChangeTracker property which has all pending changes. Similar to the ObjectStateManager you can get entities in various states as follows:

myDbContext.ChangeTracker.Entries().Where(e => e.State == EntityState.Added);
myDbContext.ChangeTracker.Entries().Where(e => e.State == EntityState.Deleted);
myDbContext.ChangeTracker.Entries().Where(e => e.State == EntityState.Modified);
8/11/2014 10:07:49 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow