SmartSql.NET ORM Inspired by MyBatis

XML-managed SQL with read/write splitting, caching, dynamic repositories, and diagnostics — simple, efficient, high-performance.

Get Started

Architecture

View on GitHub

XML SQL Management

Define and manage SQL statements in XML files with dynamic tags for conditional SQL construction — IsNotEmpty, IsEqual, Switch, Where, Set, For, and more.

Read/Write Splitting

Configure read and write data sources declaratively in XML. Automatic weighted load balancing across multiple read replicas.

Middleware Pipeline

Modular execution pipeline with initializer, statement preparation, caching, transaction, data source filtering, command execution, and result handling.

Dynamic Repository

Auto-implement repository interfaces via IL emit. Interface methods map to SQL statements by naming convention — zero boilerplate.

Built-in Caching

LRU and FIFO in-memory caches plus Redis distributed cache. Configurable flush intervals and FlushOnExecute for automatic invalidation.

Diagnostics & Monitoring

Built-in DiagnosticSource events for command execution, session lifecycle, and errors. Integrates with APM tools like SkyWalking.