如何查找和更新数组中的项(数组中的对象){Accounts[x]. items [y].StatusCode = ..}

本文关键字：数组 StatusCode Accounts items 查找 何查找 更新 对象 | 更新日期: 2023-09-27 18:01:40

我有一个简单的嵌套数组(如下)。我的目标是在c#中将这些项目表示为包含"Item"列表以及其他帐户信息的"Account"对象。我可以在MongoDB中设置此结构，但我不知道如何在单个帐户上更新单个项目的StatusCode。

{  
   "Accounts":[  
      {  
         "Name":"SomeName1",
         "Email":"email1@site.com",
         "OwnedItems":[  
            {  
               "ItemId":55,
               "StatusCode":1
            },
            {  
               "ItemId":12,
               "StatusCode":2
            }
         ]
      },
      {  
         "Name":"SomeName2",
         "Email":"email2@site.com",
         "OwnedItems":[  
            {  
               "ItemId":100,
               "StatusCode":3
            },
            {  
               "ItemId":101,
               "StatusCode":4
            }
         ]
      }
   ]
}

我的问题是我如何查询查找和更新一个特定的StatusCode在这个设置?

基本上我想做的是如下。当然，下面的代码实际上不会更新DB。

public void Update_StatusCode(string accountName, int itemId, int newStatusCode)
{
    var foundAccount = collection.Find(Builders<AccountSave>.Filter.Eq(acc => acc.Name, accountName)).FirstOrDefaultAsync().Result;
    foreach (var item in foundAccount.OwnedItems)
    {
        if (item.ItemId == itemId)
            item.StatusCode = newStatusCode;
    }
}
编辑:澄清一下，我使用的是2.0驱动程序。此外，是的，我知道没有'_id's。作为一个例子，假设它们被正确使用。

如何查找和更新数组中的项(数组中的对象){Accounts[x]. items [y].StatusCode = ..}

您可以加入条件

public async Task UpdateStatus(string accountName, int itemId, int newStatusCode)
{
    var filter = Builders<Account>.Filter.And(
        Builders<Account>.Filter.Where(x => x.Name == accountName),
        Builders<Account>.Filter.ElemMatch(x => x.OwnedItems, x => x.ItemId == itemId));
    var update = Builders<Account>.Update.Set("OwnedItems.$.StatusCode", newStatusCode);
    await collection.UpdateOneAsync(filter, update);
}

您也可以使用lambda表达式:

public async Task UpdateStatus(string accountName, int itemId, int newStatusCode)
{
    var filter = Builders<Account>.Filter.And(
        Builders<Account>.Filter.Where(x => x.Name == accountName),
        Builders<Account>.Filter.ElemMatch(x => x.OwnedItems, x => x.ItemId == itemId));
    // -1 means update first matching array element
    var update = Builders<Account>.Update
                 .Set(x => x.OwnedItems[-1].StatusCode, newStatusCode);
    Console.WriteLine(update.Render(collection.DocumentSerializer, collection.Settings.SerializerRegistry).ToString());
    // { "$set" : { "OwnedItems.$.StatusCode" : 123 } }
    await collection.UpdateOneAsync(filter, update);
}

来源:http://www.mattburkedev.com/updating-inside-a-nested-array-with-the-mongodb-positional-operator-in-c-number/

相关文章：