ConcurrencyException when db Trigger

We have a database that sums related datasets to another table. As Ef tries to insert datasets there was a Exception that there was change in 1 row expected but was 0.

In the trigger there was SET NOCOUNT ON and because of that the error occured

Written on September 24, 2020