Flowthru.Extensions.EFCore.Bulk 0.27.0

There is a newer version of this package available.
See the version list below for details.

dotnet add package Flowthru.Extensions.EFCore.Bulk --version 0.27.0

NuGet\Install-Package Flowthru.Extensions.EFCore.Bulk -Version 0.27.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="Flowthru.Extensions.EFCore.Bulk" Version="0.27.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Flowthru.Extensions.EFCore.Bulk" Version="0.27.0" />
                    

                            Directory.Packages.props

<PackageReference Include="Flowthru.Extensions.EFCore.Bulk" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Flowthru.Extensions.EFCore.Bulk --version 0.27.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Flowthru.Extensions.EFCore.Bulk, 0.27.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.

#:package Flowthru.Extensions.EFCore.Bulk@0.27.0

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=Flowthru.Extensions.EFCore.Bulk&version=0.27.0
                    

                            Install as a Cake Addin

#tool nuget:?package=Flowthru.Extensions.EFCore.Bulk&version=0.27.0
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Flowthru.Extensions.EFCore.Bulk

Swap the default per-row save on an EF Core Catalog Item for a provider-native bulk path. This complements Flowthru.Extensions.EFCore: base EFCore saves via SaveChanges (change tracking, one round-trip per batch of tracked entities), which is fine for the modest writes most flows produce. Reach for this package when a step writes high volume — tens of thousands of rows or more — where the per-row tracking overhead dominates. BulkSave.Insert, TruncateAndInsert, InsertOrUpdate, and InsertOrUpdateOrDelete each return a saveFunc you hand to .WithSave(...), and the write becomes a single bulk-copy (e.g. Npgsql binary COPY).

Mental model

Same EF Core mental model as the base extension — your DbContext, your entity types, your keys — but the save no longer goes through change tracking. It maps to the bulk-load command your database provider exposes. Pick the strategy by the SQL semantics you want: Insert (append), TruncateAndInsert (full replace), InsertOrUpdate (upsert by primary key), InsertOrUpdateOrDelete (full sync — also deletes rows absent from the input). It is built on EFCore.BulkExtensions, so its provider support and caveats apply.

Install

dotnet add package Flowthru.Extensions.EFCore.Bulk

Hand a BulkSave strategy to the EF Core Item's .WithSave(...):

public IItem<IEnumerable<PreprocessedCompanySchema>> Companies =>
    CreateItem(() => Item.Of<IEnumerable<PreprocessedCompanySchema>>("StagingCompanies")
        .EFCoreQuery<PreprocessedCompanySchema, StagingDbContext>()
        .WithContextFactory(_contextFactory)
        .WithSave(BulkSave.Insert<PreprocessedCompanySchema, StagingDbContext>())
        .Build());

Tune batch size, timeout, or identity behaviour with BulkSaveOptions:

.WithSave(BulkSave.TruncateAndInsert<MyEntity, MyDbContext>(
    new BulkSaveOptions { BatchSize = 5000, SetOutputIdentity = true }))

Product	Compatible and additional computed target framework versions.
.NET	net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net10.0
- EFCore.BulkExtensions (>= 10.0.1)
- Flowthru.Extensions.EFCore (>= 0.27.0)
- Microsoft.EntityFrameworkCore (>= 10.0.4)
- Microsoft.EntityFrameworkCore.Relational (>= 10.0.4)
- Microsoft.Extensions.Configuration (>= 10.0.4)
- Microsoft.Extensions.Configuration.Abstractions (>= 10.0.4)
- Microsoft.Extensions.Configuration.Binder (>= 10.0.4)
- Microsoft.Extensions.DependencyInjection (>= 10.0.4)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 10.0.4)
- Microsoft.Extensions.Logging (>= 10.0.4)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.4)
- Microsoft.Extensions.Options (>= 10.0.4)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.1)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.