title: An expression of non-boolean type specified in the context where condition is expected in asp.net mvc
body: <p>i want to use following SQL query for displaying records but i am getting error below DropDate</p>
  
  <blockquote>
    <p>An expression of non-boolean type specified in the context where
    condition is expected</p>
  </blockquote>
  
  <p>Here is my query</p>
  
  <pre><code>Select rm.RoomID,rm.RoomNo,rd.CheckIn,rd.CheckOut,ity.ItemTypeName,ln.ReservationID,g.GuestID,g.GuestName,ln.LaundryID,it.ItemName,ln.PickDate,ln.ServiceKind,l     n.DropQty,ln.DropDate from Laundry ln 
  inner join Items it on ln.ItemId = it.ItemId
  inner join ItemTypes ity on ity.ItemTypeId = it.ItemTypeId 
  inner join Rooms rm on ln.RoomID = rm.RoomID
  left join Reservation_Guest rg on rg.ReservationID = ln.ReservationID 
  left join ReservationDetails rd on rd.ReservationID = ln.ReservationID 
  left join Guests g on g.GuestID = rg.GuestID where PickDate is not null 
  and DropDate and OutDate is null
  </code></pre>
  
  <p>I am getting error from DropDate i want display records with PickDate is not null and DropDate and OutDate is null
  Please suggest me any better way.</p>