title: How to check database between two specific date with EF?
body: <p>I would like to offer user get a report of orders from two specific dates(start-end). I want to calculate amount product(incl price) that were ordered within that period. </p>
  
  <p>This is about what I had in mind:</p>
  
  <pre><code> public ActionResult GetReport(DateTime startTime, DateTime endTime)
          {    
              var getReport = db.Orders.Where(/*Date that matches between start and end time*/);
  
              //calculate the amount of each products(incl price) 
  
              return View(reportViewModel);       
          }
  </code></pre>
  
  <p>order-table:</p>
  
  <pre><code>    public System.Guid Id { get; set; }
      public System.Guid UserId { get; set; }     
      public System.DateTime Ordered { get; set; }
  
      public virtual User User { get; set; }
      public virtual ICollection&lt;Product&gt; Products { get; set; }
  </code></pre>
  
  <p>Also, how do I send selected date-value from View to Controller (MVC) ?</p>