FlexLabs.Upsert
FlexLabs.Upsert copied to clipboard
artiomchi
FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax
Thanks for such a great library. I came across this recently and it satisfies all my needs except this issue. Looks like Upsert/UpsertRange does not support owned entities (https://docs.microsoft.com/en-us/ef/core/modeling/owned-entities) ?...
Support basic OwnedEntities, limitations: * Only works for relational systems - not InMemory. * WhenMatched only works with values and not expressions. My use-case required this because we mostly use...
I am still diagnosing this and reading through your code to make sure I have this right, but it appears from the outside that it is only paying attention to...
Seeing this in my logs, looks like something broke with the .NET 6 or entity framework core 6 upgrade... I'm using nuget 6.0.1. No compile errors. Perhaps `IModel` FindEntityType was...
Why there is a problem with datetime in UpdateIf? ```csharp .UpdateIf((dcInDb, dcNew) => dcInDb.IsConnected != dcNew.IsConnected || (dcInDb.IsConnected == true && dcInDb.LastSeen = TimeSpan.FromSeconds(5))) ``` The second expression does not...
Hi, Awesome library, thank you for your work! Fields marked with [DatabaseGenerated(DatabaseGeneratedOption.Computed)] are not ignored on insert and update. Postgre SQL Exception data: Severity: ERROR SqlState: 42601 MessageText: cannot insert...
Hi artiomchi, Thanks for your amazing job with this tool. Have you any plan to add the handling of TPH (Table Per Hierarchy), supported by EF Core, in your library?...
.UpdateIf((dcInDb, dcNew) => dcInDb.IsConnected) - In Sqlite it works - In Sql Server it does not work: SqlException: An expression of non-boolean type specified in a context where a condition...
## Problem While working around issue #109 (see PR #112) I ran into another problem related to partial indexes. I found a hacky workaround by creating a custom `IUpsertCommandRunner` but...
Regarding issue mentioned in : https://github.com/artiomchi/FlexLabs.Upsert/issues/24 Hi @artiomchi, @jmosbech, I was looking for same use case (Constructor expressions) support. Not sure if either of you got a chance to fix...