FlexLabs.EntityFrameworkCore.Upsert 7.0.0

.NET 6.0
dotnet add package FlexLabs.EntityFrameworkCore.Upsert --version 7.0.0
NuGet\Install-Package FlexLabs.EntityFrameworkCore.Upsert -Version 7.0.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="7.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 7.0.0
#r "nuget: FlexLabs.EntityFrameworkCore.Upsert, 7.0.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=7.0.0

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

Product Versions
.NET net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
Compatible target framework(s)
Additional computed target framework(s)
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

Telluria.Utils.Crud

Generic library for easy creation of CRUD rest APIs with dotnet and EntityFrameworkCore.

GitHub repositories (1)

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

Repository Stars
Texnomic/SecureDNS
Secure, Modern, Fully-Featured, All-In-One Cross-Architecture & Cross-Platform DNS Server Using .NET 7.0
Version Downloads Last updated
7.0.0 52,202 12/18/2022
7.0.0-beta.2 4,217 11/22/2022
7.0.0-beta.1 350 11/16/2022
6.0.2 65,739 11/16/2022
6.0.1 1,453,115 1/2/2022
6.0.0-preview5 47,043 7/11/2021
5.1.0 51,974 1/2/2022
5.0.0 288,462 7/11/2021
4.0.1 17,977 7/11/2021
4.0.0 284,001 3/2/2021
3.1.0 1,575,128 1/26/2020
3.0.0 99,205 9/29/2019
3.0.0-netcore3-00140 3,576 8/11/2019
2.2.1 97,626 9/17/2019
2.2.0 40,196 8/11/2019
2.1.2 72,104 5/22/2019
2.1.1 975 5/21/2019
2.1.0 1,369 5/19/2019
2.0.7 51,934 3/18/2019
2.0.6 9,789 2/6/2019
2.0.5 15,911 1/25/2019
2.0.4 7,234 1/3/2019
2.0.3 5,654 12/18/2018
2.0.2 10,316 11/3/2018
2.0.1 1,162 10/24/2018
2.0.0 9,232 9/19/2018
1.1.0 712 9/19/2018
1.0.4 12,238 3/10/2018
1.0.3 911 2/23/2018
1.0.2 786 2/20/2018
1.0.1 890 2/19/2018
1.0.0 1,041 2/18/2018

v7.0.0
+ Adding support for EF Core 7

v6.0.2
* Improving entity type detection when using DbSet<>
! Patching MySQL handling of null columns

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