/SQL/Generate sql trigger through ef migration

Generate sql trigger through ef migration

migrationBuilder.Sql( "DROP TRIGGER SetUserTimestamp" );

Source: stackoverflow.com

Generate sql trigger through ef migration

migrationBuilder.Sql( "CREATE TRIGGER SetUserTimestamp AFTER UPDATE ON Users BEGIN UPDATE Users SET Timestamp = randomblob( 8 ) WHERE Id = NEW.Id; END" );

Source: stackoverflow.com

Similar codes

1 vote113 views1 answer
Temp table vs variable table in sql server
SQL
0 vote113 views1 answer
Empty table sqlite
SQL
0 vote123 views1 answer
Linux upload database to mysql
SQL
1 vote114 views1 answer
What is a Database?
SQL
1 vote129 views1 answer
Oracle plan hash value
SQL
0 vote121 views1 answer
How to change mysql root password in windows 10
SQL
-1 vote112 views1 answer
How to create foreign key in sql server management studio
SQL
5 votes137 views1 answer
Migrate sql table another database
SQL
6 votes124 views2 answers
Sql sequence
SQL
0 vote142 views1 answer
How to get table id sequence postgres
SQL