I've searched the world over and can't seem to find the answer to this.
How do I do this in C#:
// retrieve ssn field for documents where last_name == 'Smith':
db.users.find({last_name: 'Smith'}, {'ssn': 1});
Thanks!
-
OK, well, I was misreading an example elsewhere, but just for the record, here is the solution: users.FindAs<User>(Query.EQ("_id", "[email protected]")) .SetFields(Fields.Include(new string[] { "first_name", "last_name" }))Christopher Davies– Christopher Davies2011-06-30 19:52:31 +00:00Commented Jun 30, 2011 at 19:52
-
2possible duplicate of Mongodb -- include or exclude certain elements with c# driveri3arnon– i3arnon2014-07-12 13:03:52 +00:00Commented Jul 12, 2014 at 13:03
-
Hm. Kind of the other way around, really. This thread is older, but they are dups of each other.Christopher Davies– Christopher Davies2014-07-13 21:17:57 +00:00Commented Jul 13, 2014 at 21:17
-
The other question has a better answer though, and that's what should count. meta.stackoverflow.com/a/252017/885318i3arnon– i3arnon2014-07-13 21:26:38 +00:00Commented Jul 13, 2014 at 21:26
Add a comment
|
2 Answers
To include:
.SetFields(Fields.Include("first_name", "last_name"));
To exclude fields:
.SetFields(Fields.Exclude("SSN","Salary"));
To do both:
.SetFields(Fields.Include("first_name", "last_name").Exclude("SSN","Salary"));
Comments
Note that you can now use a (type/refactoring)-safe version:
usersCollection.FindAllAs<User>()
.SetFields(Fields<User>.Include(user => user.FirstName,
user => user.LastName)
.Exclude(user => user.SSN)
.ToArray();
