how to write linq query of the below sql query

Sandeep Kumar

3y1.4kLINQ

select Count(*)
from [BV_OCM].[dbo].[TblBatch] WHERE (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN DATEADD(day, 1, GETDATE()) AND DATEADD(day, 2, GETDATE()))

5 Replies

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

Vishal Joshi3y ago

Accepted answer

var batchCount = TblBatch.Where(a=> a.DisposalStatus == 17 && a.ScheduleDisposalOn > DateTime.Now.AddDays(-8) && a.ScheduleDisposalOn <  DateTime.Now.AddDays(0)).Count();

Vishal Joshi3y ago
Yes if you are expecting data for the same day then need it requires >= and for toDate it requires <=
Sandeep Kumar3y ago
Here >= or only >

&& a.ScheduleDisposalOn > DateTime.Now.AddDays(-8)
Sandeep Kumar3y ago
select Count(*)
from [BV_OCM].[dbo].[TblBatch] WHERE (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN dateadd(day,-8,GETDATE()) AND GETDATE())

Vishal Joshi3y ago

Hello

Please try the below.

var batchCount = TblBatch.Where(a=> a.DisposalStatus == 17 && a.ScheduleDisposalOn > DateTime.Now.AddDays(1) && a.ScheduleDisposalOn <  DateTime.Now.AddDays(2)).Count();

Thanks