{"repo":"win7user10/Laraue.EfCoreTriggers","free":true,"listed":false,"github":"https://github.com/win7user10/Laraue.EfCoreTriggers","clone":"git clone https://github.com/win7user10/Laraue.EfCoreTriggers.git","description":"Library to write triggers in C# with EFCore","language":"C#","stars":138,"topics":["triggers","efcore","writing-triggers","csharp","orm","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"Entity Framework Core Triggers EfCoreTriggers is the library to write native SQL triggers using EFCore model builder. Triggers are automatically translating into SQL and adding to migrations. Versions compatability Package major version matches an EF Core major version it uses. Package version Minimal required .NET version ----------------- ------------------------------- 10.x.x NET 10.0 9.x.x NET 8.0 8.x.x NET 8.0 7.x.x NET 6.0 6.x.x NET 6.0 5.x.x NET standard 2.1 Install the provider package corresponding to your target database. Basic usage The library has extensions for EntityBuilder to configure DbContext. After update Transaction entity, update records in the table with UserBalance entities. After insert Transaction entity, upsert record in the table with UserBalance entities. After delete Transaction entity, execute raw SQL. Pass deleted entity fields as arguments. Also, different trigger functions can be used to generate the SQL. All available triggers Trigger PostgreSql SQL Server SQLite MySQL Oracle ------------------- ------------ ------------ -------- ------- -------- Before Insert + - + + + After Insert + + + + + Instead Of Insert + + + - + Before Update + - + + + After Update + + + + + Instead Of Update + + + - + Before Delete + - + + + After Delete + + + + + Instead Of Delete + + + - + Available actions after trigger has worked - Insert - InsertIfNotExists - Update - Upsert - Delete - ExecuteRawSql Laraue.EfCoreTriggers.PostgreSql Basic usage Laraue.EfCoreTrigg","default_branch":null,"files":null,"tree":[],"storefront":"/r/win7user10","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/win7user10/Laraue.EfCoreTriggers/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}