2
Reply

How can I make mapping in Dapper one to many?

Murat Kurtbogan

Murat Kurtbogan

Mar 9 2017 3:45 AM
1k
Hi everybody
 
I'm using DAPPER orm and I have dto class
 
public class SSY_GRIDITEM_DTO
{
public int FRM_ID { get; set; }
public string FRM_CODE { get; set; }
public string FRM_DESC { get; set; }
public ICollection<Grid> Grid { get; set; }
}
 
public class Grid
{
public int GRD_ID { get; set; }
public string GRD_CODE { get; set; }
public string GRD_DESC { get; set; }
public string GRD_MULTRANSLATION { get; set; }
public IList<GridItem> GridItem { get; set; }
}
 
public class GridItem
{
public int GRI_ID { get; set; }
public string GRI_CODE { get; set; }
public string GRI_MULTRANSLATION { get; set; }
}
 
my dapper request sentence  "var list = con.Query(sql);"
and results
 
 how can I mapping results in DTO class? 
 
Have a nice day :) 
 

Answers (2)