MultiMap / Reduce - Counts = 0?

Question

我想为查询创建一个索引，我想将音频项目列表以及这些项目的统计信息返回到我的视图，这些项目是TotalDownloads&总计播放。

以下是我的相关文档：

Audio
 - Id
 - ArtistName
 - Name
AudioCounter
 - AudioId
 - Type
 - DateTime

这是我目前的索引：

public class AudioWithCounters : AbstractMultiMapIndexCreationTask<AudioWithCounters.AudioViewModel>
{
    public class AudioViewModel
    {
        public string Id { get; set; }
        public string ArtistName { get; set; }
        public string Name { get; set; }
        public int TotalDownloads { get; set; }
        public int TotalPlays { get; set; }
    }
    public AudioWithCounters()
    {
        AddMap<Audio>(audios => from audio in audios
                                select new
                                {
                                    Id = audio.Id,
                                    ArtistName = audio.ArtistName,
                                    Name = audio.Name,
                                    TotalDownloads = 0,
                                    TotalPlays = 0
                                });
        AddMap<AudioCounter>(counters => from counter in counters
                                         where counter.Type == Core.Enums.Audio.AudioCounterType.Download
                                select new
                                {
                                    Id = counter.AudioId,
                                    ArtistName = (string)null,
                                    Name = (string)null,
                                    TotalDownloads = 1,
                                    TotalPlays = 0
                                });
        AddMap<AudioCounter>(counters => from counter in counters
                                         where counter.Type == Core.Enums.Audio.AudioCounterType.Download
                                         select new
                                         {
                                             Id = counter.AudioId,
                                             ArtistName = (string)null,
                                             Name = (string)null,
                                             TotalDownloads = 0,
                                             TotalPlays = 1
                                         });
        Reduce = results => from result in results
                            group result by result.Id
                                into g
                                select new
                                {
                                    Id = g.Key,
                                    ArtistName = g.Select(x => x.ArtistName).Where(x => x != null).First(),
                                    Name = g.Select(x => x.Name).Where(x => x != null).First(),
                                    TotalDownloads = g.Sum(x => x.TotalDownloads),
                                    TotalPlays = g.Sum(x => x.TotalPlays)
                                };
    }
}

然而，我的TotalDownloads&CCD_ 2总是0，即使其中应该有数据。我做错了什么？

Answer 1

在reduce函数中，用.FirstOrDefault()替换.First()，然后它就工作了。

除此之外，第二个映射函数中还有一个拼写错误，因为您在同一个AudioCounterType.Download.