when i try to check if collection contains some element i get System.ArgumentException: Unsupported filter: Contains().

for example, we have Order class with collection of order positions:

class Order

{    public int Id \{ get; set; }

   public List<OrderItem> Items { get; set; }

...

}

 

in each position we have GoodId and Amount:

class OrderPosition
{    public int Id { get; set; }

   public int GoodId { get; set; }

   public int Amount { get; set; }

}

 

now i want to select all Orders where some  good is present:

var orders = db
   .GetCollection<Order>("order").AsQueryable()
   .Where(x => x.Items.Select(e => e.GoodId).Contains(2))
   .ToArray();

 

yes, i know that i can rewrite query, but thissample is adopted my work case, so i nee dexactly that expression

 

and there is i get exception:

System.ArgumentException: Unsupported filter: Contains({document}

{Items}

.Select({document}

{GoodId}

)).
at MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate(Expression node)
at MongoDB.Driver.Linq.Translators.PredicateTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.TranslateWhere(WhereExpression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.Translate(Expression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.TranslatePipeline(PipelineExpression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.Translate(Expression node)
at MongoDB.Driver.Linq.Translators.QueryableTranslator.Translate(Expression node, IBsonSerializerRegistry serializerRegistry, ExpressionTranslationOptions translationOptions)
at MongoDB.Driver.Linq.MongoQueryProviderImpl`1.Translate(Expression expression)
at MongoDB.Driver.Linq.MongoQueryProviderImpl`1.Execute(Expression expression)
at MongoDB.Driver.Linq.MongoQueryableImpl`2.GetEnumerator()
at System.Collections.Generic.LargeArrayBuilder`1.AddRange(IEnumerable`1 items)
at System.Collections.Generic.EnumerableHelpers.ToArray[T](IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at ConsoleApp1.Program.Main(String[] args) in 

 

now i use workaround and use following expression:

var orders = db
   .GetCollection<Order>("order").AsQueryable()
   .Where(x => x.Items.Select(e => e.GoodId).Any(e => e == 2))
   .ToArray();

 

but iu think that this bug need to be fixed

 

i created fiddle with full example: https://dotnetfiddle.net/yfQk7U