GitHub

EF Core 6 Insert using the Add method failing when table is linked with a trigger

I have a postgresql table to which I have linked a before insert trigger and trigger function. In the trigger function based on the insert values, I create child tables using inheritance and insert ...
GitHub

Invalid last inserted id when the table has a trigger with insert statements in ...

I discovered a problem when the table in MSSQL has a trigger with insert statements. Id returned by method lastInsertId is invalid. It isn't id from the table in where we were inserting data, but from ...