Creating an insert/update/delete trigger for Code First

Question

I have a question that I've yet to find an answer to after some research. Is there a way in Code First for Entity to create an Insert/Update/Delete Trigger? Currently I cannot find anything and the only thing eluding to it was suggestions of using code to do whatever work (insert/update/delete) after a method fires.

You can probably do this in a customer database initializer. — CodingGorilla
– CodingGorilla, Commented Feb 27, 2013 at 18:00

Corey Adler · Accepted Answer · 2013-02-27 18:05:51Z

2

Entity Framework currently does not support creating triggers on the database itself, nor does there appear to be any in the near future (see what's being implemented for EF 6 here).

The only solution that you have is to do whatever it is you wanted to do after the Insert/Update/Delete finishes, preferably in your business logic (or, even better, in your repositories if you want to set it up like in this blog post).

answered Feb 27, 2013 at 18:05

Corey Adler

16.2k18 gold badges70 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

IyaTaisho Over a year ago

That's what I feared. Seems like something they would want to invest in. I have a way around it though since I have a start up script when my project is first deployed. I could add the trigger then. Thanks.

Ibrahim Najjar Over a year ago

+1 on the answer, "preferably in your business logic" is the right way of doing things.

Collectives™ on Stack Overflow

Creating an insert/update/delete trigger for Code First

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related