Updating multiple objects in array in c# [duplicate]

Question

I have an object like that:

public class Foo {
     public string Id {get;set;}
     public List<Bar> Bars {get;set;}
}

public class Bar {
     public string Id {get;set;}
     public bool Read {get;set;}
}

I would like to update multiple bars basead on a list of bar ids. I am trying to do something like that, but it only updates one record instead of multiple:

public bool MarkAsRead(string fooId, List<string> barIds)
        {
            var @in = new FilterDefinitionBuilder<Bar>().In(x => x.Id, barIds);

            var filter = Filter().Eq(x => x.Id, fooId) & Filter().ElemMatch(x => x.Bars, @in);

            var update = UpdateFilter()
                .Set(x => x.Bars[-1].Read, true);

            var result = collection.UpdateOne(filter, update);

            return result.MatchedCount > 0;
        }

How can I do that?

Have you seen this? stackoverflow.com/questions/48868243/… — dnickless
– dnickless, Commented May 15, 2018 at 19:50

dnickless · Accepted Answer · 2018-05-15 20:34:52Z

4

Here's a version that works for me using the latest version of the driver (v2.7) - I think it works from v2.5 onwards:

public bool MarkAsRead(string fooId, List<string> barIds)
{
    Expression<Func<Foo, bool>> filter = f => f.Id == fooId;
    var update = Builders<Foo>.Update.Set("Bars.$[i].Read", true );
    var arrayFilters = new List<ArrayFilterDefinition> { new JsonArrayFilterDefinition<Bar>("{'i._id': { $in: ["+string.Join(",", barIds.Select(s => string.Format("\"{0}\"", s)).ToArray())+"]}}") };
    var updateOptions = new UpdateOptions { ArrayFilters = arrayFilters };

    var result = collection.UpdateOne(filter, update, updateOptions);

    return result.MatchedCount > 0;
}

answered May 15, 2018 at 20:34

dnickless

10.9k1 gold badge22 silver badges35 bronze badges

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

3 Comments

MuriloKunze Over a year ago

Thanks, do you know if it is possible using just Expression instead of strings? I was string trying but no sucess.

dnickless Over a year ago

That's currently impossible. Only BSON and JSON can be used for array filters.

dnickless Over a year ago

You might perhaps be able to implement your own version of an ArrayFilterDefinition, - not sure, got no VS just now.

Collectives™ on Stack Overflow

Updating multiple objects in array in c# [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related