Return multiple parameters from a list collection based on amalgamated function

Question

User1909155429 posted

pr = From p In product.Values Group p.Price By Key = p.Email Into Group = Group _
                  Select New With {.Email = Key, .Price = Group.Sum()}

i have the following query statement and want to retrieve the ContactID parameter value inaddition to the Email  and Price parameters ?

return the distinct Email and ContactID values together with the total price for each distinct parameter

Answer 1

User1140095199 posted

Hi,

Try the code below. Though I don't know the complete structure of the table you can refer to the following code and modify as per your need.

            var pr = from p in db.ProductTable
                     group p by p.ContactID into datagroup
                     select new
                     {
                         contactID = datagroup.Key,
                         email = datagroup.FirstOrDefault().Email,
                         price = datagroup.Sum()
                     };

Hope it helps!
Best Regards!

 

 

Answer 2

User1909155429 posted

Hello,

Thanks for the code, but i am using a list collection  Product.values for the datasource !

error exception states datagroup is not accesible in this context !