FlexLabs.EntityFrameworkCore.Upsert 5.0.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 5.0.0
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 5.0.0
<PackageReference Include="FlexLabs.EntityFrameworkCore.Upsert" Version="5.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FlexLabs.EntityFrameworkCore.Upsert --version 5.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: FlexLabs.EntityFrameworkCore.Upsert, 5.0.0"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install FlexLabs.EntityFrameworkCore.Upsert as a Cake Addin
#addin nuget:?package=FlexLabs.EntityFrameworkCore.Upsert&version=5.0.0

// Install FlexLabs.EntityFrameworkCore.Upsert as a Cake Tool
#tool nuget:?package=FlexLabs.EntityFrameworkCore.Upsert&version=5.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

v5.0.0
! Fixing the library versioning. From now one, one version of the library depends on one version of EF Core, for all supported target frameworks

v4.0.1
! Patching some MySql conditional update queries

v4.0.0
+ Adding support for .NET 5 and EF Core 5
! Patched support for constants in the update condition
! Run and RunAsync will not return all rows affected when command was split into multiple batches, not just the last batch's row count
! Patching the extension method to replace/inject custom command runner
! Removed old extension method on IServiceCollection, since it wasn't working anyway

NuGet packages (9)

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.
HwApp.Core
HwApp Core
YYApp
YYApp Core
Ev2.Db.Up
Api micro service
OnXap.Core
Ядро приложения OnXap.

GitHub repositories (2)

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

Repository Stars
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 5.0

Version History

Version Downloads Last updated
6.0.0-preview5 99 7/11/2021
5.0.0 6,364 7/11/2021
4.0.1 156 7/11/2021
4.0.0 81,737 3/2/2021
3.1.0 700,274 1/26/2020
3.0.0 77,549 9/29/2019
3.0.0-netcore3-00140 3,472 8/11/2019
2.2.1 59,273 9/17/2019
2.2.0 35,296 8/11/2019
2.1.2 53,503 5/22/2019
2.1.1 627 5/21/2019
2.1.0 1,097 5/19/2019
2.0.7 49,612 3/18/2019
2.0.6 9,403 2/6/2019
2.0.5 14,888 1/25/2019
2.0.4 6,444 1/3/2019
2.0.3 4,778 12/18/2018
2.0.2 9,213 11/3/2018
2.0.1 902 10/24/2018
2.0.0 7,634 9/19/2018
1.1.0 443 9/19/2018
1.0.4 10,948 3/10/2018
1.0.3 612 2/23/2018
1.0.2 514 2/20/2018
1.0.1 583 2/19/2018
1.0.0 596 2/18/2018