title: Linq query with SQL
body: <p>I have 2 tables 'Car' and 'Booking'. The car table contains the properties CarID(PK), Make, Model and Size. The 'Booking' table contains ID(PK), CarID(FK), StartDate and EndDate.</p>
  
  <p>The 2 tables contain some data that I have put in myself: </p>
  
  <p>Booking - <a href="https://i.stack.imgur.com/jpgnH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jpgnH.png" alt="enter image description here"></a>
  Car - <a href="https://i.stack.imgur.com/rVspd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rVspd.png" alt="enter image description here"></a></p>
  
  <p>This is my query so far:</p>
  
  <pre><code>var searchQuery = from c in db.Cars
       from b in db.Bookings
       where c.Size == comboBox_CarType.Text
       &amp;&amp; RentEndDate.SelectedDate &lt; b.EndDate &amp;&amp; RentStartDate.SelectedDate &gt; 
       b.StartDate
       select c.CarID + " - " + c.Make.Trim() + " - " + c.Model.Trim();
  </code></pre>
  
  <p>The user inputs 3 pieces of information: Size, Start Date and End Date for the car they wish to rent. This will then bring up the cars available at that time from the database of cars.</p>
  
  <p>My question: I have completed the size comparison however when I try to load in the available cars the above query does not bring in the vehicles, even though the logic makes sense to me</p>