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" />
paket add FlexLabs.EntityFrameworkCore.Upsert --version 3.1.0
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
Dependencies
-
.NETStandard 2.0
- Microsoft.EntityFrameworkCore.Relational (>= 3.1.0)
-
.NETStandard 2.1
- Microsoft.EntityFrameworkCore.Relational (>= 3.1.0)
Used By
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 |