c# and mongodb include or exclude element of array using projection

Question

Given the document in my cloud mongoDB

{
 
 _id: ObjectId("5effaa5662679b5af2c58829"),
 email: “[email protected]”,
 name: {given: “Jesse”, family: “Xiao”},
 age: 31,
 addresses: [
              {
               label: “home”,
               street: “101 Elm Street”,
               city: “Springfield”,
               state: “CA”,
               zip: “90000”,
               country: “US”
              },
             { 
               label: “mom”,
               street: “555 Main Street”,
               city: “Jonestown”,
               province: “Ontario”,
               country: “CA”
              }
            ]
              
}

im creating a program using c# where i want to display all the elements in the collection. im new and following the documentation (https://mongodb.github.io/mongo-csharp-driver/2.2/reference/driver/definitions/) i cant figure how to only display the email element and the addresses showing only [label][city][country].

when i try this, i get all the information in addresses.

var projection = Builders<BsonDocument>.Projection.Include("email").Include("addresses").Exclude("_id");

how can i retrieve the addresses' label, city and country and exclude the rest?

Thanks a lot!

Yong Shun · Accepted Answer · 2022-03-20 03:59:27Z

0

Specify the nested fields in the array to be included with dot notation.

var projection = Builders<BsonDocument>.Projection
                .Include("email")
                .Include("addresses.label")
                .Include("addresses.city")
                .Include("addresses.country")
                .Exclude("_id");

Output

answered Mar 20, 2022 at 3:59

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

c# and mongodb include or exclude element of array using projection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related