How to parse a JSON array in C#?

Question

Using the MongoDB C# driver how can I parse a JSON array (string) into BsonDocument[]?

We would like to store our mongo aggregation pipelines in separate JSON documents so need a way to parse them.

Neil Lunn · Accepted Answer · 2014-05-19 10:25:15Z

13

Not a bad idea if that suits your purposes. Yes the C# driver already supports BSON serialization from a JSON string source:

string json = '[
    { "$match: { "foo": "bar" } },
    { "$group": {
        "_id": null, 
        "count": { "$sum": 1 }
    }}
]';

BsonDocument pipeline = 
    MongoDB.Bson.Serialization.BsonSerializer.Deserialize<BsonArray>(json);

So you can pull in your aggregation pipeline strings formatted as JSON and use them or manipulate them as BSON documents.

answered May 19, 2014 at 10:25

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

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

2 Comments

Richard II Over a year ago

Which version of the driver? this doesn't compile for me using the 2.x C# driver. It says it can't implicitly convert BsonArray to BsonDocument. Explicit casting isn't allowed either.

Cee McSharpface Over a year ago

ten years later... I just obtained proof that it works with C# driver version 2.25.0

Louie Almeda · Accepted Answer · 2016-07-11 01:08:13Z

10

The accepted answer's result is a BsonArray, if you need a BsonDocument[] you'll do something like

BsonSerializer.Deserialize<BsonArray>(yourJsonString).Select(p => p.AsBsonDocument)

and if you need it as a List<BsonDocument>

BsonSerializer.Deserialize<BsonArray>(yourJsonString).Select(p => p.AsBsonDocument).ToList<BsonDocument>()

answered Jul 11, 2016 at 1:08

Louie Almeda

5,67035 silver badges41 bronze badges

1 Comment

Eduardo Pignatelli Over a year ago

This should be the correct answer. The first one returns a BsonArray, whether this returns a collection of BsonDocument as asked.

Collectives™ on Stack Overflow

How to parse a JSON array in C#?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related