Linq where clause compare only date value without time value March 19, 2023 by Tarik There is also EntityFunctions.TruncateTime or DbFunctions.TruncateTime in EF 6.0 or later