/DB

Changelog

What changed in Socigy.OpenSource.DB — the database-context bulk insert + projecting ForEachAsync (0.3.1) on top of 0.3.0's field encryption, rotating credentials, and HashiCorp Vault package.

updated 5 Jun 20261 min readv0.3.1View as Markdown
5 June 2026
Socigy.OpenSource.DBv0.3.1stable
Added
  • InsertMultipleAsync on the database context. I{Table}Set now exposes InsertMultipleAsync(entities, includeAutoFields, ct), batching a whole collection into multi-row INSERTs within the unit-of-work scope.
  • Auto-field control on context inserts. InsertAsync and InsertMultipleAsync take includeAutoFields (default false); pass true to also write auto-increment columns (supply your own values) — the context equivalent of WithAllFields(). Backed by a new GetInsertPlan(bool includeAutoIncrement).
  • ForEachAsync<TResult> projection. Streams matching rows, projects each through the callback, and returns the results (materialized inside the scope), so you can transform rows without a lazy enumerable escaping the connection.
Fixed
  • CI now builds, packs, and publishes the optional Socigy.OpenSource.DB.HashiCorp package independently of the main package (each is version-checked separately, so a re-run still ships one when the other is already published).