Patel

Patel

  • 2k
  • 188
  • 7.3k

help me to convert this query to linq

Sep 9 2022 3:05 AM

help me to convert this query to linq

Select Count (d.eanumber) as Eas, dem. Model, month (dem. IncorporatedDate) as months, Year (dem. IncorporatedDate) as years from DeviationEngineModels dem join Deviation d on d.Id = dem. DeviationId where dem. IncorporatedDate is not null and dem. Published =1
and Year (dem. IncorporatedDate) = 2022
 and d.IsDeleted !=1
group by month (dem. IncorporatedDate), dem. Model, Year (dem. IncorporatedDate) ORDER BY months


Answers (2)