MongoDB field-array searching (C#, How to?)

Question

Please tell me how make search by fields-arrays? I have some fields of type List<Int64>. For example first document has field-array with numbers [1,2,3,4] and second document has such field with numbers [4,5,6,7].

I want to find documents where my field consists 3 and 4 numbers, so it is first document. I am looking for examples that are based on official MongoDB C# driver;)

Thank you very much!!!

Andrew Orsich · Accepted Answer · 2013-10-29 08:19:10Z

8

You should use Query.All(). Code like this:

var array = new List<int>() {3, 4};
var query = Query.All("SomeArray", new BsonArray(array));
collection.Find(query);

The result of Query.All will all documents thats have nested array SomeArray with values 3 and 4.

If you want 3 or 4 use Query.In("SomeArray", new BsonArray(array))

References to the documentation: $all, $in

edited Oct 29, 2013 at 8:19

answered Mar 28, 2011 at 10:56

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Syska Over a year ago

Is this supported in the LINQ provider?

mmmdreg Over a year ago

Old answer but note that "BsonArray.Create(array)" is obsolete. Current syntax is "new BsonArray(array)".

seldary · Accepted Answer · 2014-08-21 17:44:56Z

1

In recent versions of the C# driver you can use:

Query<MyType>.All(_ => _.MyPropertyName, array));

answered Aug 21, 2014 at 17:44

seldary

6,2564 gold badges43 silver badges55 bronze badges

Collectives™ on Stack Overflow

MongoDB field-array searching (C#, How to?)

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related