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?
Solution 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);
Solution 2:
Take a look at
myObjectContext.ObjectStateManager.GetObjectStateEntries(EntityState.Added)
here.