DistinctAsync against array sub documents with MongoDB C# 2.0 driver

Question

In MongoDB 3.0 with the C# 2.0 driver, how do you get a distinct list of values using DistinctAsync from a document's array of sub documents?

I'm looking for the C# equivalent of this in the shell:

db.cars.distinct("parts.name", {"make":"Ford"})

After admitting defeat, I resorted to this shell-ish code:

var distinctParts = await db.RunCommandAsync<BsonDocument>(new BsonDocument {
    { "distinct", "cars"}, 
    {"key", "parts.name"},
    {"query", new BsonDocument { { "make", "Ford" }} } });

Thanks!

What about await db.DistinctAsync<MyType>(...) is not working for you, and what error(s) does it produce? — Alex
– Alex, Commented Apr 27, 2015 at 22:14

Mortaza Doulaty · Accepted Answer · 2015-05-05 20:09:00Z

1

Something like this should work:

var filter = new  MongoDB.Driver.ExpressionFilterDefinition<CARS_TYPE>(x => x.make == "ford");
var distinctParts = await cars_collection.DistinctAsync<string>("parts.name", filter);

edited May 5, 2015 at 20:09

answered May 5, 2015 at 19:18

Mortaza Doulaty

931 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

DistinctAsync against array sub documents with MongoDB C# 2.0 driver

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