C# MongoDB驱动程序2.15.0无法在Linq查询中执行

Question

我正在尝试从MongoDB获得我的结果集。我需要在这里使用过滤器。这是我的代码，试图获取数据。

IMongoCollection<VaersVax> vaersVaxCollection = mongoDatabase.GetCollection<VaersVax>("VaersVax");
var query = vaersVaxCollection.AsQueryable().Where(x => x.VAX_MANU.In(vaxManuList) && x.VAX_NAME.In(vaxNameList) && x.VAX_TYPE.In(vaxTypeList));
var list = query.Select(x => x.VAERS_ID).ToHashSet();

当我试图得到一个结果，我得到的是错误；

System.ArgumentException: Unsupported filter: {document}{VAX_MANU}.In(value(System.String[])).
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.TranslateAndAlso(BinaryExpression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.TranslateAndAlso(BinaryExpression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.PredicateTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.TranslateWhere(WhereExpression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.TranslateSelect(SelectExpression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.TranslatePipeline(PipelineExpression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.Translate(Expression node)
   at MongoDB.Driver.Linq.Linq2Implementation.Translators.QueryableTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry, ExpressionTranslationOptions translationOptions)
   at MongoDB.Driver.Linq.Linq2Implementation.MongoQueryProviderImpl`1.Translate(Expression expression)
   at MongoDB.Driver.Linq.Linq2Implementation.MongoQueryProviderImpl`1.Execute(Expression expression)
   at MongoDB.Driver.Linq.Linq2Implementation.MongoQueryableImpl`2.GetEnumerator()
   at System.Collections.Generic.HashSet`1.UnionWith(IEnumerable`1 other)
   at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToHashSet[TSource](IEnumerable`1 source, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToHashSet[TSource](IEnumerable`1 source)
   at MongoOperations.MongoHelper.getTop10MostFrequentSymptom1DataByVaxManuNameType(IEnumerable`1 vaxManuList, IEnumerable`1 vaxNameList, IEnumerable`1 vaxTypeList) in D:\KodUygulamalari\OkulProje\VaersWebAPI\MongoOperations\MongoHelper.cs:line 318
   at MongoBusiness.MongoBusinessOperations.getTop10MostFrequentSymptom1DataByVaxManuNameType(IEnumerable`1 vaxManuList, IEnumerable`1 vaxNameList, IEnumerable`1 vaxTypeList)

我可以以某种方式在MongoDB驱动程序上执行LINQ查询，还是应该检查不同的方法？

Answer 1

MongoDB.Driver支持linq.例如：

IMongoCollection<VaersVax> vaersVaxCollection = mongoDatabase.GetCollection<VaersVax>("VaersVax");
var query = vaersVaxCollection.AsQueryable().Where(x => vaxManuList.Contains(x.VAX_MANU) && vaxNameList.Contains(x.VAX_NAME) && vaxTypeList.Contains(x.VAX_TYPE));
var list = query.Select(x => x.VAERS_ID).ToHashSet();