A focused, high-performance micro-ORM for C# 14 / .NET 10. Compile-time safe mapping, zero reflection, first-class observability.
Data access lives in T-SQL where it belongs. CaeriusNet binds Stored Procedure result sets to typed C# DTOs with a fluent builder, DI-first design, and a deliberately small API surface — no LINQ translation, no change tracking, no surprises.
[GenerateDto] and [GenerateTvp] emit ISpMapper<T> / ITvpMapper<T> at build time. A dedicated analyzer enforces the sealed partial + primary-constructor shape, so contract drift surfaces in your IDE — never at runtime.
Columns are read by index — never by name — through SqlDataReader with SequentialAccess. Result lists are pre-sized via your declared capacity, populated through CollectionsMarshal, and pooled with ArrayPool<T> for ImmutableArray outputs.
Pass thousands of IDs, GUIDs, or composite keys in a single round-trip. The generator emits a streaming IEnumerable<SqlDataRecord> that reuses a single record instance across rows — no DataTable, no boxing, no IN-list size limits.
Return up to five typed result sets from a single Stored Procedure execution. Helpers come in three collection flavours — IEnumerable, ReadOnlyCollection, ImmutableArray — destructured straight into a tuple at the call site.
Pick the right tier per call directly on the parameters builder. Frozen for static reference data, InMemory for short-TTL hot paths, Redis for shared distributed cache — zero overhead when not used, zero allocation on cache hits.
BeginTransactionAsync returns a thread-safe scope with a strict state machine (Active → Committed / RolledBack / Poisoned). Failures auto-poison and rollback on dispose; child SP spans nest under a parent TX activity for one cohesive trace per unit of work.
A built-in ActivitySource and Meter emit OTel-compliant spans (db.system, db.operation, db.statement) and metrics (duration, executions, errors, cache lookups). WithAspireSqlServer / WithAspireRedis wire it into the Aspire dashboard in two lines.
