2
Answers

help me to convert this query to linq

Photo of Patel

Patel

3y
1.2k
1 LINQ

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)