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

Question

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?

Answer 1

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);