FlexLabs.EntityFrameworkCore.Upsert 2.2.0

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

There is a newer prerelease version of this package available.
See the version list below for details.
Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 2.2.0
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 2.2.0
<PackageReference Include="FlexLabs.EntityFrameworkCore.Upsert" Version="2.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FlexLabs.EntityFrameworkCore.Upsert --version 2.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v2.2.0:      
+ Support for more expressions (AND and OR)
+ Support for default column values and expressions
+ Null value handling in generated SQL
! Patched MySQL syntax for columns that haven't been updated but may be present in expressions
     
v2.1.2:
+ Add filter condition for updates on upsert
! Updating properties with default values

v2.1.0:
* Improved expression parser should support more expressions
+ Support for more complex multi-operation combined expressions
+ Support for conditional expressions
+ Support for comparison expressions

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
3.0.0-netcore3-00140 91 8/11/2019
2.2.0 675 8/11/2019
2.1.2 11,215 5/22/2019
2.1.1 137 5/21/2019
2.1.0 517 5/19/2019
2.0.7 16,629 3/18/2019
2.0.6 6,802 2/6/2019
2.0.5 5,672 1/25/2019
2.0.4 4,770 1/3/2019
2.0.3 2,002 12/18/2018
2.0.2 7,378 11/3/2018
2.0.1 507 10/24/2018
2.0.0 6,191 9/19/2018
1.1.0 150 9/19/2018
1.0.4 5,574 3/10/2018
1.0.3 285 2/23/2018
1.0.2 206 2/20/2018
1.0.1 271 2/19/2018
1.0.0 216 2/18/2018