我如何仅在下面的EF中获得今天的记录。我在下面尝试过但没有运气:
List<VacancyBasket> VacancyBasket = bModel.VacancyBaskets
.Where(b => b.BasketID == teacherGuid && b.Created == DateTime.Now)
.ToList();
我收到异常:
LINQ to Entities不支持指定的类型成员'Date'。仅支持初始化程序,实体成员和实体导航属性。
你需要DateTime
像这样
var todaysDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day);
现在通过过滤器
List<VacancyBasket> VacancyBasket = bModel.VacancyBaskets
.Where(b => b.BasketID == teacherGuid && b.Created == todaysDate)
.ToList();
否则,您将首先获得今天的日期。
DateTime today = DateTime.Now.Date;
然后像这样实现它:
List<VacancyBasket> VacancyBasket = bModel.VacancyBaskets
.Where(b => b.BasketID == teacherGuid && (b.Created.Value.Year == today.Year && b.Created.Value.Month == today.Month && b.Created.Value.Day== today.Day))
.ToList();
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句