Rinku
Install
dotnet add package Rinku
First query
public record Album(int Id, string Title);
static readonly QueryCommand GetAlbums = new("SELECT AlbumId AS Id, Title FROM albums WHERE ArtistId = @artistId");
List<Album> albums = GetAlbums.Query<List<Album>>(cnn, new { artistId = 7 });
Documentation
Running queries
Execution · Result shapes · Values · Builders · Async · Streaming · Stored procedures · Multiple results
Mapping
Objects · Recursive mapping · Name adaptation · Construction · Multi-row mapping · Grouping · Tuples · Dynamic rows · Database NULL
Conditional SQL
Variables · Markers · Collections · Dynamic projection · Handlers · Cheat sheet
Advanced customization
Customization · Type registration · Multi-row mapping · Result parsers · Parameters · Method caller · Caches
Code generation
Code generation · Configure · Queries · Generated code · Refresh · Analyzers
Tracking
Tracking · Runtime tracking · Items · Lists · Binding · Validation · Persistence