CaeriusNetSQL Server Stored Procedures → C# DTOs

Compile-time safe mapping. No reflection. No DataTable. Just SQL Server + C#.

🛠️

Stored Procedures only

Data access lives in T/SQL Stored Procedures, results land in typed C# DTOs. CaeriusNet binds both sides with minimal boilerplate and DI-first design.

🚀

Ordinal mapping — no reflection

Allocation-aware, ordinal-indexed mapping via SqlDataReader. Pre-sized collections, SequentialAccess readers, and compile-time source generators.

💪

TVP + multi-result in one call

Stream thousands of IDs via Table-Valued Parameters, combine them with scalar parameters, and return up to 5 result sets in a single round-trip.

🔄

Async-only I/O

Every database call is async and CancellationToken-aware for throughput and thread-pool health.

🧊

Per-call caching

Opt into Frozen (immutable), InMemory (TTL), or Redis (distributed) caching directly on the parameters builder — zero overhead when not used.