Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2019
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. var users = context.Users
  2. .Where(u => u.ProductsSold.Any(ps => ps.Buyer != null))
  3. .OrderByDescending(u => u.ProductsSold.Any(ps => ps.Buyer != null))
  4. .Select(u => new
  5. {
  6. firstName = u.FirstName,
  7. lastName = u.LastName,
  8. age = u.Age,
  9. count = u.ProductsSold.Count(p => p.Buyer != null),
  10. products = u.ProductsSold
  11. .Where(ps => ps.Buyer != null)
  12. .Select(ps => new
  13. {
  14. name = ps.Name,
  15. price = ps.Price
  16. }).ToList()
  17. }).ToList();
  18.  
  19. var json = JsonConvert.SerializeObject(users, Formatting.Indented);
  20.  
  21. return json;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement