C# Linq Where Date Between 2 Dates

Question

我正在尝试让我的 linq 语句获取两个日期之间的所有记录，但我不太确定我需要更改什么才能使其正常工作:(a.Start >= startDate &&结束日期)

var appointmentNoShow =
    from a in appointments
    from p in properties
    from c in clients
    where a.Id == p.OID && (a.Start.Date >= startDate.Date && endDate)

Answer 1

改成

var appointmentNoShow = from a in appointments
                        from p in properties
                        from c in clients
                        where a.Id == p.OID && 
                       (a.Start.Date >= startDate.Date && a.Start.Date <= endDate)