FlexLabs.EntityFrameworkCore.Upsert 6.0.1

.NET 6.0
NuGet\Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 6.0.1
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.
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 6.0.1
<PackageReference Include="FlexLabs.EntityFrameworkCore.Upsert" Version="6.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add FlexLabs.EntityFrameworkCore.Upsert --version 6.0.1
#r "nuget: FlexLabs.EntityFrameworkCore.Upsert, 6.0.1"
#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=6.0.1

// Install FlexLabs.EntityFrameworkCore.Upsert as a Cake Tool
#tool nuget:?package=FlexLabs.EntityFrameworkCore.Upsert&version=6.0.1

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 Versions
.NET net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (13)

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

Package Downloads
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.

FenixAlliance.ACL.Dependencies

Application Component for the Alliance Business Suite.

MyJetWallet.Sdk.Postgres

Package Description

YYApp

YYApp Core

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 MudBlazor
Texnomic/SecureDNS
Secure, Modern, Fully-Featured, All-In-One Cross-Architecture & Cross-Platform DNS Server Using .NET 6.0
Version Downloads Last updated
6.0.1 490,560 1/2/2022
6.0.0-preview5 38,264 7/11/2021
5.1.0 35,007 1/2/2022
5.0.0 244,689 7/11/2021
4.0.1 14,625 7/11/2021
4.0.0 241,739 3/2/2021
3.1.0 1,306,220 1/26/2020
3.0.0 95,840 9/29/2019
3.0.0-netcore3-00140 3,549 8/11/2019
2.2.1 88,215 9/17/2019
2.2.0 38,794 8/11/2019
2.1.2 66,018 5/22/2019
2.1.1 892 5/21/2019
2.1.0 1,288 5/19/2019
2.0.7 51,168 3/18/2019
2.0.6 9,683 2/6/2019
2.0.5 15,556 1/25/2019
2.0.4 7,076 1/3/2019
2.0.3 5,559 12/18/2018
2.0.2 9,923 11/3/2018
2.0.1 1,073 10/24/2018
2.0.0 8,980 9/19/2018
1.1.0 619 9/19/2018
1.0.4 11,924 3/10/2018
1.0.3 811 2/23/2018
1.0.2 694 2/20/2018
1.0.1 793 2/19/2018
1.0.0 809 2/18/2018

v6.0.0
+ Adding support for EF Core 6
+ 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