Skip to content

SqlLinqer v2.2.0-rc.3

Pre-release
Pre-release

Choose a tag to compare

@Nulifyer Nulifyer released this 21 Oct 22:47
· 48 commits to master since this release

SqlLinqer 2.2.0-rc.3 adds result streaming and fixes mapping, generated inserts, precision, and resource ownership issues found during release review.

Added

  • Asynchronous JSON result streaming for typed queries and projections, with cancellation and cleanup after early enumeration exit.
  • Shared native value conversion rules for scalar, tabular, and callable results.

Fixed

  • Immutable and read-only JSON collection loading, including nested SQL-mapped elements.
  • Native row loading with SQL column names or CLR projection aliases, including DateOnly and TimeOnly scalars.
  • Default-only DuckDB inserts into tables with generated columns.
  • Generated SQL Server TVP decimal precision and validation of batches that cannot be represented losslessly.
  • Connector schema isolation and disposable-result cleanup after execution or cleanup failures.

Performance

  • Span-based SQLite hex decoding and UTF-8 JSON member matching reduce intermediate allocations.
  • Native row mappers cache metadata and constructor delegates while keeping scratch storage private to each reader.
  • JSON document fragment buffers are pooled and cleared when returned.
  • Isolated measurements on .NET 10.0.13 reduced three-member model mapping from 232 to 136 bytes per row and 4 KiB hex decoding from 151,600 to 4,120 bytes per operation. These measurements exclude database and network work.

Behavior changes

  • SQL result loading uses SQL mappings and ignores application JSON serialization attributes and converters. Use SqlIgnore to exclude SQL members.
  • Numeric conversions reject fractional-to-integer values and overflow. Offset-bearing text loads as UTC DateTime, and DateTimeOffset requires an explicit offset.
  • Callers retain ownership of supplied transactions and connections after errors and cancellation, including responsibility for rollback.
  • Newtonsoft.Json is no longer a transitive dependency. Add a direct reference if your application uses it.

The library continues to target .NET Standard 2.0. This is a prerelease intended for application integration testing.

Validation

The release candidate passed local regression suites, minimum SQLite 3.38, formatting, compatibility builds, and the full disposable-database suite for PostgreSQL, MySQL, and SQL Server. SQL Server checks include synchronous and asynchronous high-precision decimal TVP round trips. .NET Framework 4.8 was build-checked; its runtime and an actual Azure SQL service endpoint were not exercised.