FlexLabs.EntityFrameworkCore.Upsert 2.0.7

Adds basic support for "Upsert" operations to EF Core.

Uses `INSERT … ON CONFLICT DO UPDATE` in PostgreSQL/Sqlite, `MERGE` in SqlServer and `INSERT INTO … ON DUPLICATE KEY UPDATE` in MySQL.

Also supports injecting sql command generators to add support for other providers

Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 2.0.7
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 2.0.7
paket add FlexLabs.EntityFrameworkCore.Upsert --version 2.0.7
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v2.0.6:
+ Adding support for null value upsert matches

v2.0.5:
! The dbcommand would sometimes be disposed of before finishing the execution of the query!
+ Adding the number of rows affected as the return of the Run/RunAsync calls

v2.0.4:
! Checking arguments for validity and null references before processing

v2.0.3:
! Patching incorrectly constructed SQL statement in case no columns need updating

v2.0.0:
+ Adding support for EF 2.1 Type Conversions
+ Adding support for static property/field accessors (e.g. DateTime.Now)
* Explicitly throwing an exception when using identity keys as upsert match columns (since it wouldn't have worked correctly anyway)
+ Added help links to exceptions linking to more details
+ Added support for basic type conversions and modulo operator in expressions

Version History

Version Downloads Last updated
2.0.7 2,279 3/18/2019
2.0.6 4,728 2/6/2019
2.0.5 2,890 1/25/2019
2.0.4 2,750 1/3/2019
2.0.3 1,293 12/18/2018
2.0.2 6,416 11/3/2018
2.0.1 443 10/24/2018
2.0.0 5,653 9/19/2018
1.1.0 111 9/19/2018
1.0.4 4,839 3/10/2018
1.0.3 217 2/23/2018
1.0.2 164 2/20/2018
1.0.1 195 2/19/2018
1.0.0 169 2/18/2018