Get object from mongodb c#

Question

Hello I am trying to query my database to get an object. I followed a guide and it seems everyone is just using a foreach on the whole collection, is this how its supposed to be done?

public void asd()
        {
            MongoClient _client = new MongoClient();
            IMongoDatabase _database = _client.GetDatabase("BlogDB");

            IMongoCollection<Blog> collection = _database.GetCollection<Blog>("Blog");

            var filter = new BsonDocument();
            var result = collection.Find(filter)
                 .Project(Blog => Blog.Posts)
                 .ToList();
            foreach (Posts post in result.FirstOrDefault())
            {
                if (post.postid == postid)
                {
                    //Do something with post E.g post.myfunction();
                }
            }
        }

Is there no way to get only the specific post from a query?

I tried to use a filter but collection.Find(filter) still returns a collection with my whole bsondocument.

Saleem · Accepted Answer · 2016-03-21 16:43:50Z

1

How about simplifying code little bit. Since you need single matching document,

Replace

var result = collection.Find(filter)
     .Project(Blog => Blog.Posts)
     .ToList();
foreach (Posts post in result.FirstOrDefault())
{
    if (post.postid == postid)
    {
        //Do something with post E.g post.myfunction();
    }
}

With

var post = collection.Find(filter)
     .Project(Blog => Blog.Posts)
     .Limit(1)
     .FirstOrDefault();

edited Mar 21, 2016 at 16:43

answered Mar 21, 2016 at 16:35

Saleem

9,0582 gold badges22 silver badges34 bronze badges

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

Comments

realnero · Accepted Answer · 2016-03-21 15:08:36Z

0

You can use the following code

public Posts Get(int id)
    {
        var builder = Builders<Posts>.Filter;

        var query = builder.Eq(x => x.postid, id);
        return collection.Find(query).SingleOrDefaultAsync().Result;
    }

answered Mar 21, 2016 at 15:08

realnero

9946 silver badges12 bronze badges

1 Comment

Jacob Over a year ago

How can i return a Posts from collection Blog? If i change my collection to IMongoCollection<Posts> collection = _database.GetCollection<Posts>("Blog"); It compiles but i get null as a reference..

Collectives™ on Stack Overflow

Get object from mongodb c#

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related