query using between two dates code example Example: difference between two dates efcore (EndDate.Date - StartDate.Date).Days //int