Cast dynamic dapper query

Question

Im trying to convert a dynamic query from dapper to IDictionary<string, object>

const string sql = @"SELECT Name, Street FROM Contact";
dynamic query = null;

using (var cn = Connection)
{
    query = cn.Query<dynamic>(sql);
}

var rows = query as IDictionary<string, object>;

foreach (var row in rows)
{
    // Getting values and objects
}

But the cast always return null. Any clue?

Answer 1

You need to cast the individual rows as IDictionary<string, object>:

const string sql = @"SELECT Name, Street FROM Contact";
IEnumerable<dynamic> results = null;

using (var cn = Connection)
{
    results = cn.Query<dynamic>(sql);
}

foreach (var row in results)
{
     var fields = row as IDictionary<string, object>;
     // do something with fields["Name"] and fields["Street"]
}