ef核心linq表达式

lx0bsm1f  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(207)

贺林克表情

where (((([x].IsDeleted == False) AndAlso ([x].IsActive == True)) AndAlso ([x].NextInvoiceDate < Convert(DateTime.UtcNow, Nullable`1))) OrElse ([x].ScheduleEndDate > Convert(DateTime.UtcNow, Nullable`1)))

无法翻译,将在本地进行评估。
我试图从我的sql数据库中获取recor列表,但在where子句中获取异常
实际的linq表达式如下

public IList<InvoiceSchedule> GetRecurringInvoiceScheduleToExecute()
    {

        var invoiceSchedule = _InvoiceScheduleSet
                   .Where(x => x.IsDeleted == false
                   && x.IsActive == true
                && x.NextInvoiceDate < DateTime.Today
                  || x.ScheduleEndDate != null ? x.ScheduleEndDate > DateTime.UtcNow : true
                   ).ToList();

        return invoiceSchedule;
    }

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题