仔细检查CountEmailChart
。在这里,我接受DateTime
的输入,这是完全格式化的日期和时间。但问题是,我只想比较下面Entity Framework上的日期,而不是时间,以计算行数。有人能告诉我怎么做吗?
控制器代码:
public int CountEmailChart(DateTime date, int campaignID)
{
int count = dbcontext.CampaignEmails
.Count(x => x.DateSigned == date && x.CampaignID == campaignID);
return count;
}
发布于 2018-07-01 00:35:48
试着这样做。DateTime
对象的.Date
属性将仅返回日期部分。
如果你使用Entity Framework6,那么。
date = date.Date;
int count = dbcontext.CampaignEmails.Count(x => DbFunctions.TruncateTime(x.DateSigned) == date.Date && x.CampaignID == campaignID);
否则
date = date.Date;
int count = dbcontext.CampaignEmails.Count(x => EntityFunctions.TruncateTime(x.DateSigned) == date.Date && x.CampaignID == campaignID);
发布于 2018-07-01 02:49:31
卡兰的答案是正确的,但是结果查询不会使用DateSigned的索引。如果存在这样的索引(或者CampaignID和DateSigned列的组合索引),您可能更喜欢这种方法:
var startDate = date.Date;
var endDate = date.Date.AddDay(1);
int count = dbcontext.CampaignEmails.Count(x => x.CampaignID == campaignID && x.DateSigned >= startDate && x.DateSigned < endDate);
https://stackoverflow.com/questions/51116624
复制相似问题