要查出所有在本周的数据,实现SQL中:datepart(ww,getdate()) = datepart(ww,CreateTime),怎么用Linq实现?
dt.DayOfWeeks == DateTime.Now.DayOfWeeks
try:
SqlFunctions.DateDiff("week", CreateTime, DateTime.Now) == 0);
你也可以试试这个:
http://msdn.microsoft.com/en-us/library/dd466343.aspx