title: Make a Select between two dates captured by JQuery Datepicker with Linq Entities
body: <p>I'm using Database First, EF 6, Visual Studio 2013 Pro.</p>
  
  <p>This is the code on Controller</p>
  
  <pre><code>    public ActionResult Index(string searchString, string datepicker, string datepicker2)
      {
          var transactions = db.transactions.Include(t =&gt; t.Client).Include(t =&gt; t.DocumentType).Include(t =&gt; t.MovementType1);
          if (!String.IsNullOrEmpty(searchString))
          {
              transactions = transactions.Where(s =&gt; s.Client.Name.Contains(searchString) &amp;&amp; 
                                                s.Date &gt;= Convert.ToDateTime(datepicker) &amp;&amp; s.Date &lt; Convert.ToDateTime(datepicker2));     
          }
          return View(transaccions.ToList());
      }
  </code></pre>
  
  <p>It made the selection well when seach by client name.</p>
  
  <p>This is the code of the View</p>
  
  <pre><code>@using (Html.BeginForm())
  {
   &lt;p&gt;
      Search Transactions by Name: @Html.TextBox("SearchString") 
      First Date:  
                    &lt;input type="text" id="datepicker"/&gt;
      Second Date: 
                     &lt;input type="text" id="datepicker2"/&gt;
  
      &lt;input type="submit" value="Search"/&gt;
  &lt;/p&gt; 
  }
  </code></pre>
  
  <p>As you can see, I am capturing the dates through the selection made by the user in the datepicker.</p>
  
  <p>I want to do this query: <code>SELECT * FROM TRANSACTION WHERE Client.Name LIKE (searchString) AND DATE BETWEEN (datepicker) AND (datepicker2)</code>.</p>
  
  <p>I want to make the search by the customer's name and a date range.</p>
  
  <p>The problem is that Linq doesnt recognize the convertion method. </p>
  
  <p>I've been looking for a way to do it and none are compatible with my code.</p>
  
  <p>Any suggestions?</p>