MongoDB C# Query Select specific keys from document

Question

How can i do this from c# mongoDb drivers.

sql query :SELECT a,b FROM users

mondb javascript query : db.users.find({}, {a:1,b:1})

possible duplicate of [How to retrieve a subset of fields using the C# MongoDB driver?](http://stackoverflow.com/questions/6540160/how-to-retrieve-a-subset-of-fields-using-the-c-sharp-mongodb-driver) — mookid8000, Feb 02 '12 at 13:25

score 3 · Accepted Answer · answered Feb 02 '12 at 19:26

How about this:

 var database = MongoDatabase.Create(connectionString);
 var userCollection = database.GetCollection<Exercise>("users");
 var users = userCollection.Find().SetFields("a", "b");

If I understand your question correctly .SetFields does what you want.

MongoDB C# Query Select specific keys from document

1 Answers1