CaeriusNet

Appearance

CaeriusNetSQL Server stored procedure data access for .NET

Build typed, observable, allocation-aware data access around SQL Server stored procedures, DTO mapping, table-valued parameters, caching, and transactions.

Get started
Learn the concepts
View examples
API reference

Stored procedures by design

CaeriusNet targets SQL Server stored procedures. It does not translate LINQ, generate ad hoc SQL, track entities, or abstract multiple database providers.

Typed result mapping

Map result sets to DTOs with the ISpMapper<T> contract. Use [GenerateDto] to remove repetitive mapper code while keeping ordinal mapping explicit.

Table-valued parameters

Send large sets of IDs, GUIDs, and composite rows through SQL Server TVPs. Use [GenerateTvp] for strongly typed TVP rows.

Multiple result sets

Read two to five typed result sets from one stored procedure call. Choose tuple return shapes based on IEnumerable<T>, ReadOnlyCollection<T>, or ImmutableArray<T>.

Per-call caching

Add Frozen, in-memory, or Redis caching to individual read calls from the same parameters builder you use for stored procedure inputs.

Transactions

Use explicit async transaction scopes with commit, rollback, automatic rollback on dispose, poisoned-state handling, and transaction-level tracing.

Observability

Built-in tracing, metrics, and structured logging expose stored procedure names, durations, row counts, failures, cache hits, and transaction context.

Aspire-ready setup

Register SQL Server, Redis, tracing, and metrics with .NET Aspire-friendly builder methods while keeping the same runtime API.

Supported data-access model

CaeriusNet is for SQL Server stored procedures. It is not a LINQ provider, entity tracker, migration tool, or multi-provider ORM.

Start here ​

Use this documentation to learn and apply the NuGet package in production applications.

GoalArticle
Understand the package and decide whether it fits your architectureWhat is CaeriusNet?
Install the package and run the first stored procedureInstall and configure
Find the right guide for a taskUsage overview
Read rows from stored proceduresReading data
Execute writes and scalar commandsWriting data
Send TVPs to SQL ServerTable-valued parameters
Read multiple result sets from one callMultiple result sets
Look up the public APIAPI reference

Documentation structure ​

The documentation is organized by how you use the package:

  1. Get started: Learn what CaeriusNet is, install the package, configure dependency injection, and run a query.
  2. Use CaeriusNet: Read data, write data, map DTOs, pass TVPs, use multiple result sets, cache reads, and run transactions.
  3. Advanced scenarios: Use source generators, AutoContracts, logging, OpenTelemetry, Aspire integration, and combined patterns.
  4. Reference: Look up public APIs, diagnostics, best practices, and benchmark methodology.
  1. Read What is CaeriusNet? to understand the data-access model.
  2. Complete Install and configure to register the package and execute your first stored procedure.
  3. Choose a read shape in Reading data.
  4. Add DTO or TVP generation with Source generators.
  5. Review Best practices before you design production stored procedures.
  6. Use Examples for end-to-end scenarios.

Released under the MIT License.

Copyright © 2024-2026 Johan (AriusII) Coureuil