转换为Mongodb C#驱动程序

Question

有人能帮我把以下内容翻译成MongoDB2.4 C#驱动程序的代码吗？我一直在努力让这件事起作用，但我很难弄清楚。当我在C#驱动器中运行以下mongo查询时，没有记录。当我在mongo命令行中运行时，我会得到2条记录。我只需要了解我在做什么，这会导致在使用C#驱动程序时行为上的差异。

到目前为止，对于C#驱动程序，我有以下内容：

 public IEnumerable<ComponentRecordDataModel> GetComponentRecords(
        )
        {
            var componentTypeFilter = Builders<ComponentRecordDataModel>.Filter.Eq(x => x.ComponentType, "Investment");
            var authorizedUserFilter =
                Builders<ComponentRecordDataModel>.Filter.AnyEq(x => x.AuthorizedUserIds, "59e8c1d35e13de1494887658");

            var componentFieldFilters = new List<FieldValueDataModel>
            {
                new FieldValueDataModel()
                {
                    FieldId = "59d664d1c153f67518f98888",
                    Value = "gov"
                },
                new FieldValueDataModel()
                {
                    FieldId = "59d664d1c153f67518f98889",
                    Value = "azure"
                }
            };

            var componentFilters = new List<FilterDefinition<FieldValueDataModel>>();
            foreach (var componentFieldFilter in componentFieldFilters)
            {

                var bsonRegex = new BsonRegularExpression(Regex.Escape(componentFieldFilter.Value), "i");
                componentFilters.Add(Builders<FieldValueDataModel>.Filter.And(new[]
                {
                    Builders<FieldValueDataModel>.Filter.Eq(x => x.FieldId, componentFieldFilter.FieldId),
                    Builders<FieldValueDataModel>.Filter.Eq(x => x.Value, bsonRegex)
                }));
            }

            var fieldFilter = Builders<ComponentRecordDataModel>.Filter.ElemMatch(
                x => x.Fields, Builders<FieldValueDataModel>.Filter.Or(componentFilters)
                );

            var filter = componentTypeFilter & authorizedUserFilter & fieldFilter;
            var renderedFilter = filter.ToJson();

            return MongoContext.Find(filter).ToList();
        }

我试图复制的/The mongodb查询如下所示/

db.getCollection('componentRecords').aggregate(
    [{
            $match: {
                "componentType": "Investment"
            }
        },
        {
            $match: {
                "authorizedUserIds": {
                    $elemMatch: {
                        $in: ["59e8c1d35e13de1494887658"]
                    }
                }
            }
        },
        {
            $match: {
                "fields": {
                    $elemMatch: { $or:
                     [{ $and : [
                                    { fieldId: ObjectId("59d664d1c153f67518f98888") },
                                    { value: { "$regex": "gov", '$options' : 'i' } }
                                    ]},
                                                           { $and : [
                                    { fieldId: ObjectId("59d664d1c153f67518f98889") },
                                    { value: { "$regex": "azure", '$options' : 'i' } }
                                    ]}                 
                                                                            ] 

                    }
                }
            }
        }
    ])

Answer 1

你试过用linq吗？它可能更容易理解和写作：

var arr = new [] { "59e8c1d35e13de1494887658" };
var id1 = ObjectId("59d664d1c153f67518f98888");
var gov = "gov";

var id2 = ObjectId("59d664d1c153f67518f98889");
var azure = "azure";

collection.AsQuerable().Where(w =>
w.componentType == "Investment" &&
w.authorizedUserIds.Any(a => arr.Contains(a.X)) &&
(
 (w.fieldId == id1 && w.value.ToLower() == go".ToLower()) ||
 (w.fieldId == id2 && w.value.ToLower() == azure.ToLower()) ||
)
).ToList();

实际上，我并没有在实际示例中尝试这段代码，而是在mongodb中使用linq。