How do I map lists of nested objects with Dapper

by

Alternatively, you can use one query with a lookup:

var lookup = new Dictionary<int, Course>();
conn.Query<Course, Location, Course>(@"
    SELECT c.*, l.*
    FROM Course c
    INNER JOIN Location l ON c.LocationId = l.Id                    
    ", (c, l) => {
        Course course;
        if (!lookup.TryGetValue(c.Id, out course))
            lookup.Add(c.Id, course = c);
        if (course.Locations == null) 
            course.Locations = new List<Location>();
        course.Locations.Add(l); /* Add locations to course */
        return course;
     }).AsQueryable();
var resultList = lookup.Values;

See here https://www.tritac.com/blog/dappernet-by-example/

More Related Contents:

  1. Dapper.Rainbow VS Dapper.Contrib
  2. What is the “N+1 selects problem” in ORM (Object-Relational Mapping)?
  3. What is the difference between fetch=”EAGER” and fetch=”LAZY” in doctrine
  4. Is there a way to call a stored procedure with Dapper?
  5. Performing Inserts and Updates with Dapper
  6. What are the advantages of using an ORM? [closed]
  7. Dapper and SQL Injections
  8. What is an Object-Relational Mapping Framework? [duplicate]
  9. Doctrine 2 ArrayCollection filter method
  10. Memory leaks Symfony2 Doctrine2 / exceed memory limit
  11. Dapper and anonymous Types
  12. Hibernate Annotations – Which is better, field or property access?
  13. Using an ORM or plain SQL? [closed]
  14. Bypass GeneratedValue in Hibernate (merge data not in db?)
  15. How should equals and hashcode be implemented when using JPA and Hibernate
  16. LINQ To Entities does not recognize the method Last. Really?
  17. Does Dapper support SQL 2008 Table-Valued Parameters?
  18. How to implement Generic Repository Design Pattern with Dapper?
  19. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  20. Automatic reserved word escaping for Hibernate tables and columns
  21. What’s the use of session.flush() in Hibernate
  22. Is it possible to output generated SQL using EclipseLink without having to increase log verbosity?
  23. Enum in Hibernate, persisting as an enum
  24. Doctrine – How to print out the real sql, not just the prepared statement?
  25. Closing connection when using Dapper
  26. Entity Framework | Sequence contains more than one matching element
  27. How do I handle Database Connections with Dapper in .NET?
  28. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  29. PHP ORMs: Doctrine vs. Propel
  30. Hibernate hbm2ddl.auto, possible values, and what they do

Leave a Comment