CaeriusNet

Appearance

CaeriusNetStored-procedure data access for .NET 10

Typed, observable SQL Server 2022/2025 calls for C# 14—without inline SQL or runtime mapper reflection.

Get started
Migrate from v11
Package guide

  • Stored procedures only

    Every runtime call is CommandType.StoredProcedure. CaeriusNet has no inline SQL, LINQ provider, query builder or alternative database driver.

  • Explicit result contracts

    First, single, scalar, materialized and streamed APIs distinguish empty results, SQL NULL, multiple rows, mapping errors and conversion errors.

  • Generated mapping and TVPs

    DTO and TVP generators produce static mapper contracts. TVP enumeration reuses one SqlDataRecord and supports empty input.

  • Multiple result sets, 2–10

    Generated tuple APIs materialize each announced set as IEnumerable, ReadOnlyCollection or ImmutableArray and validate its count by default.

  • Typed cache architecture

    Memory cache provides TTL, sliding expiration and single-flight; Frozen cache swaps snapshots atomically; Redis adds versioned typed binary payloads.

  • DI and Aspire ready

    Register default or keyed databases through DI, then compose Aspire SQL Server, Redis, health checks and OpenTelemetry listeners separately.

Version 12

CaeriusNet v12 is a major release for .NET 10, C# 14 and SQL Server 2022/2025 only. Its DI-first API replaces all v11 builder and global-state APIs. See the migration guide.

Start here ​

GoalArticle
Install the runtime and make the first stored-procedure callInstall and configure
Decide which packages are neededUsage overview
Choose a row cardinality or collection shapeReading data
Execute writes, scalars and outputsWriting data
Pass table-valued parametersTable-valued parameters
Read 2–10 result setsMultiple result sets
Cache safelyCaching
Use .NET AspireAspire integration
Discover AutoContractsAutoContracts

CaeriusNet operates at the stored-procedure boundary. It is not an entity tracker, migration tool, SQL generator or multi-provider ORM.

Released under the MIT License.

Copyright © 2024-2026 Johan (AriusII) Coureuil