元素“group”与Gillie类的任何字段或属性都不匹配。就业中心。领域KeyValueEntity

Question

有人能帮我吗？我花了很多时间来解决这个问题，什么都没有

这是我的实体和帮助对象：

public class Course
{
    [BsonId]
    [BsonRepresentation(BsonType.ObjectId)]
    public ObjectId Id { get; set; }

    [BsonRepresentation(BsonType.ObjectId)]
    [BsonElement("_etag")]
    public ObjectId Etag { get; set; }

    [BsonElement("group")]
    public KeyValueEntity<string> Group { get; set; }

    [BsonElement("values")]
    public GroupValuesCourse[] Values { get; set; }
}

public class KeyValueEntity<T>
{
    [BsonElement("key")]
    [JsonProperty("key")]
    public string Key { get; set; }

    [BsonElement("value")]
    [JsonProperty("value")]
    public T Value { get; set; }

    public override string ToString()
    {
        return Value?.ToString();
    }
}
public class GroupValuesCourse
{
    [BsonElement("group")]
    public KeyValueEntity<string> GroupKeys { get; set; }

    [BsonElement("values")]
    public KeyValueEntity<string>[] ValueKeys { get; set; }
}

和我的存储库

    public async Task<IEnumerable<KeyValueEntity<string>>> GetAllForGroupAsync(string groupName, string subGroupName)
    {
        return await mongoDbContext.MongoDataBase.GetCollection<Course>("courses").AsQueryable()
            .Where(courseGroup => courseGroup.Group.Value == groupName)
                .SelectMany(courseGroups => courseGroups.Values)
                .Where(subgroup => subgroup.GroupKeys.Value == subGroupName)
                    .SelectMany(groups => groups.ValueKeys)
                    .OrderBy(value => value.Value)
                    .ToListAsync();
    }

执行后，告诉我：系统。FormatException:元素“group”与Gillie类的任何字段或属性都不匹配。就业中心。领域KeyValueEntity`1[[System.String，System.Private.CoreLib，Version=4.0.0.0，Culture=neutral，PublicKeyToken=7cec85d7bea7798e]]。但我确信映射是正确的。有人能帮我找出错误吗？

Answer 1

我已经用这个小技巧自己实现了。我使用了Select and First而不是SelectMany，现在可以使用了。据我所知，mongodbDriver不支持这样的硬质量。所以这是我的结果

    public async Task<IEnumerable<KeyValueEntity<string>>> GetAllForGroupAsync(string groupName, string subGroupName)
    {
        return async coursesCollection.AsQueryable()
             .Where(courseGroup => courseGroup.Group.Value == groupName)
                .SelectMany(courseGroups => courseGroups.Values)
                    .Where(subGroup => subGroup.GroupKeys != null)
                    .Where(subgroup => subgroup.GroupKeys.Value == subGroupName)
                        .Select(groups => groups.ValueKeys)
                        .FirstAsync();
    }

Answer 2

这似乎是理所当然的。对于某些课程，组为空。也许会以某种方式过滤掉。我添加了一个where子句作为示例来消除它们。

public async Task<IEnumerable<KeyValueEntity<string>>> GetAllForGroupAsync(string groupName, string subGroupName)
{
    return await mongoDbContext.MongoDataBase.GetCollection<Course>("courses").AsQueryable()
        .Where(courseGroup => courseGroup.Group != null)
        .Where(courseGroup => courseGroup.Group.Value == groupName)
            .SelectMany(courseGroups => courseGroups.Values)
            .Where(subgroup => subgroup.GroupKeys.Value == subGroupName)
                .SelectMany(groups => groups.ValueKeys)
                .OrderBy(value => value.Value)
                .ToListAsync();
}