KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have two classes 'Product' and 'Seller'. public class Product { public int Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } public Seller Seller { get; set; } public int? SellerId { get; set; } } public class Seller { public int Id { get; set; } public string Name { get; set; } public List<Product> Products { get; set; } } I want to extract a list of Sellers with all of their products using dapper. Currently i'm doing it like this : Dictionary<int, Seller> dic = new Dictionary<int, Seller>(); Conn.Query<Seller, Product, int> (@"select s.*,p.* from Sellers s Join Products p on p.SellerId = s.Id", (s, p) => { if (dic.ContainsKey(s.Id)) dic[s.Id].Products.Add(p); else { s.Products = new List<Product>(); s.Products.Add(p); dic.Add(s.Id, s); } return s.Id; }); var sellers = dic.Select(pair => pair.Value); Is there any better way?
Tags (comma-separated)
Save Edits
Cancel