CaeriusNet

🛠️

SQL Server stored procedures only

CaeriusNet intentionally targets Microsoft SQL Server and stored procedures. It does not translate LINQ, generate SQL text, track entities, or abstract multiple database providers.

⚙️

Compile-time mapper generation

[GenerateDto] and [GenerateTvp] emit ISpMapper<T> and ITvpMapper<T> implementations at build time. Analyzer rules validate the sealed partial primary-constructor contract.

📖

Ordinal data-reader mapping

Result columns are read by index through SqlDataReader with SequentialAccess. Declared result-set capacity lets CaeriusNet pre-size collections for predictable materialization.

📦

Table-valued parameters

Pass large identifier or composite-key sets with SQL Server TVPs. Generated TVP mappers stream SqlDataRecord values without requiring callers to build DataTable instances.

🔀

Multiple result sets

Read up to five typed result sets from one stored-procedure execution. Return shapes are available for IEnumerable, ReadOnlyCollection, and ImmutableArray.

🧊

Per-call caching

Choose a cache tier on the parameters builder when a call is safe to cache Frozen for process-lifetime reference data, InMemory for expiring local entries, or Redis for shared distributed cache.

🔐

Transaction scopes

BeginTransactionAsync returns an explicit async scope with commit, rollback, poisoned-state handling, and tracing that groups child stored-procedure calls under a transaction activity.

📡

Diagnostics and telemetry

Built-in ActivitySource, Meter, and source-generated logging expose stored-procedure metadata, durations, failures, cache events, and optional parameter-value capture.

Documentation map

Area	Start here	Use it for
Quickstart	Installation & Setup	Install the package, register DI, and run the first stored-procedure query.
Guides	Reading Data	Learn DTO mapping, TVPs, result-set shapes, caching, transactions, logging, and Aspire integration.
Reference	API Reference	Look up public builders, abstractions, commands, mapper contracts, and exception behavior.
Diagnostics	Diagnostic rules	Resolve analyzer errors and warnings emitted by the source generators.
Examples	Examples overview	Follow end-to-end stored procedure, TVP, multi-result, and transaction scenarios.
Benchmarks	Performance & Benchmarks	Understand the benchmark suites, configuration, limitations, and local run commands.

Area

Start here

Use it for

Quickstart

Installation & Setup

Install the package, register DI, and run the first stored-procedure query.

Guides

Reading Data

Learn DTO mapping, TVPs, result-set shapes, caching, transactions, logging, and Aspire integration.

Reference

API Reference

Look up public builders, abstractions, commands, mapper contracts, and exception behavior.

Diagnostics

Diagnostic rules

Resolve analyzer errors and warnings emitted by the source generators.

Examples

Examples overview

Follow end-to-end stored procedure, TVP, multi-result, and transaction scenarios.

Benchmarks

Performance & Benchmarks

Understand the benchmark suites, configuration, limitations, and local run commands.