Loading

How can I make mapping in Dapper one to many?

How can I make mapping in Dapper one to many?

Murat Kurtbogan

9y7kLearn iOS Programming

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 { 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 { 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 :)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Murat Kurtbogan9y ago
Hi Rajeesh.

Thank you so much your answer

I read this URL before and I tested Slapper Automapper. But It is not working healthy. It is not mapping child models. My test codes are below.

public class Customer
{
public int CustomerId;
public string FirstName;
public string LastName;
public IList Orders;
}
public class Order
{
public int OrderId;
public decimal OrderTotal;
public IList OrderDetails;
}
public class OrderDetail
{
public int OrderDetailId;
public decimal OrderDetailTotal;
}

void GetMappingList()
{
dynamic customer1 = new ExpandoObject();
customer1.CustomerId = 1;
customer1.FirstName = "Bob";
customer1.LastName = "Smith";
customer1.Orders_OrderId = 1;
customer1.Orders_OrderTotal = 50.50m;
customer1.Orders_OrderDetails_OrderDetailId = 1;
customer1.Orders_OrderDetails_OrderDetailTotal = 25.00m;
dynamic customer2 = new ExpandoObject();
customer2.CustomerId = 1;
customer2.FirstName = "Bob";
customer2.LastName = "Smith";
customer2.Orders_OrderId = 1;
customer2.Orders_OrderTotal = 50.50m;
customer2.Orders_OrderDetails_OrderDetailId = 2;
customer2.Orders_OrderDetails_OrderDetailTotal = 25.50m;
var customerList = new List { customer1, customer2 };
var customers = Slapper.AutoMapper.MapDynamic(customerList);
}
Rajeesh Menoth9y ago
Hi,

Please check the following thread :

http://stackoverflow.com/questions/9350467/how-do-i-write-one-to-many-query-in-dapper-net