in mongodb 3.0 c# 2.0 driver, how distinct list of values using distinctasync
document's array of sub documents?
i'm looking c# equivalent of in shell:
db.cars.distinct("parts.name", {"make":"ford"})
after admitting defeat, resorted shell-ish code:
var distinctparts = await db.runcommandasync<bsondocument>(new bsondocument { { "distinct", "cars"}, {"key", "parts.name"}, {"query", new bsondocument { { "make", "ford" }} } });
thanks!
something should work:
var filter = new mongodb.driver.expressionfilterdefinition<cars_type>(x => x.make == "ford"); var distinctparts = await cars_collection.distinctasync<string>("parts.name", filter);