1、查询当天时间
System.Data.Objects.EntityFunctions.DiffDays(i.createtime, DateTime.Now) < -1
//使用案例
var data = DB.表名.Where(i => System.Data.Objects.EntityFunctions.DiffDays(i.createtime, DateTime.Now) < -1 ).ToList();
2、当天时间精准查询
string str = DateTime.Now.ToShortDateString(); //获取当天短时间格式
DateTime time1 = Convert.ToDateTime(str + " 0:00:00"); //从当天0点开始
DateTime time2 = Convert.ToDateTime(str + " 23:59:59");//当天24点前
var data = DB.表名.Where(i => i.status == 1 &&(i.createtime >= time1 && i.createtime <= time2) ).ToList();