Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. var results = from p in pending
  2. group p by p.ContactID into g
  3. let amount = g.Sum(s => s.Amount)
  4. select new PaymentItemModel
  5. {
  6. ContactID = g.ContactID, // <--- Error here
  7. Amount = amount
  8. };
  9.  
  10. SELECT
  11. lp.PurchasedFromContactID,
  12. SUM (lp.Amount)
  13. FROM
  14. LeadPurchases lp
  15. GROUP BY
  16. lp.PurchasedFromContactID
  17.  
  18. from p in pending
  19. group p by p.ContactID into g
  20. let amount = g.Sum(s => s.Amount)
  21. select new PaymentItemModel
  22. {
  23. ContactID = g.Key,
  24. Amount = amount
  25. };
  26.  
  27. group p by new
  28. {
  29. p.ContactID,
  30. p.Field2,
  31. p.Field3
  32. }into g
  33. select new PaymentItemModel()
  34. {
  35. ContactID = g.Key.ContactID,
  36. anotherField = g.Key.Field2,
  37. nextField = g.Key.Field3
  38. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement