search

win7user10 / Laraue.EfCoreTriggers

Library to write triggers in C# with EF.Core
MIT License
112 stars 20 forks source link

Create idempotent scripts #66

Open Scantraxx123 opened 1 year ago

Scantraxx123 commented 1 year ago

I tried to create idempotent scripts with this library and I'm running into the problem that the script will be created properly, but when I want to execute the script this error message comes up:

Can't create a TRIGGER from within another stored routine

Is there a possiblity to enable this feature? I can imagine it could be tricky because it would be necessary to manipulate the generation of SQL there.

Scantraxx123 commented 1 year ago

Also creating a non idempotent script results into the problem:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 7

This can be fixed if I add a the delimiter keyword properly inside the sql file. But it doesn't get generated automatically.