How to retrieve data in proper JSON format from MongoDB in C#

Question

I want to retrieve all the documents of a collection from mongoDB in C# .Net Web API. Below code is working fine but It is returning BsonDocument

var client = new MongoClient(connectionString);
var db = client.GetDatabase("STRDB");
var mongoCollection = db.GetCollection<BsonDocument>(collection);
var documents = mongoCollection.AsQueryable();
return Ok(documents);

From above code I am getting data in below format (After JSON.stringify() in angular)

[  
   [  
      {  
         "name":"_id",
         "value":"5de9f351baca28556c6a4b71"
      },
      {  
         "name":"Name",
         "value":"Harsha"
      },
      {  
         "name":"Age",
         "value":20
      },
      {  
         "name":"Gender",
         "value":"M"
      },
      {  
         "name":"Skills",
         "value":[  
            {  
               "name":"Java",
               "value":""
            },
            {  
               "name":"Mule",
               "value":true
            },
            {  
               "name":"Angular",
               "value":""
            }
         ]
      }
   ],
   [  
      {  
         "name":"_id",
         "value":"5de9f358baca28556c6a4b72"
      },
      {  
         "name":"Name",
         "value":"Anji"
      },
      {  
         "name":"Age",
         "value":21
      },
      {  
         "name":"Gender",
         "value":"M"
      },
      {  
         "name":"Skills",
         "value":[  
            {  
               "name":"Java",
               "value":""
            },
            {  
               "name":"Mule",
               "value":true
            },
            {  
               "name":"Angular",
               "value":true
            }
         ]
      }
   ]
]

How to receive it in proper JSON format OR how to convert this BSON document in JSON as I am unable to process this output.

Hi Abhi, Have you checked this answer-> stackoverflow.com/q/27132968 This might be helpful for you — Prasad Telkikar
– Prasad Telkikar, Commented Dec 6, 2019 at 6:32

Athanasios Kataras · Accepted Answer · 2019-12-06 06:48:29Z

3

Try the following, with conversion.

var client = new MongoClient(connectionString);
var db = client.GetDatabase("STRDB");
var mongoCollection = db.GetCollection<BsonDocument>(collection);
var documents = mongoCollection.AsQueryable();
return Ok(documents.ToList().ConvertAll(BsonTypeMapper.MapToDotNetValue));

edited Dec 6, 2019 at 6:48

answered Dec 6, 2019 at 6:32

Athanasios Kataras

26.7k6 gold badges40 silver badges67 bronze badges

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

2 Comments

Abhi Over a year ago

documents.ConvertAll() showing error. IMongoQueryable<BsonDocument> does not contain a definition for 'ConvertAll' and no accessible extension method 'ConvertAll' accepting a first argument of type.....

Athanasios Kataras Over a year ago

Try to convert to list first.

Collectives™ on Stack Overflow

How to retrieve data in proper JSON format from MongoDB in C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related