Dynamic Linq Syntax For Subquery

I want to have the following query in Dynamic LINQ.. I have tried some solutions but have not succeeded yet. select SUM([Value1]) AS [Sum] ,[Dim1] AS [Primary],

Solution 1:

Consider querying the database on your subquery, then stashing the result in a datatable which you can then compute off of.

SELECT 
value1, dim1, dim2
FROM [BudgetLine]
WHERE [BudgetID] =4

MSDN article - Compute