Caerius.NETSQL Server Stored Procedures to C# DTOs — fast, simple, reliable

Stored Procedure ➜ DTO in microseconds, with compile‑time safety.

🛠️

Two stacks, one pipeline

Write your data access where it belongs T/SQL Stored Procedures in SQL Server and C# DTOs in your app. Caerius.NET binds them with minimal API and DI.

🚀

Mapping in µseconds

Ordinal, allocation‑aware mapping — no reflection on the hot path, pre‑sized collections, pooling, and SequentialAccess readers.

💪

Heavy inputs, one call

Pass thousands of IDs or GUIDs via TVP. Combine parameters + TVP, return multiple result sets, and keep latency predictable.

🔄

Async‑only I/O

All database calls are asynchronous by design for throughput and thread‑pool health.

🧊

Caching when it counts

Enable per‑call caching Frozen (immutable), In‑Memory (TTL), or Redis (distributed) — pick the right layer for your workload.