mysql datediff linq_linq to entities查询使用大于小于匹配数据库字符串日期方法

展开全部

Entity Framework(LINQ to Entities)使用日32313133353236313431303231363533e59b9ee7ad9431333339663330期判断条件Truncate日期函数,类似Convert函数，MYSQL数据库可以直接使用convert(varchar(10),a.cjrq,120)

LINQ to Entities使用日期字段查询，截取日期，不包括时间，测试环境SQL Server2005/2008，Entity Framework4.0

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的函数也可以实现

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());

}

}筛选本周数据

//获取当天的数据

DrawRecordDA _recordDA = new DrawRecordDA();

var query = _recordDA.GetQuery();

//筛选 当天

//query = query.Where(q=>SqlFunctions.DateDiff("day",q.AddTime,DateTime.Now)==0);

//筛选 当天

//  query = query.Where(q=>q.AddTime.Day==DateTime.Now.Day);

//筛选 本周

query = query.Where(q => SqlFunctions.DateDiff("week", q.AddTime, DateTime.Now) == 0);

Console.WriteLine(query.Count());