How to create Linq2Sql query, calculating aggregates?
- by pil0t
Is there any way to create Linq2SQL query, that will be translated to this:
SELECT COUNT(*) as totalCount ,
SUM(v.field1) AS totalfield1,
....
SUM(v.<fieldN>) AS total<fieldN>
FROM [dbo].[SomeTable] v