EntitiframeWork中遇到的一些问题

LINQ to SQL 的查询

进行日期的匹配查询时，不能够直接使用 x.Date== DateTime.Now.Date

而要进行参数替代

var date = DateTime.Now.Date;
var item = data.OngoingMissions.FirstOrDefault(x => x.AvatarId == avatar.AvatarID && x.GameAreaId == avatar.GameAreaID && x.Type == Type&& x.Date== date);

 

 

如果var item = db.SettleMissions.Where(x => x.AvatarId == avatar.AvatarID && x.GameAreaId == avatar.GameAreaID && x.IsCompleted != 2);这样写

会报The operation cannot be completed because the DbContext has been disposed.错误

（DbContext 已被释放）

改
var item = db.SettleMissions.AsNoTracking().Where(x => x.AvatarId == avatar.AvatarID && x.GameAreaId == avatar.GameAreaID && x.IsCompleted != 2).ToList();