Parameters and Mapping to Models

Pass parameters as an anonymous object or a model, with property names that match the @ names; lists become IN lists. Columns map to properties by name, so alias any column that doesn't match.

Updated

Cheat sheet: Parameters and Mapping to Models
Category
C#
Level
Journeyman
Tags
Anonymous Type, Column Alias, c-sharp, Nullable Value Type, Parameterized Query, t-sql