Please write linq query of the below sql query

Question

SELECT Count(*)

FROM [BV_OCM].[dbo].[TblBatch] WHERE (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN GETDATE() AND DATEADD(day, 1, GETDATE()))

SELECT Count(*)

FROM [BV_OCM].[dbo].[TblBatch] WHERE (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN dateadd(day,-8,GETDATE()) AND GETDATE())

SELECT Count(*)

FROM [BV_OCM].[dbo].[TblBatch] WHERE (DisposalStatus = 17) AND (ScheduleDisposalOn >DATEADD(day, 1, GETDATE()))

Vishal Joshi · Answer

Hello Sandeep You can write a single query and pass parameters to make it generic. please check the below code. Public Class DBAccessClass { public int getBatchCountByDate(DateTime FromDate DateTime? ToDateint DisposalStatus) { using (var context = new BV_OCMContext()) { var count = context.TblBatch.Where(b => b.DisposalStatus == DisposalStatus && b.ScheduleDisposalOn >= FromDate && (ToDate != null ? b.ScheduleDisposalOn Thanks Vishal Joshi

Mohamed Azarudeen Z · Answer

Query 1: using (var context = new BV_OCMContext()) { var currentDate = DateTime.Now.Date; var tomorrow = currentDate.AddDays(1); var count = context.TblBatch.Count(b => b.DisposalStatus == 17 && b.ScheduleDisposalOn >= currentDate && b.ScheduleDisposalOn Query 2: using (var context = new BV_OCMContext()) { var currentDate = DateTime.Now.Date; var eightDaysAgo = currentDate.AddDays(-8); var count = context.TblBatch.Count(b => b.DisposalStatus == 17 && b.ScheduleDisposalOn >= eightDaysAgo && b.ScheduleDisposalOn Query 3: using (var context = new BV_OCMContext()) { var currentDate = DateTime.Now.Date.AddDays(1); var count = context.TblBatch.Count(b => b.DisposalStatus == 17 && b.ScheduleDisposalOn > currentDate); Console.WriteLine(count); } Make sure to replace BV_OCMContext and TblBatch with the appropriate names used in your application. Also adjust the logic for getting the current date based on your system's timezone and requirements.