Hi

I have below Sql query, i want to convert it to Linq.

SELECT SUM([Total Days]) AS 'TotalDays', SUM([Total Days]) / COUNT([Entry Date]) AS Average, DATENAME(Month, MAX([Entry Date])) AS MonthName, YEAR([Entry Date]) AS 'Year'
FROM     dbo.View_Capex_LevelWiseStatus
WHERE  ([Entry Date] BETWEEN DATEADD(month, - 12, GETDATE()) AND GETDATE())
GROUP BY YEAR([Entry Date]), MONTH([Entry Date])

Thanks