c# - How to return dynamic types List<dynamic> with Dapper ORM

Question

I have been using Dapper.net for a while now and its a very good ORM mapper which works great with .Net dynamic types.

But I noticed that when Dapper retrieves data from a database it returns as DapperRow type.

Is there are any way that I can return it in any other type Like System.Dynamic.ExpandoObject?

Answer 1

Sure!

As per dapper documentation use the query method and get your dymanics:

dynamic account = conn.Query<dynamic>(@"
                    SELECT Name, Address, Country
                    FROM Account
            WHERE Id = @Id", new { Id = Id }).FirstOrDefault();
Console.WriteLine(account.Name);
Console.WriteLine(account.Address);
Console.WriteLine(account.Country);

As you can see you get a dynamic object and you can access its properties as long as they are well defined in the query statement.

If you omit .FirstOrDefault() you get an IEnumerable<dynamic> which you can do whatever you want with it.