Is there a way to detect when a certain entity is added to the database in Entity Framework 6?

Question

Let's say I have an entity called X. Whenever a new X entry is added to the database in any part of my code (db.Xs.Add(new_X_instance);) I want to execute a specific sql query using entity framework. I wonder if this is possible. Just to let you know, I am not able to use SQL Server triggers.

Answer 1

You can override SaveChanges() method in DbContext class and in there you can get a list of new added entities.

public override int SaveChanges()
{
    var AddedEntities = ChangeTracker.Entries<Entity>().Where(E => E.State == EntityState.Added).ToList();

    AddedEntities.ForEach(E => 
    {
        // Do whatever you like !
    });

    return base.SaveChanges();
}