score:0

public ienumerable<appointments> getappointments(datetime start, datetime end)
{
  var bufferstart = start.adddays(-1);
  var bufferend = end.adddays(1);

  return dbcontext.appointments
   .where(a => a.begintime >= bufferstart && a.begintime < bufferend)
   .asenumerable()
   .where(a => a.begintime.datetime >= start && a.begintime.datetime < end);
}

score:4

declare @__querydate_0 datetime2 = '2021-01-01t00:00:00.0000000';
declare @__adddays_1 datetime2 = '2021-01-02t00:00:00.0000000';

select [a].[id], [a].[begintime]
from [appointments] as [a]
where (cast([a].[begintime] as datetime2) >= @__querydate_0) and (cast([a].[begintime] as datetime2) < @__adddays_1)

Related Query

More Query from same tag