MongoDB Inline query request objects

Question

Does anyone have an example query for nested / internal objects in MongoDB using NORM (C #)? For example, if a typical document in the collection looks like Order / OrderItems, how can I find a specific OrderItem by OrderItem.Quantity> 10.

Answer 1

Having typed this from memory, I'm sorry if this is not so:

using ( var session = new MongoSession<Order>( DbName ) ) { var orders = session.Queryable .Where( o => o.OrderItems.Any( oi => oi.Quantity > 10 ) ) .ToList(); } 

Answer 2

You need to create an additional “size” of the field, which you increase when adding new elements and request it.