FlexLabs.EntityFrameworkCore.Upsert 3.1.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

Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 3.1.0
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 3.1.0
<PackageReference Include="FlexLabs.EntityFrameworkCore.Upsert" Version="3.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FlexLabs.EntityFrameworkCore.Upsert --version 3.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v3.1.0
- Referencing EF Core 3.1 only, due to internal namespace changes and compatibility issues with .NET Full Framework
+ Nulable type metadata
+ Adding support for upserting by identity column
+ Splitting the request into multiple queries if the query parameter limit is reached

v3.0.0
* EF Core 3 support

v2.2.1:      
+ Support for more expressions (Bitwise AND and bitwise OR)

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

Showing the top 1 GitHub repositories that depend on FlexLabs.EntityFrameworkCore.Upsert:

Repository Stars
elsa-workflows/elsa-core
A .NET Standard 2.0 Workflows Library

Read more about the GitHub Usage information on our documentation.

Version History

Version Downloads Last updated
3.1.0 65,722 1/26/2020
3.0.0 40,613 9/29/2019
3.0.0-netcore3-00140 3,351 8/11/2019
2.2.1 23,182 9/17/2019
2.2.0 24,634 8/11/2019
2.1.2 32,407 5/22/2019
2.1.1 259 5/21/2019
2.1.0 810 5/19/2019
2.0.7 43,702 3/18/2019
2.0.6 8,302 2/6/2019
2.0.5 11,407 1/25/2019
2.0.4 5,294 1/3/2019
2.0.3 3,735 12/18/2018
2.0.2 7,881 11/3/2018
2.0.1 620 10/24/2018
2.0.0 6,612 9/19/2018
1.1.0 207 9/19/2018
1.0.4 6,845 3/10/2018
1.0.3 363 2/23/2018
1.0.2 273 2/20/2018
1.0.1 346 2/19/2018
1.0.0 288 2/18/2018