Laraue.EfCoreTriggers
Laraue.EfCoreTriggers copied to clipboard
win7user10
Library to write triggers in C# with EF.Core
Hi, we are using parallelized the test execution to run our integration tests and therefore use multiple DB Contexts in different threads. I noticed that the build sometimes fails with...
SQLite has [limited support for schema changes](https://www.sqlite.org/lang_altertable.html) and in many cases a table rebuild is required. EF Core does the table rebuilds automatically behind the scenes and it's not obvious...
When writing a boolean constant to a nullable boolean field, the SQL generated is ```CASE WHEN 0 THEN 1 ELSE 0 END``` which is invalid and cause an exception ```An...
Here is my configuration for my entity: ``` public void Configure(EntityTypeBuilder builder) { string sql = @"IF EXISTS ( SELECT 1 FROM inserted i JOIN dbo.categories p ON i.parentid =...
Is there any way, or can a way be added, to abort the update if a condition is not met, or to alter the incoming value before the update happens?...
Hi I am a newer to this. I am using another EF Core trigger extension and I was attracted to this extension. When I want to migrate to this, a...
Hello, everyone. We're using EfCoreTriggers together with our own modified MigrationsModelDiffer. Right now we have to subclass EfCoreTriggers MigrationsModelDiffer since migration code is fully inside GetDifferences. If migrations were implemented...
I tried to create [idempotent scripts](https://learn.microsoft.com/en-us/ef/core/managing-schemas/migrations/applying?tabs=dotnet-core-cli#idempotent-sql-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...
At the moment [EF.Property](https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.ef.property?view=efcore-6.0) is not supported. I tried adding it as an `IMethodCallVisitor` but it gives me an error: ``` Expression of type System.Linq.Expressions.TypedParameterExpression is not supported ``` I...
In C# signature, `new DateTimeOffset()` returns `0001/01/01 0:00:00 +00:00`. So, it is not suitable for `current_timestamp` representation in C#. It should be `DateTimeOffset.Now`!
