MongoDB and C# Find()

c#, mongodb, mongodb-query

Solution

To find a record you could use Lambda in find, for example:

var results = collection.Find(x => x.name == "system").ToList();

Alternatively you can use Builders which work with strongly typed Lambda or text:

var filter = Builders<User>.Filter.Eq(x => x.name, "system")

Or

var filter = Builders<User>.Filter.Eq("name", "system")

And then use find as above

// results will be a collection of your documents matching your filter criteria

// Sync syntax
var results = collection.Find(filter).ToList();

// Async syntax
var results = await collection.Find(filter).ToListAsync();

Problem

I have the below code and I am new to mongodb, I need help in finding an specific element in the collection. ``` using MongoDB.Bson; using MongoDB.Driver; namespace mongo_console { public class User { public ObjectId Id { get; set; } public string name { get; set; } public string pwd { get; set; } } class Program { static void Main(string[] args) { MongoClient client = new MongoClient(); MongoServer server = client.GetServer(); MongoDatabase db = server.GetDatabase("Users"); MongoCollection<User> collection = db.GetCollection<User>("users"); User user = new User { Id = ObjectId.GenerateNewId(), name = "admin", pwd = "admin" }; User user2 = new User { Id = ObjectId.GenerateNewId(), name = "system", pwd = "system" }; collection.Save(user); collection.Save(user2); /* * How do I collection.Find() for example using the name */ } } } ``` Once I find the user I will like to print it, is that posible or will find only return the position? if so, how do I print it? I have seen some examples collection.Find(x => x.something) but I do not know what that x is or mean

Original source