asp.net - 根据所选日期查询记录

Question

如何根据选定的日期查询记录？我已经知道如何根据 roomId 进行查询。

在 BookingsController.cs 中：

var booking = _context.Bookings
                      .Where(b => b.RoomId == roomId)
                      .Include(b => b.TimeSlot)
                      .OrderBy(b => b.TimeSlotId)
                      .ToList();

在 BookingModels.cs 中：

public int BookingId { get; set; }
public int RoomId { get; set; }
public DateTime BookDate { get; set; }
public byte TimeSlotId { get; set; }
.
.

标签： asp.netdatedatetimemodel-view-controller

Answer 1

也可以这样写

var booking = _context.Bookings
                      .Where(b => b.RoomId == roomId)
                      .Where(b => b.BookDate == bookDate)
                      .Include(b => b.TimeSlot)
                      .OrderBy(b => b.TimeSlotId)
                      .ToList();