Hello

I trust this message finds everyone well. I have an example Linq query. How do I add a SUM or COUNT field to a linq query?

                    q = from u in metaData.Customers
                         join x in metaData.Orders
                         on u.CustomersId equals x.CustomersId 
                         orderby u.Name

Regards, Simon

You need to Group By to use add an Aggregate to the select list, right?

Here is an example of a Group By from the documentation

And since this is not an LLBLGen specific construct, you can find many examples and tutorials on using LinQ on the internet.