title: how to list data order by date in mvc view
body: <p>Iam using mvc, i want to retreive data in index view order by date.</p>
  
  <pre><code>var cn = from a in db.table1 
           join b in db.table2 on a.Country equals b.CountryCode
           join c in db.table3 on a.DealerId equals b.CompID  
           order by a.date desc select a;
  
  return View(cn.ToList());
  </code></pre>
  
  <p>without datatables it is working fine, but datatables not allowing to sort by date. it is only displaying the data by primary key value order
  Any help will be greatly appreciated.</p>