How to update object using where condition in CosmoDb with DocumentDb api

Question

Using CosmoDb with MongoDb api from c# I can update a document with filter condition rather than using the Id. For example this code work fine with CosmoDb with MongoDb api.

        public bool UpdateTask(MyTask myTask)
    {
        var mongoCollection = GetBsonCollectionForEdit();
        var builder = Builders<BsonDocument>.Filter;

        var filterName = builder.Eq("Name", myTask.Name);
        var filterCategory = builder.Eq("Category", myTask.Category);
        var filter = builder.And(new[] { filterName, filterCategory });

        var replaceUpdate = Builders<BsonDocument>.Update;
        var ret = mongoCollection.ReplaceOne(filter, myTask.ToBsonDocument());

        return ret.ModifiedCount == 1;
    }

Can I do the same thing with CosmoDb using the SQL DocumentDb api ? (Without implement UDF or StoredPoc)

Thanks

Aravind Krishna R. · Accepted Answer · 2017-10-21 20:52:24Z

1

No, but you can perform a query for the criteria using CreateDocumentQuery, then iterate through the matching IDs and perform an update on each of them using ReplaceDocumentAsync.

answered Oct 21, 2017 at 20:52

Aravind Krishna R.

8,00332 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to update object using where condition in CosmoDb with DocumentDb api

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related