BstBulk

Helpers for opting properties into bulk insert/update operations (works with EFCore.BulkExtensions).

This is the provider-agnostic core package — it does not reference a database provider. To run the actual bulk call, install the provider package for your database instead of (or alongside) this one:

• BstBulk.SqlServer — SQL Server
• BstBulk.PostgreSql — PostgreSQL

Migration note: Up to version 10.0.x, BstBulk transitively pulled in the SQL Server bulk provider, so BulkInsertOrUpdateAsync worked out of the box. From 10.1.0 it no longer does — SQL Server consumers should switch their package reference from BstBulk to BstBulk.SqlServer.

Usage

1. Mark properties with [Bulk(insert, update)]

using BstBulk.DataAnnotations;

public class Product {
    public int Id { get; set; }

    [Bulk(insert: true, update: true)]
    public string Name { get; set; }

    [Bulk(insert: true, update: false)]
    public DateTimeOffset CreatedAt { get; set; }

    // Owned types in the same table also work — annotate the navigation
    [Bulk(insert: true, update: true)]
    public Address ShippingAddress { get; set; }
}

Properties without [Bulk] are ignored.

2. Build the property lists from the DbContext

using BstBulk.Enums;
using BstBulk.Extensions;

var propertiesToInsert = dbContext.GetBulkProperties<Product>(BulkType.Insert);
var propertiesToUpdate = dbContext.GetBulkProperties<Product>(BulkType.Update);

GetBulkProperties walks the EF model, picks scalar properties whose [Bulk] flag for the requested operation is true, and adds owned-entity columns when the navigation is itself flagged. Owned types nested inside a flagged owned navigation are included automatically — the nested navigations do not need their own [Bulk] annotation.

3. Pass them to the bulk call

With a provider package installed (BstBulk.SqlServer / BstBulk.PostgreSql), let the helpers build the BulkConfig and run the operation for you:

using BstBulk.SqlServer.Extensions; // or BstBulk.PostgreSql.Extensions

await dbContext.BstBulkInsertOrUpdate(products);

The core also exposes GetBulkConfig<T>() if you prefer to build the config and call EFCore.BulkExtensions yourself:

using BstBulk.Extensions;

var config = dbContext.GetBulkConfig<Product>();
config.UpdateByProperties = [nameof(Product.Id)];
await dbContext.BulkInsertOrUpdateAsync(products, config);

GetBulkConfig<T> is equivalent to building a BulkConfig with PropertiesToInclude = GetBulkProperties<T>(BulkType.Insert) and PropertiesToIncludeOnUpdate = GetBulkProperties<T>(BulkType.Update).

BulkType values: BulkType.Insert, BulkType.Update.