Linq 时间比较

本月内+今天

private DateTime dtMonthFirstday = Convert.ToDateTime(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString("yyyy-MM-dd"));
private DateTime dtToday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
private DateTime dtNexDay = Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"));

--今天

Where(p => p.Created >= dtToday && p.Created < dtNexDay).Count();

 

当月

Where(p => p.Created >= dtMonthFirstday).Count();