Disable and enable table triggers in EF core in .NetCore

Question

I would like to delete few rows from a table through EF core. Table has a trigger on it which does not allow deletes but adds a date to a deleted column.

Is there a way in EF core to disable trigger, then call Removeand then enable trigger back again on again after saving changes.

Repository Function

//Disable Trigger on Department Table

context.Department.Remove(dept);
context.SaveChanges();

//Enable Trigger

How do I manipulate triggers in EF core inside the code?

user_440138 · Answer

EF Core does not support triggers. You need to write custom SQL query to achieve this.

Here you can find how to run custom query with EF core.

Take a look at below stackoverflow question to drop and create a trigger.

Creating a Trigger with ExecuteSqlCommand() Throws "Incorrect syntax near the word 'TRIGGER'."

Disable and enable table triggers in EF core in .NetCore

1 Answers