.NET5 Core 关于LINQ查询使用DateDiff解决方案|C/S开发框架

SELECT * FROM sys_MSG_Queue WHERE DATEDIFF(dd,SendTime,GETDATE())<15

var listData = from c in q1 
where DateTime.Now < c.SendTime.Value.AddDays(15)