How to query MongoDb having array using c#

Question

I have document like this:

{
    "_id" : ObjectId("56ff6d54f07a36271465441c"),
    "Author" : "John",
    "Content" : "Thera are alot of databases",
    "CreatedAtUtc" : ISODate("2016-04-02T06:57:24.542Z"),
    "Tags" : [ 
        "elasticSearch", 
        "MongoDb", 
        "C#"
    ],
    "Title" : "Best DB"
}

I like to find all documents which have tag: "MongoDb"

I tried:

var filter = Builders<Post>.Filter.In("Tags", "MongoDb");
var posts = collection.Find(filter).ToList();

Where post is a C# class

But i get no documents. Any idea?

chridam · Accepted Answer · 2016-04-02 14:12:06Z

1

When querying for documents where there is an equality match of "MongoDB" on the Tags array, just use the query document { "Tags": "MongoDb" }:

Mongo Shell

db.collection.find({ "Tags": "MongoDb" })

C#

Use the Eq method to implement a filter document that specifies an equality condition:

var filter = Builders<Post>.Filter.Eq("Tags", "MongoDb");
var posts = collection.Find(filter).ToList();

edited Apr 2, 2016 at 14:12

answered Apr 2, 2016 at 11:36

chridam

104k26 gold badges246 silver badges243 bronze badges

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

2 Comments

Blakes Seven Over a year ago

This actually resolves to { "Tags": ["MongoDB"] } which not only does not match to any element in the list, but also does not match any "list" that does not "soley" contain the "MongoDB" property. I don't think you really know the answer and just found a post you thought you would copy.

Khorshid Over a year ago

Thanks chridam, it's really too simple!.

Collectives™ on Stack Overflow

How to query MongoDb having array using c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related