Trigger does not fire after insert using Entity Framework with MVC4 SQL Server

I had the same problem using Entity Framework with SQL Server Database.

For the trigger to be fired on the database you need to send the 'commit' using 'TransactionScope' after 'db.SaveChanges();' command.

I am using the Entity Framework Core library. Here is an example:

using (var ts = new TransactionScope())
{
    using (var db = new DbContext()) // Modify to you Context Class
    {
        // Your logic code
            
        db.MyModel.Add(model);
        db.SaveChanges();
        
        // commit
        ts.Complete();
    }
}

If an UPDATE or INSERT INTO statement occurs in SQL Server, the trigger will fire.

Your code, as written, does not directly perform an update unless you have actually changed some data before db.SaveChanges();

The only other possibility is that the trigger is being disabled prior to the DML operation, and enabled afterwards. See DISABLE TRIGGER ... in the Docs.

EF uses sp_executesql('query_string') statement for querying. Triggers are not fired in this case.

EDIT: @Gert Arnold - Yes, you are right in your comment. I have pasted wrong link, but caould not find correct anymore. To be fair I have removed link, but my answer is correct. Even in SSMS using sp_executesql('query_string') will not fire triggers on table. Workaround is creating a stored procedure with needed operations and call it from EF like this way:

dbContext.Database.SqlQuery<YourModel>("StoredProcedureName",params);

Triggers will be fired as expected.