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

NuGet packages (8)

Showing the top 5 NuGet packages that depend on FlexLabs.EntityFrameworkCore.Upsert:

Package Downloads
Elsa.Persistence.EntityFrameworkCore
Elsa is a set of workflow libraries and tools that enable super-fast workflowing capabilities in any .NET Core application. This package provides an Entity Framework Core persistence provider.
YYApp
YYApp Core
Ev2.Db.Up
Api micro service
EfConfigurationProvider.Core
Package Description
HwApp.Core
HwApp Core

GitHub repositories (3)

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

Repository Stars
elsa-workflows/elsa-core
A .NET Standard 2.0 Workflows Library
enkodellc/blazorboilerplate
Blazor Boilerplate / Starter Template with MatBlazor
Texnomic/SecureDNS
Secure, Modern, Fully-Featured, All-In-One Cross-Architecture & Cross-Platform DNS Server Using C# 8.0 & .NET Core 3.1

Version History

Version Downloads Last updated
3.1.0 389,114 1/26/2020
3.0.0 64,957 9/29/2019
3.0.0-netcore3-00140 3,406 8/11/2019
2.2.1 43,801 9/17/2019
2.2.0 33,662 8/11/2019
2.1.2 46,274 5/22/2019
2.1.1 512 5/21/2019
2.1.0 975 5/19/2019
2.0.7 49,088 3/18/2019
2.0.6 9,222 2/6/2019
2.0.5 14,414 1/25/2019
2.0.4 5,921 1/3/2019
2.0.3 4,255 12/18/2018
2.0.2 8,568 11/3/2018
2.0.1 736 10/24/2018
2.0.0 7,202 9/19/2018
1.1.0 295 9/19/2018
1.0.4 9,309 3/10/2018
1.0.3 463 2/23/2018
1.0.2 367 2/20/2018
1.0.1 437 2/19/2018
1.0.0 417 2/18/2018