C#Linq查询.日期之间的日期不起作用 [英] C# Linq query.Date Between Dates don't work

问题描述

我尝试了两种仅从日期框架中选择日期的方法，但仍然得到了错误的结果.我看到了另一篇文章，但回复对我不起作用.请帮助我.

I tried on two ways to choose to date only from the date frame but still, I get the wrong result. I saw another post but the response doesn't work for me. Please help mine.

 List<Measurement> measurementsForTemplate = await databaseCommandContext.CreateSet<Measurement>()
                .Include(v => v.MeasuredValues)
                .Where(x => x.MeasurementFormTemplateId == command.TemplateId )
                .Where(v => v.MeasuredValues.Any(d => d.Time >= command.FromDate))
                .Where(v => v.MeasuredValues.Any(d => d.Time <= command.ToDate)).ToListAsync(cancellationToken);

或者我在上面的查询中创建了一个没有过滤的对象，然后

Or I created an object without filtering in the above query and then

    var measurementsForTemplateDateLimit = measurementsForTemplate.Where(b => b.MeasuredValues
    .Any(d => d.Time >= command.FromDate && d.Time <= command.ToDate)).Select(b => b);

推荐答案

请参见下图和解决方案

See figure below with solution

这篇关于C#Linq查询.日期之间的日期不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！