FlexLabs.Upsert
FlexLabs.Upsert copied to clipboard
FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax
Any thoughts here. Shouldn't we allow upsert to views? https://github.com/artiomchi/FlexLabs.Upsert/pull/135 It can also be used to "manipulate" with EF Cores many to many i.e. letting ef core to control the...
SQL can upsert data into views also, why not allow this with Flex
How can I retrieve the Id of the upserted row? Something like this: https://stackoverflow.com/a/31578591/5683904
Is there a way to update all properties when matched? Basically I want to provide constant with all new values and generate update which will update everything. The goal is...
**Version** 6.0.1 **Exception message:** `The parameterized query '(@p0 bigint,@p1 datetime2(7),@p2 int,@p3 int,@p4 varchar(100),@p' expects the parameter '@p5', which was not supplied.` **How to reproduce:** ```cs .WhenMatched((dbTx, upTx) => new TransactionInfo()...
May be an alternative to https://github.com/artiomchi/FlexLabs.Upsert/issues/29 but could not find an way to make it work on MySQL.
Thanks for the extension! Saved me heaps! If I have a class consuming this extension, what is the recommended method to unit test the On method, and the WhenMatched? For...
Here is my entity class: public class UserProgramRoleEntity { public Guid Id { get; set; } public Guid UserId { get; set; } public Guid ProgramId { get; set; }...
Is it possible to have similar behaviour to OnMatched but instead execute code if there wasn't a match but an insert instead. e.g. If it's inserted I want to update...
While the change in this PR is working great for my use case, am definitely open to other suggestions to accomplish something similar. In general what I am trying to...