asp.net mvc - Filter data in jqgrid by date in lambda expression -

 public list<email> getemailaccountdetailbyidwithsorting(                                             long emailfolderid,                                             string subject,                                              string date,                                              string sortcolumn,                                              string sortorder,                                             int pagesize,                                             int pageindex,                                             out int totalrecords)      {  var emails = db.emails                .where(e => e.subject.contains(subject) &&                               convert.todatetime(e.date).toshortdatestring() == date &&                             e.emailfolderid == emailfolderid)                .orderby(u => u.subject)                .thenby(u => u.subject);           switch (sortcolumn)         {             case "subject":                 emails = (sortorder == "desc") ? emails.orderbydescending(u => u.subject) : emails.orderby(u => u.subject);                 break;             case "date":                 emails = (sortorder == "desc") ? emails.orderbydescending(u => u.date) : emails.orderby(u => u.date);                 break;             default:                 break;         }         totalrecords = emails.count();         return emails.skip((pageindex - 1) * pagesize).take(pagesize).tolist();     } 

in linq query string input date "2013-07-15" how convert e.date database date input date format. in query database date "2013-07-15 11:35:48.000"

may you:- replace

convert.todatetime(e.date).toshortdatestring() 

with

convert.todatetime(e.date).tostring("yyyy-mm-dd")