c# - 如何选择最后一小时和groupby分钟？

Question

我想使用EF从SQL数据库中选择数据，选择最后一小时，然后按分钟分组。

var result = _dbContext.views
             .Where(x => x.Id == id && x.Created  > DateTime.UtcNow.AddHours(-1))
             .OrderBy(x => x.Created)
             .GroupBy(x=> x.Created.Where({Range is 1 minute}));

Answer 1

DateTime 实例有一个 Minute 属性，它是一个 int 所以你可以使用 x.Created.Minute 用于分组:

var result = _dbContext.views
             .Where(x => x.Id == id && x.Created  > DateTime.UtcNow.AddHours(-1))
             .OrderBy(x => x.Created)
             .GroupBy(x=> x.Created.Minute}));