Dapper: How to read into list of Dictionary from query?

Question

Dapper provides lots of ways mapping data into list of dynamic objects. However in some case I'd like to read data to list of Dictionary.

The SQL may looks like:

"SELECT * FROM tb_User"

As tb_User may change outside, I don't know what columns will return in result. So I can write some code like this:

var listOfDict = conn.QueryAsDictionary(sql);
foreach (var dict in listOfDict) {
    if (dict.Contains("anyColumn")) {
        // do right thing...
    }
}

Is there any built-in methods for Dapper to do this conversion?

Answer 1

You can cast each row as IDictionary:

    var row = (IDictionary<string, object>)conn.Query("select foo = 1, bar = 'bar'").First();

    Assert.That(row["foo"], Is.EqualTo(1));
    Assert.That(row["bar"], Is.EqualTo("bar"));