How to retrieve nested array element from MongoDB using C#

Question

Now I have one entity and a nested array

public class Author {
    public ObjectId Id { get; set; }
    public String Name { get; set; }
    public IEnumerable<Book> Books { get; set; }
}

public class Book {
    public ObjectId Id { get; set; }
    public String ISBN { get; set; }
}

and pre defined mongodb collections like

var authors = mongodbDatabase.getCollection<Author>("Authors");

Here's the problem, is there a way to directly retrieve one or some "Book" from MongoDB with specified "Author" (not to retrieve the entire "Author" then LINQ the books I want)

Mahdi · Accepted Answer · 2017-05-15 13:08:24Z

2

You can use Projection as follows:

var filter = Builders<Author>.Filter.Eq("Books.ISBN", "987654321");
var projection = Builders<Author>.Projection.Include("Books.$").Exclude("_id");
var book = context.AuthorCollection.Find(filter).Project(projection).SingleOrDefault();

This will return a BsonDocument which has the book.

answered May 15, 2017 at 13:08

Mahdi

3,3892 gold badges29 silver badges37 bronze badges

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

2 Comments

BH4EHN Over a year ago

Thanks for reply. From the code, is it means the Project() method with Projection.Include() tells MongoDB driver to return only the fields specified?

Mahdi Over a year ago

Yes, correct. You can see more examples here: mongodb.github.io/mongo-csharp-driver/2.0/reference/driver/…

Okan SARICA · Accepted Answer · 2020-09-04 11:12:06Z

2

A different way without any static string

var filter = Builders<Author>.Filter.ElemMatch(p=>p.Books,t=>t.ISBN == "987654321");
var projection = Builders<Author>.Projection.Include(p=>p.Books[-1]);
var author = context.AuthorCollection.Find(filter).Project<Author>(projection).SingleOrDefault();

Please note that the data you need will return as an author and you can reach it from author.Books

answered Sep 4, 2020 at 11:12

Okan SARICA

3274 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to retrieve nested array element from MongoDB using C#

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related