Dapper and anonymous Types

by

Is it possible to use anonymous types with Dapper?

Sure see the non-generic Query override, it return a dynamic IDictionary<string, object> this object is an expando that can either be cast or accessed with dot notation.

Eg: 

var v = connection.Query("select 1 as a, 2 as b").First(); 
Console.Write("{0} {1}",v.a, v.b) // prints: 1 2

is it then possible to do a .Select

Sure, you get an IEnumerable<dynamic> … you can run anything you want on that.

More Related Contents:

  1. Performing Inserts and Updates with Dapper
  2. Entity Framework Code First – two Foreign Keys from same table
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Entity Framework .Remove() vs. .DeleteObject()
  5. Correct use of multimapping in Dapper
  6. LINQ To Entities does not recognize the method Last. Really?
  7. How to implement Generic Repository Design Pattern with Dapper?
  8. How do I write one to many query in Dapper.Net?
  9. Minimal and correct way to map one-to-many with NHibernate
  10. Should I transform Entity (Persistent) objects to DTO objects?
  11. How do I perform an insert and return inserted identity with Dapper?
  12. Are there good reasons not to use an ORM? [closed]
  13. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  14. Eager , Lazy and explicit loading in EF6
  15. Entity Framework | Sequence contains more than one matching element
  16. How do I handle Database Connections with Dapper in .NET?
  17. Problem using SQLite :memory: with NHibernate
  18. Why Entity Framework performs faster than Dapper in direct select statement [closed]
  19. What causes “extension methods cannot be dynamically dispatched” here?
  20. Parse Xml response from a get method in C# using Linq
  21. Notify ObservableCollection when Item changes
  22. Store complex object in TempData
  23. Is it secure to store passwords in cookies?
  24. ASP.NET Web Application Message Box
  25. Convert DataTable to IEnumerable
  26. How to force a number to be in a range in C#? [duplicate]
  27. What is the fastest way to combine two xml files into one
  28. How do I create 5 buttons and assign individual click events dynamically? [closed]
  29. Entity Framework core – Contains is case sensitive or case insensitive?
  30. Adding custom attributes to an element in XAML?

Leave a Comment