FlexLabs.EntityFrameworkCore.Upsert 5.1.0

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 5.1.0                

                    
                

            
NuGet\Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 5.1.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="FlexLabs.EntityFrameworkCore.Upsert" Version="5.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 5.1.0                

                    
                

            
#r "nuget: FlexLabs.EntityFrameworkCore.Upsert, 5.1.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. 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.1.0

// Install FlexLabs.EntityFrameworkCore.Upsert as a Cake Tool
#tool nuget:?package=FlexLabs.EntityFrameworkCore.Upsert&version=5.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

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (14)

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

Package Downloads
FenixAlliance.ACL.Dependencies

Application Component for the Alliance Business Suite.
HwApp.Core

HwApp Core
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
QuantFi.Services

Package Description

GitHub repositories (3)

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

Repository Stars
zoriya/Kyoo
A portable and vast media library solution.
Texnomic/SecureDNS
Secure, Modern, Fully-Featured, All-In-One Cross-Architecture & Cross-Platform DNS Server Using .NET 8.0
Kukks/NNostr
A Nostr Relay and Client written in C#
Version Downloads Last updated
8.0.0 613,460 12/3/2023
7.0.0 861,968 12/18/2022
7.0.0-beta.2 6,196 11/22/2022
7.0.0-beta.1 428 11/16/2022
6.0.2 430,149 11/16/2022
6.0.1 3,531,515 1/2/2022
6.0.0-preview5 56,456 7/11/2021
5.1.0 65,932 1/2/2022
5.0.0 359,171 7/11/2021
4.0.1 31,013 7/11/2021
4.0.0 377,357 3/2/2021
3.1.0 2,089,438 1/26/2020
3.0.0 106,547 9/29/2019
3.0.0-netcore3-00140 3,646 8/11/2019
2.2.1 108,371 9/17/2019
2.2.0 43,293 8/11/2019
2.1.2 86,309 5/22/2019
2.1.1 2,352 5/21/2019
2.1.0 2,889 5/19/2019
2.0.7 54,119 3/18/2019
2.0.6 11,326 2/6/2019
2.0.5 17,617 1/25/2019
2.0.4 8,724 1/3/2019
2.0.3 7,175 12/18/2018
2.0.2 12,058 11/3/2018
2.0.1 2,685 10/24/2018
2.0.0 11,164 9/19/2018
1.1.0 2,283 9/19/2018
1.0.4 14,044 3/10/2018
1.0.3 2,454 2/23/2018
1.0.2 2,283 2/20/2018
1.0.1 2,324 2/19/2018
1.0.0 3,420 2/18/2018

v5.1.0
+ Handling UseIdentityAlwaysColumn columns

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