Is the technique at the end of this documentation useful? Alternatively, I’ve avoided many of the performance pitfalls using a fluent interface to declaratively state which entities in a given transaction for sure won’t change vs. might change (immutable vs. immutable). For example, if the entities I am saving are aggregate roots in which the … Read more
Here is how to find all the changed many-to-many relationships. I’ve implemented the code as extension methods: public static class IaExtensions { public static IEnumerable<Tuple<object, object>> GetAddedRelationships( this DbContext context) { return GetRelationships(context, EntityState.Added, (e, i) => e.CurrentValues[i]); } public static IEnumerable<Tuple<object, object>> GetDeletedRelationships( this DbContext context) { return GetRelationships(context, EntityState.Deleted, (e, i) => e.OriginalValues[i]); … Read more
Try changing your context constructor to this: public ReportingContext() { this.Configuration.AutoDetectChangesEnabled = false; } EDIT: This will after all not help you, as stated on Arthur’s blog, it is usable only in particular scenarios: http://blog.oneunicorn.com/2012/03/12/secrets-of-detectchanges-part-3-switching-off-automatic-detectchanges/
One way is to have a MyTableNameHistory for every table in your database, and make its schema identical to the schema of table MyTableName, except that the Primary Key of the History table has one additional column named effectiveUtc as a DateTime. For example, if you have a table named Employee, Create Table Employee { … Read more
When you load the entity from the context it keeps an additional data structure – let’s call it entry. The entry contains two set of values – original values and current values. When you execute the SaveChanges operation EF goes through your customer entities and updates current values in the entry so that they match … Read more
Since this question is not tagged with a specific EF version, I wanted to mention that in EF Core the behavior can be configured at the context level. You can also change the default tracking behavior at the context instance level: using (var context = new BloggingContext()) { context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; var blogs = context.Blogs.ToList(); … Read more