Projection of mongodb subdocument using C# .NET driver 2.0

Question

I have the following structure:

public class Category
{
    [BsonElement("name")]
    public string CategoryName { get; set; }

    [BsonDateTimeOptions]
    [BsonElement("dateCreated")]
    public DateTime DateStamp { get; set; }

    [BsonElement("tasks")]        
    public List<TaskTracker.Task> Task { get; set; }
}

public class Task
{
    [BsonElement("name")]
    public string TaskName { get; set; }

    [BsonElement("body")]
    public string TaskBody { get; set; }
}

I am trying to query a Category to get all the TaskName values and then return them to a list to be displayed in a list box.

I have tried using this query:

var getTasks = Categories.Find<Category>(x => x.CategoryName == catName)
                         .Project(Builders<Category>.Projection
                                                    .Include("tasks.name")
                                                    .Exclude("_id"))
                         .ToListAsync()
                         .Result;

But what get returned is: {"tasks": [{"name: "test"}]}.

Is there anyway to just return the string value?

Craig Wilson · Accepted Answer · 2015-04-18 19:56:28Z

33

As Avish said, you have to use the aggregation API to get the resulting document to look like you are wanting. However, the driver can make some of that disappear for you if you use the expression tree API for project as you have done for Find. For instance, I believe the following should work for you:

var taskNames = await Categores.Find(x => x.CategoryName == catName)
    .Project(x => x.Tasks.Select(y => y.Name))
    .ToListAsync();

This should just bring back an enumerable of strings (tasks.name) for each category. The driver will be inspecting this projection and only pull back the tasks.name field.

answered Apr 18, 2015 at 19:56

Craig Wilson

12.7k3 gold badges45 silver badges45 bronze badges

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

7 Comments

Lynchy Over a year ago

I have tried your query and have tried adding it to a List<IEnumerable<string>> but what gets returned is: '{System.Linq.Enumerable.WhereSelectEnumerableIterator<MongoDB.Driver.Linq.Translators.ProjectedObject,string>}'

Craig Wilson Over a year ago

Yes, that is convertible to an IEnumerable<string>. Could you provide some more code about what you are doing?

Lynchy Over a year ago

I think I have found a solution. I returned taskNames query like this: return taskNames[0].ToList(); and that seemed it work. Is this good practice?

Craig Wilson Over a year ago

Sure... at his point, all the data is in memory, so do with it what you want.

Craig Wilson Over a year ago

There is. This answer demonstrates exactly that. It will only bring back the "tasks.name" field.

|

Avish · Accepted Answer · 2015-04-18 19:23:40Z

MongoDB doesn't really support projections the way SQL databases do; you can ask for a partial document, but you'd still get back something that matches the schema of the document you were querying. In your case, you're getting back only the tasks field, and for each task, only the name field.

You can easily transform this into a list of strings using plain LINQ:

var categoryTasks = Categories.Find<Category>(x => x.CategoryName == catName)
                     .Project(Builders<Category>.Projection
                                                .Include("tasks.name")
                                                .Exclude("_id"))
                     .ToListAsync()
                     .Result;   

var taskNames = categoryTasks.Tasks.Select(task => task.Name).ToList();

Alternatively, you can do some fancy stuff with the aggregations API (which does support custom projections, kinda), but that would probably be overkill for you case.

Collectives™ on Stack Overflow

Projection of mongodb subdocument using C# .NET driver 2.0

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related