Friday, January 18, 2019

Trigger related

Does a trigger in a transaction only fire when the transaction is committed?
I don't know anything about Entity Framework, but in the following basic test using Sql Server Management Studio against a local instance, it appears that the trigger fires upon the completion of the insert to table dbo.Test1 and I can immediately see rows in dbo.Test2 BEFORE issuing the COMMIT

No comments:

Post a Comment