how to get int by using Linq group by DATEPART month in C#

Question

I have a StayDormApplications table , I have a SQL as below ,

var systemFilesItem = _db.StayDormApplications.Single(r => r.Id == dormapplication.Id);
string SQL = "SELECT  sum(days) days from StayDormApplications where poster = '" + LoginAccount + "' and DATEPART(MONTH, Sdate) = '"+ month_name + "' group by DATEPART(MONTH, Sdate);"; //

how to convert the SQL with (c#) LINQ?

A good start would be to find an O/R mapper that supports LINQ and create a class model that maps to the database. — Gert Arnold, Apr 05 '22 at 18:43
If D-Shih's answer solved you problem, don't forget to accept it. — ProgrammingLlama, May 10 '22 at 01:13

score 0 · Answer 1 · answered Apr 02 '22 at 13:35

You can try to use SqlFunctions.DatePart to make it, otherwise, your query seems don't need to use group by becuase you filter it on the condition.

var systemFilesItem = _db.StayDormApplications
                          .Where(x=> x.poster == LoginAccount && SqlFunctions.DatePart("MONTH", x.Sdate).Value == month_name)
                          .Sum(x=> x.days);

how to get int by using Linq group by DATEPART month in C#

1 Answers1