Notes on building
fast, honest data access.

Batch Operations

Packing thousands of single-row statements into a handful of round trips, without changing a single call site.

Bulk Operations

Set-based inserts, updates, deletes, and merges that bypass row-by-row round trips entirely.

Caching

A key/value layer in front of your read operations that skips the round trip entirely once something is already in memory.

Class Handlers

Intercepts the moment a whole entity is read from or written to the database, for validation or side effects at the model level.

Class Mapping

Attribute-based control over how a class and its properties line up with tables, columns, keys, and handlers.

Connection Persistency

Controls whether a repository opens a fresh connection per call or holds one open for its entire lifetime.

Dynamics

CRUD against a literal table name and anonymous objects, for the calls that don't warrant a full entity model.

Enumeration

Enum properties round-trip as strings by default, with an escape hatch to force numeric storage or fully custom handling.

Expression Trees

Four different ways to express a filter, from a plain anonymous object to fully composable query trees.

Hints

Table hints like NOLOCK or TABLOCK, passed straight through to SQL Server without dropping into raw SQL.

Implicit Mapping

Attribute-free mapping for class names, columns, keys, and types, configured entirely through mapper classes.

Multiple Query

Fetch a parent and its related rows in a single round trip instead of one query per relationship.

Property Handlers

Custom, per-property conversion logic for the cases where the default type mapping isn't enough.

Repositories

A dedicated class between your application and the database, so every data access call funnels through one place.

Targeted Operations

Naming exactly which columns an operation should touch, without a change tracker doing the diffing behind your back.

Telemetry

Opt-in, drop-in telemetry that captures every operation and publishes it to a collector and Grafana dashboard — no custom trace class required.

Tracing

Hooks before and after every execution for logging, auditing, or cancelling a command outright.

Transaction

Ordinary ADO.NET transactions, shared across as many repository or connection calls as you need.

Type Mapping

Maps a .NET CLR type, or a single property, to its exact equivalent database type.