C# Linq Where Date Between 2 Dates

Question

Hi, I'm trying to get my linq statement to get me all records between two dates, and I'm not quite sure what I need to change to get it to work: (a.Start >= startDate && endDate)

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

Just change it to

  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)

Answer 2

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