How to map to a Dictionary object from database results using Dapper Dot Net?

February 4, 2023 by Tarik

There’s various ways already shown; personally I’d just use the non-generic api:

var dict = conn.Query(sql, args).ToDictionary(
    row => (string)row.UniqueString,
    row => (int)row.Id);