Sql Query to Linq

Ramco Ramco

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi3y ago

Hello,

Try the below LINQ query:

var result = (from a in view_Capex_LevelWiseStatus
                          group a by new
                          {
                              a.EntryDate.Month,
                              a.EntryDate.Year
                          } into grp
                          select new ResponseClass
                          {
                              TotalDays = grp.Sum(a => a.TotalDays),
                              Average = grp.Sum(a => a.TotalDays) / grp.Count(),
                              MonthName = (new DateTime(grp.Key.Year, grp.Key.Month, 1).ToString("MMMM", System.Globalization.CultureInfo.InvariantCulture)),
                              Year = grp.Key.Year
                          }).FirstOrDefault();

Thanks

Naresh Beniwal3y ago
https://stackoverflow.com/questions/8988531/convert-sql-to-linq-query
+1