4

Not sure how to do this with Dapper. I can get parent and multi-children records using this SO item : How do I map lists of nested objects with Dapper

How would I adjust this for 3 levels of records. Or possibly N levels?

Here are my classes....

public class T1
{
     public int t1id { get; set; }
     public string f1 {get;set;}
     public List<T2> t2s { get; set; }
}

public class T2
{
    public int t2id { get; set; }
    public int pid { get; set; }
    public string f2 {get; set; }
    public List<T3> t3s {get;set;}
}

public class T3
{
    public int t3id { get; set; }
    public int pid { get; set; }
    public string f3 {get;set;}
}

I would like to use dapper to parse a 3 level left join sql statement.

Thanks in advance for your consideration.

Community
  • 1
  • 1
JustAspMe
  • 418
  • 1
  • 4
  • 18

0 Answers0