asp.net-mvc之如何使用 Linq 在 asp.net MVC 中获取两个日期之间的天数

我需要使用 Linq 查询从数据库中获取两个日期之间的天数，请帮助我如何执行此操作。谢谢

我尝试了下面的代码，但它返回的结果是 nul!请帮忙

 DateTime rightNow = DateTime.Now; 
 
        //int totalDays = (from d in db.vuExpiredProjectsAssigned 
        //                 where d.AssignedTo==obj.DepartmentID 
        //                 select (d.AssignedDate - d.DueDate).Days).FirstOrDefault(); 
 
        //var numberdays = (from pd in db.vuExpiredProjectsAssigned 
        //                  where pd.AssignedTo == obj.DepartmentID 
        //                  select SqlFunctions.DateDiff("day", pd.AssignedDate, rightNow)); 
 
       var result =(from dd in db.vuExpiredProjectsAssigned 
                    where dd.AssignedTo==obj.DepartmentID 
                    select new 
                    { 
                        days=SqlFunctions.DateDiff("Day",dd.DueDate,rightNow) 
                    }); 
 
       ViewBag.ndays = result; 

请您参考如下方法:

Entity Framework 不支持 DateTime 算术。您必须使用 DbFunctions*。所以，对于你陈述的第一部分，是这样的:

var numberdays = ( from p in db.vuExpiredProjectsAssigned 
                     where p.AssignedTo == obj.DepartmentID 
                     select DbFunctions.DiffDays(p.AssignedDate,p.DueDate)); 

或

var numberdays = ( from p in db.vuExpiredProjectsAssigned 
                     where p.AssignedTo == obj.DepartmentID 
                     select SqlFunctions.DateDiff("day", p.AssignedDate, p.DueDate)); 

有关更多引用，请查看以下链接。

SqlFunctions Class

DbFunctions Class