MongoDB C# - Make list of different items

Question

Let's assume I have a class like this:

class MyObject
{
    public string Color { get; set; }
    ....
}

and I have a collection of MyObject in MongoDB.

How can I go through the collection and make a list of all the unique colors?

At the end, I'd like a List that contains one entry per color { "yellow", "pink" } for example.

Kdawg · Accepted Answer · 2017-07-20 03:32:39Z

0

You want to get the distinct values from the color field (assuming you use the standard serialization names). See C# MongoDB Distinct Query Syntax for examples of how to do that.

I believe this should work, but have not tested it, assuming that collection is your collection object: var colors = await collection.DistinctAsync<List<string>>("color", "{}").ToListAsync();

answered Jul 20, 2017 at 3:32

Kdawg

1,51813 silver badges20 bronze badges

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

1 Comment

Thomas Over a year ago

I had never seen the "distinct" method; thanks! let me look into that and I'll report back.

Collectives™ on Stack Overflow

MongoDB C# - Make list of different items

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related