Entity Framework(LINQ to Entities)使用日期判断条件Truncate日期函数,类似Convert函数,MYSQL数据库可以直接使用convert(varchar(10),a.cjrq,120)
LINQ to Entities使用日期字段查询,截取日期,不包括时间,测试环境SQL Server2005/2008,Entity Framework4.0
[TestMethod] public void TestMethod1() { using (var _context = new hotelEntities()) { var rq = DateTime.Now.Date; var query = from q in _context.UV_RZJL_RZRY_Single where EntityFunctions.TruncateTime(q.LDRQ) >=rq select q; Assert.Inconclusive(query.Count().ToString()); } }
//SqlFunctions.DateDiff的函数也可以实现
[TestMethod] public void TestMethod1() { using (var _context = new hotelEntities()) { var rq = DateTime.Now.Date; var query = from q in _context.UV_RZJL_RZRY_Single where SqlFunctions.DateDiff("day",rq,q.LDRQ)>0 select q; Assert.Inconclusive(query.Count().ToString()); } }