Loading

LINQ Query convert to DTO

Geni Lou

how can I convert the LINQ query below and convert into model?

var sales = _context.Sales

.Include(x => x.Product)

.GroupBy(x => new { x.ProductId, x.Name})

.Select(g => new{

Id = g.Key,

Name = g.Key.Name,

Quantity = g.Sum(s => s.Quantity)

});

var list = (List)sales;

public class SupplyModel

{

public Guid Id { get; set; }

public string Name { get; set; }

public int Quantity { get; set; }

}

2 Replies

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

Sachin Singh5y ago
Accepted answer
Instead of projecting into anonymous type , project the query result to your class object.
_context.Sales
.Include(x => x.Product)
.GroupBy(x => new { x.ProductId, x.Name})
.Select(g => new SupplyModel{
Id = g.Key,
Name = g.Key.Name,
Quantity = g.Sum(s => s.Quantity)
});
and that's it.
Rijwan Ansari5y ago
Better use common mapper extension or class to map between dto and models.
There is library as well Automapper. Check automapper which is quite popular.