current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 4 down vote favorite
1

I created a script in SSIS to retrieve data from MongoDB. While I don't have any issues querying regular documents, I am not sure how to retrieve values from nested documents. For example, "Address" expanded contains "Country", "State", "City", "Street", and "Zip". I am interested in retrieving the "Country" (field) values only. In theory, I understand that it should be something like "Address.Country", but I do not know how to implement it in my code. What is the best way to achieve that?

This is the code that retrieves all the other documents:

    public override void CreateNewOutputRows()
    {
        string connectionString = "mongodb://localhost";
        MongoServer myMongo = MongoServer.Create(connectionString);
        myMongo.Connect();
        var db = myMongo.GetDatabase("UserDB");
        /*ICursor<BsonDocument> cursor = db.GetCollection<BsonDocument>("UserDB").FindAll();*/
        foreach (BsonDocument document in db.GetCollection<BsonDocument>("UserDB").FindAll())
        {
            this.UserDBBuffer.AddRow();
            this.UserDBBuffer.ID = document["_id"] == null ? "" : document["_id"].ToString();

            this.UserDBBuffer.PrimaryEmail = document["primary_email"] == null ? "" : document["primary_email"].ToString();
            this.UserDBBuffer.Gender = document["gender"] == null ? "" : document["gender"].ToString();

        }
}
share|improve this question

2 Answers 2

up vote 2 down vote

You can do that in C# using SetFields on the cursor returned by FindAll:

var fields = Fields.Include("Address.Country");
foreach (var document in collection.FindAll().SetFields(fields))
{
    Console.WriteLine(document.ToJson());
}

You can extract the Country value from the returned document using:

var country = document["Address"].AsBsonDocument["Country"].AsString;
share|improve this answer
    
Thank you! This is exactly what I needed! –  Pasha Jan 4 '12 at 4:37
    
Now, the next challenge is how to extract data from an array. For example, one of the arrays looks like this: "devices -> Document -> device_data -> model" or "devices -> Document -> device_data -> brand". How do I extract the model or the brand of the device? Again, thanks a lot for your help! –  Pasha Jan 4 '12 at 4:40
    
I changed "Address" to "location" (another field containing country) and my scripts returns "country not found" and I can't figure out why... –  Pasha Jan 4 '12 at 5:34
up vote 0 down vote 
db.users.find({_id: user_id},
              {'address.country': 1});

This will get you a document like 

{"_id": ObjectId('4efb78234ee9184d8b5a4e92'), 
 "address": {"country": "Russia"}}
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.