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

Version History