2
Answers

help me to convert this query to linq

Patel

Patel

2y
973
1

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)