title: LINQ to Entities does not recognize the method
body: <p>I am getting this error in <code>@foreach(var item in Model)</code> line.</p>
  
  <p>How can I fix it?</p>
  
  <blockquote>
    <p>LINQ to Entities does not recognize the method
    'System.Collections.Generic.List<code>1[System.Char]
    ToList[Char](System.Collections.Generic.IEnumerable</code>1[System.Char])'
    method, and this method cannot be translated into a store expression.</p>
  </blockquote>
  
  <p><strong>Controller</strong></p>
  
  <pre><code> public ActionResult ProductIndex(int pageno= 0)
   {
       ViewBag.PageNumber= Paging.CountPageNumber(db.Products.Count(), 8);
       ViewBag.ActivePageNo= sayfaNo;
       var product = db.Products.OrderBy(x =&gt; 
           x.Name.Skip(pageno* 8).Take(8).ToList());
       return View(product);
   }
  </code></pre>
  
  <p><strong>View</strong></p>
  
  <pre><code>&lt;tr&gt;
      &lt;th&gt;ID&lt;/th&gt;
      &lt;th&gt;Name&lt;/th&gt;
      &lt;th&gt;Price&lt;/th&gt;
      &lt;th&gt;Brand&lt;/th&gt;
      &lt;th&gt;Category&lt;/th&gt;
      &lt;th&gt;Size&lt;/th&gt;
      &lt;th&gt;Stock&lt;/th&gt;
      &lt;th&gt;Active&lt;/th&gt;
      &lt;th&gt;Edit&lt;/th&gt;
  &lt;/tr&gt;
  @foreach (var item in Model)
  {
      &lt;tr&gt;
          &lt;td&gt;@item.Id&lt;/td&gt;
          &lt;td class="box-title" data-original-title="click to edit"&gt;
              @Html.ActionLink(item.Name, "ProductDetails", new { id = item.Id })
          &lt;/td&gt;
          &lt;td&gt;@item.Price&lt;/td&gt;
          &lt;td&gt;@item.Brand&lt;/td&gt;
          &lt;td&gt;@item.Category.Name&lt;/td&gt;
          &lt;td&gt;@item.Size&lt;/td&gt;
          &lt;td&gt;@item.StockQuantity&lt;/td&gt;
          @if (item.IsActive)
          {
              &lt;td&gt;Aktif&lt;/td&gt;
          }
          else
          {
              &lt;td&gt;Pasif&lt;/td&gt;
          }
          &lt;td&gt;
              &lt;a href="../Admin/SupplierEdit/@item.Id"&gt;
                  &lt;i class="fa fa-pencil-square-o"&gt;&lt;/i&gt;Edit
              &lt;/a&gt;&amp;nbsp;&amp;nbsp;
              @if (item.IsActive)
              {
                   &lt;a href="../Admin/ProductDelete/@item.Id"&gt;
                      &lt;i class="fa fa-minus-circle"&gt;&lt;/i&gt;Delete
                   &lt;/a&gt;
              }
              else
              {
                  &lt;a href="../Admin/ProductDelete/@item.Id"&gt;
                      &lt;i class="fa fa-check"&gt;&lt;/i&gt;Activate
                  &lt;/a&gt;
              }
          &lt;/td&gt;
      &lt;/tr&gt;
  }
  </code></pre>